I have an app used to track cleanings, with the ability to request, start, and then complete the cleaning, each with a timestamp. I have tracked down a bug whereby a cleaning is requested, then completed by another user. Days later, the original requester reopens the app, which syncs and then duplicates the add new row action. However, this duplicate action does not create a duplicate row; instead, it clears the original row of any updates that have occurred since the original add row action. See the audit log below which shows the same row being added twice (I’ve validated the times on the spreadsheet cell change history). Is this a known bug, or a result of some automation? How can I prevent this from happening?
Perhaps the app is generating duplicate values for that table’s key column values? What is the table’s key column and how does it get its values?
2 Likes
Also: if you’re using manual automation triggers, check that you’re clearing the trigger.
- If you have a trigger something like: [Status] = “Whatever”
- Whenever something else happens to that record, this condition will be met AGAIN… and that’s when you can have weird things like this pop up.
1 Like
Hello again,
Could you please clarify “manual automation triggers”? These add row actions are not automated, it requires a button press by the user. In this image, you can see that all these actions duplicated for a submission that was from November 30th when the user reopened their app, as can be seen from the last sync timestamp. For extra clarity:
-
November 30th, the user created a new row. This row was visible to other users and can be seen in the Spreadsheet edit history
-
Other users interacted with the entry, which updated other fields in the row.
-
December 23rd, the original user opened the app and the new row action repeated erroneously, which cleared other fields in the row. Why would appsheet duplicate manual actions that a user already completed weeks earlier? How can I block this from happening? To clarify, the initial action is the manual form submission that is native to appsheet, nothing that has been customized.
