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?
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |