Hello,
I have created a simple app that has a “Meals” table in Google Sheets and an “Additions” table in a second tab in the same sheet. The “Additions” table has its own Key column which is initialized with UNIQUEID() and a “Meal” Ref column that refers to the “Meals” table. Note that the “Meal” Ref column is not shown.
When using the unpublished app, when I use the “Add” link to add a new “Addition” to a “Meal”, more often than not, the new “Addition” appears in the list of referenced rows, but when I press the sync button, the row vanishes. Looking at the data, the “Meal” column is not populated.
Any ideas why this may be happening and how to fix it?
Thanks
Miles
LinkedIn
Twitter
