In response to your technical question #1:
It’s easy to add columns to a table… Now I need to add 1100 rows / records to this table. How do I do this without starting from scratch, and losing all the configuration work? Manually adding rows doesn’t generate a key for those entries.
I use the following formula in Google Sheets on my ID column
- Drag down the cell that contains the formula for all 1100 rows.
- After you have populated the column with the formula, select the entire column besides the header row, copy, then Paste Special - ‘Paste Values Only’.
- Make sure when you select an id cell, it shows the unique ID and not the formula. At this point you now want to enter the UNIQUEID() expression in the initial value in Appsheet for the ID column and mark that column as the ‘Key’ in Appsheet. These steps ensure that Appsheet will generate the unique id moving forward in the app and not Google Sheets.
- Tip - not required- I click on the whole id column and change the column type from ‘Automatic’ to ‘Plain Text’. I have run into problems before not doing so for very large data sets.
I got all of this from Appsheet’s help article:
Manually Generating UNIQUEID() Key Values
Use VLookup or Index and Match formula combination to ‘redo’ your multiple table child references if this is applicable.
You will be very happy with Appsheet over App Maker.
Hope this helps!