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?