Who changes the user variable to 0: You or Integromat?
Do you have a confirmation value (flag) from Integromat to be sure that your scenario was successful? Or you assume always that your Integromat action was executed fine and you reset your value in GS no mater what happend?
I change the variable to 0: is step 4
I don’t have a confirmation value because up until 20 days ago I had no problems
I have the email that arrives with the order number which confirms that the scenario on zapier has been successful
Yes, i use Zapier
Yes, The problem is that the restaurant has received the same order 16 times
Unfortunately I can’t create the problem and understand why it only happened to some users
This is the zapier log
Your Variable Column is set to 1 as flag to indicate the process is running, later you call a Webhook and finally, you reset the flag (0) to notify customer that everything is done… right?
The problem here is that Glide doesn’t wait for Zapier (there is no pause) and your Column has 2 values so fast that technically you will see the last value (0) always …
Although the Actions work as a sequence, each step is executed without waiting the previous one. To sum up, there is no a kind of pause or delay between 2 steps.
What about if you force that “completion flag” creating a new step in Zapier? Try making a completion flag in Zapier writing a 0 (or any value) into a cell in your GS. If that cell is different to empty then, the action was completed!
My problem is that the value stays at 1 instead of returning to 0
I do not need to wait for the zap to complete, but simply to lock the button so that it does not press more than once, then by setting the variable to 1 the key disappears … by setting the variable to 0 the key reappears … the problem is that the variable stays at 1
I can try to change the value via a new zap … but it really gets too long
So in that brief moment that the button disappears and reappears (assuming it worked), are you allowing the user to submit again? I am aware that you are trying to address the issue of multiple submissions, but I wonder how effective that split second hide and reappear of the button would prevent multiple submissions. I know @Darren_Murphy has speculated that sometimes actions may run all at once and possibly run out of order. I wonder if that’s the case here, where it may be setting the value to 0, but it does it BEFORE it sets the value to 1, so you end up with a final value of 1.
I would probably rethink the logic a little bit. What I would maybe consider doing…instead of setting the column value to 1…set it to the current date/time. Then in the sheet add a math column to add 5 seconds to that date/time. Then set a visibility condition on the button to only show if the math column is before Now. Then you shouldn’t need a second Set Column action. If it all works, hopefully the user will click on the button, it will set the current date/time and the math column will calculate the date/time to be greater that Now for 5 seconds, which will hide the button. After 5 seconds, the button should come back.
Hmm, possibly, but I wonder if you’d still run into that 5 or 10 second delay for dates to update in the glide data. Might be fine to temporarily hide a button, but might be too slow for your return to top situation.