Hey guys!
I need help with this situation, some of my action buttons should be available if there are specific conditions in some columns.
And my application has a 5 second delay in synchronizing, if I click once more when the application is synchronizing the action will start again duplicating the data.
I need to disable the buttons in this 5 second sync interval.
Solved! Go to Solution.
On your main data table, add a new field and call it say 'Syncing'. Give it a Yes/No column type and set its Default to FALSE.
Your Action buttons should have a Behaviour setting of [Syncing] = FALSE. This means they will be displayed ONLY when that field value is FALSE. You can combine this field along with any other logic for the buttons to show using an AND() expression.
Whatever the Action button does to trigger your changes, it should also set the value of Syncing to TRUE amongst the other things it does.
I am assuming that your data changes are accomplished by a BOT or perhaps a set of Grouped Actions. It does not matter really which as the final stage of the Bot/Action will be to set the value of [Syncing] to be FALSE again.
This will have the following behaviour:
Action is Showing : User triggers Action : Action Disappears : Data Change Routine Begins : Data Change Routine Ends : Action Appears
On your main data table, add a new field and call it say 'Syncing'. Give it a Yes/No column type and set its Default to FALSE.
Your Action buttons should have a Behaviour setting of [Syncing] = FALSE. This means they will be displayed ONLY when that field value is FALSE. You can combine this field along with any other logic for the buttons to show using an AND() expression.
Whatever the Action button does to trigger your changes, it should also set the value of Syncing to TRUE amongst the other things it does.
I am assuming that your data changes are accomplished by a BOT or perhaps a set of Grouped Actions. It does not matter really which as the final stage of the Bot/Action will be to set the value of [Syncing] to be FALSE again.
This will have the following behaviour:
Action is Showing : User triggers Action : Action Disappears : Data Change Routine Begins : Data Change Routine Ends : Action Appears
To address this problem, AppSheet could implement a CONTEXT("sync") function that returns TRUE or FALSE. This would eliminate the need for multiple sync operations in the existing workaround, which currently involves unnecessary updates and delays for users. This change would significantly reduce the time required for simple data changes and improve the user experience.
This is a strange request. I do not think that is actually what you need. I recommend explaining a bigger picture of what you're trying to do in order to get a better suggestion.
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |