I’ve got a Google Form that populates a Google Sheet. I want to use the Google Sheet info as a database source for Appsheet, but I need a unique key for each record. I considered using the timestamp as the key but have seen posts saying that is not recommended. How do I get another field in that table that has a unique value to use as a key?
I’ve seen a solution where we can use an array command in the top cell of a column, but if records are deleted from that sheet, the key changes after each reload (not acceptable).
Theres also the possibility to import the google form directly into appsheet. Then, when a new answer is submitted to the form it automatically arrives in appsheet without having to use a sheet first.
Of course you then have full access to bots that could for instance write the newly arrived form submission to a proper table with it’s own uniqueid() setting.
That’s the way to go! I tested it with a Google Form and Appsheet automatically added a key field with a LONG text key for each record. Thanks so much!