I need some help please, and hope this is easy to solve - you know when you just look at something for too long!
I’m getting used to the new Glide Tables, and loving how responsive they are. (I just wish there was a feature to Migrate the columns from an existing Sheet (supported by Google) to a Glide Table to save time creating many columns and settings (but that is for another time)!
Alas, the issue I am facing is as follows:
- I have a Recipe Glide Table - All users can access the pre-loaded Recipes (Done)
- I have a User_Recipe Glide Table - Controlled by Email Row Owner where users can access their own recipes (Done)
- I need a Combined view of the Recipe Names in 1) and 2) in a new Glide Table - How do I do this? as there is no reference linking the two tables.
Previously, I would use an Arrayformula to achieve this in Google Sheets and build up the list of Recipe Names from the two sheets in a “Combine” sheet. Ideally there would be a way for me to save to two or more different Tables in the Glide form to Achieve this?
Or, is there a way to somehow combine Table 1) and 2) above into One table? Not sure this is possible due to the Email being the Row Owner for one of them, so would never get Recipes for 1) displaying?
I hope this in not too ambiguous. Any help or suggestions would be very much appreciated!
PS. Did I mention I’m loving the performance of Glide Tables?