How can I add records to a sheet when my key ...

(Rob atYahoo) #1

How can I add records to a sheet when my key is a calculated column from spreadsheet?

In my source spreadsheet I use a column with a formula like the following to create a unique Key that is useful as an overall job descriptor =J32 & " " & E32 & " " & G32 & ", " & H32

In AppSheet I have made this a Read Only field as I don’t want to edit the formula in the field but that means I cannot add records - I get an error warning to say I can’t have a Read Only field as a Key.

Is there a way I can get around this?

(Aleksi Alkio) #2

Is it possible to create that key column with the app formula instead?

(Rob atYahoo) #3

Thanks Aleksi. I can do that but, if I understand it correctly, Appsheet will create the key as a value rather than formula so if I later change one of the fields the Key will not change.

(Aleksi Alkio) #4

Understood. How about using the UNIQUEID() as a key? It’s not a good design if you are changing the key. With an additional column you could handle this situation.