New records store Ref field Key UNIQUEID() va...

references
(Eric Schwartz) #1

New records store Ref field Key UNIQUEID() values as numbers in exponential form in Google Sheet, when the reference key value corresponds to a number, breaking the source table text key value reference.

Is there a workaround or setting in AppSheet or Google Sheet?

(Steven Coile) #2

The spreadsheet column format should be Plain text, not Automatic.

(Eric Schwartz) #3

Thanks Steve. Assuming AppSheet applies format to new records it creates. Have seen otherwise for new records created in AppScript.