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?
Is it possible to create that key column with the app formula instead?
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.
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.
User | Count |
---|---|
39 | |
29 | |
23 | |
23 | |
13 |