How to create e loop action for row columns after certain criteria met?
This sort of thing is only possible if it’s based on user interaction.
For example, you might have a counter that increments a column value by 1 every time a button is tapped, and then resets it to zero once it reaches a certain value. But again, that relies on the user actually tapping the button.
Can you describe your actual use case?
I want this progress bar to change repeatedly after one click.
also change these column values in a loop
Based on what criteria?
I mean, do you want the progress bar to increase as time passes?
That is possible, yes.
For example, tapping the Start button could set a column to the current time, and then you could have a math column that calculates the number of minutes/seconds that have elapsed since the button was tapped. And then the result of that math column could drive the progress bar.
But I’m not sure where the loop comes in?
I mean once you click the button the progress bar or timer will start and that timer will continue like a loop until I stop. Think this 1-minute timer will end and start again without clicking any button
Are you looking for something like this?
Glide only updates the time once every 10 seconds, so using this method you only see a change at that interval.
Yes like this but this 10 sec will run repeatedly the button will not be triggered
What I showed there will keep running in one minute cycles until you tap the stop button.
I don’t understand what you mean by that, sorry.
Yes, I am sorry for my mistake. Can you please tell me the process?
Sure. There are just two columns used there:
- The first is a User Specific date/time column
– When you tap the 'Start` button, the action writes the current date/time into this column
– When you tap the ‘Stop’ button, the action clears the value in this column
- The Start/Stop buttons have visibility conditions configured: Start is visible only when the User Specific column is empty, Stop is visible when it is not
- The second column is a math column, using the following formula:
- Where Now is the current date/time, and Start is the value of the User Specific column
- The Progress Bar is configured using the data from the math column, with a minimum of 0, and a maximum of 60
When you tap start, it always seems to start with a value somewhere around 55-60. I haven’t figured out why that happens. In theory, it should start at zero.
Can I do this for 25 min as well?
Yes, just change the math formula to use 1500 as the modulus operator instead of 60. And then set the maximum on the progress bar to 1500.