Hi, everyone and thank you for your time. I have a simple Excel sheet to track technicians and jobs done in our tiny family business. I have added an ID column and given an ID number in sequence. I also added UNIQUEID() in initial values. New records save fine and generate an ID for the row.
When I edit an old record to update the info I get an error and the app can't save the updated new info. Where am I going wrong. I have tried in various places but have hit a brick wall.
Many thanks for your patience and help.
Best wishes
Mac
Bologna Italy
Solved! Go to Solution.
Initial Values only evaluate when a record is first created. If you have old records without a key value, you should probably insert those values manually into the backend data source (spreadsheet?).
Initial Values only evaluate when a record is first created. If you have old records without a key value, you should probably insert those values manually into the backend data source (spreadsheet?).
โ
Thanks for the answer, i had created an ID column and added an ID key for all of the records already present. When I go to modify an existing record I get the error which I am attaching as a screenshot. I do apologise I am a complete novice to Appsheet. The edits remain (in the app as per screenshot) but won't update the sheet.
โ
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |