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

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?

0 2 316
2 REPLIES 2

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

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

Top Labels in this Space