I have Errors implicit (RowNumber) key.
I have clicked for more info but it’s a little over my head.
I’ve attached screen shot.
Additional Question:
I would like to set up workflow (save to File) when updated… how can I turn off auto update. So my employees can click update… once all data is changed for the day, as they may be changing throughout the day and I only want one report at the end of day.
The Row Number messages are warnings, I think eventually they may go away.
One of the main reasons why Row Number as a key is not a good idea is because it is not guaranteed each row will get the same row number each time the app loads.
To avoid this is simple. Add an ID column to each table and set the Initial Value to “UNIQUEID()” (the expression may even auto-populate for you when you re-gen the table). As each row is added it will get a unique identifier assigned. Set the ID column as the key.
To update rows already in the tables you can do one of two things:
Generating the Report at the End of the Day
There are a few options.
By far, the simplest is to use the Report feature in AppSheet. It is much like Workflows. You can schedule the report to be generated each day at a scheduled time. For example, you could schedule a report to be run at 7 PM when most likely no one is entering more information.
Would that work for you?
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |