You’re welcome.
@david @Mark @Jason This is a good example of why we need the Choice Component to have keyed pairs like this post describes. Choice Component - allow key display pairs
Instead of using the Form component for this app one could have just used plain old adds for any of the various sheets. Then for any and all data elements that have links via keys it would be a simple matter of adding multiple choice components. So again for this example the Actors sheet would only need two columns in the Google spreadsheet, the UUID key for the Play and the Actor. All the other information could be had in the application via Glide created columns for Relations and Lookups. Using something like the actual Actors name for the key is not a good idea in any relational database, which is ultimately what the data is being changed into.
1 Like