Had an idea, no time to test it right now or think on it much, but I wanted to make sure to write it down somewhere so I wouldnโt forget, and maybe others would know if itโll work or not.
Thereโs no real way to execute a โloopโ of actions in AppSheet. But can we do some sort of recursive change trick, where we have a workflow that occurs upon an edit, then makes an edit itself, which in turn triggers itself again?
@Marc_Dillon
I have tried it but the datachange WF runs only once. May be itโs possible with a combination of AppSheet API See it in action here:
Click on the 1st menu item, expand the row for Detail View and change the quick edit number. The WF will increment it by 5 but only once though I have set the condition as [_THISROW_AFTER].[Number] <= 50
Iโve had success with recursive actions. I tinkered with it some time ago, so it may no longer work. At the time, I suspected my success was coincidental and that recursion was not supported. It took a lot of effort to make it work at all.
When using workflow
Thanks guys
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |