Generating random key from Google Form to spreadsheet that Appsheet reads

[NCBOM]

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). 

I'm open to any suggestions!

Thanks,  Wick

[scott192]

The timestamp from Google forms will be fine I think.

[scott192 · Accepted solution]

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.

[NCBOM]

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!