Im creating a fleet Management and compliance app. I have a Table of ‘Compliance Tasks’ that are updated via a separate Log table. The issue is when the Log form is saved as a form saved behaviour triggers an update of the Next Due Date on a specific row on the ‘Compliance Tasks’ Table. On form submission the detail view for the specific Compliance Task row updates to the new Next Due Date immediately, however after 10 - 15 seconds it reverts to the old date again. It then takes several goes of pushing the Synch button to get it to update back to the correct date. And it often takes a while for the Workbook Sheets to update. Im Using excel as the database as this is historically what our company uses to store data. Any ideas how to make this action update immediately and not give users the impression the Task Log update didnt work?
Are you using an action or Bot to update the record?
I set up a bot to run the action. But had similar results with a series of actions from a form saved behaviour. I have since given up on excel and transferred Data to google sheets. It has improved a lot.