How to run an action from another action.
In the summer there was such an option, but now I can’t find it.
Maybe it can be implemented somehow else?
Actions cannot call other actions. This has never been a thing.
Or do you mean chained actions?
1 Like
My memory must be failing me.
But now I have the task of running the action several times until I am satisfied with the result of its action.
For example, delete 1 line until the number of lines is equal to the required number.
Or generate a random value, but if it coincides with the previous result, then repeat the action again, or several times. Although an infinite loop is possible here.
Are they real examples, or ones that you just made up?
If they are real, I could think of a way that each of them could be dealt with by a single action.
These are real challenges. With the generator I’ll probably figure out how to get out of it, but with the deletion/addition of strings to make them a given number, I can’t think of anything yet.
You appear to have moved the goal posts 
Earlier you said:
But now that has morphed into:
so before I attempt to offer a solution, would you mind clarifying please? (a screenshot might help)
Well, it’s our job to move the goalposts, especially if the ball doesn’t go where it’s supposed to go.
The picture shows how the user after changing the accounting slot interval can bring the auxiliary table to the optimal size.
In one click he adds a missing row or removes an extra row.
It can be 10 clicks, or it can be 100.
Summary
Okay, that makes it clearer, thanks.
So here here is a suggestion - instead of adding/removing rows, why not keep the number of rows static, and use an if-then-else column to validate them?
Taking your example:
- You know that valid time slots must match the Work Time, which is 9:00AM to 5:00PM
- Add your Start and End times to your Auxiliary table as Single Value columns.
- Add an if-then-else column:
– If Time is before Start Time, then null (leave empty)
– If Time is after End Time, then null
– Else Time
This will give you a column with a list of valid time slots.
This is exactly how it worked as long as the number of rows was small.
But when the interval becomes 5 minutes instead of 1 hour, the number of lines per day will be 288.
Considering that the line limit per application is 500, we have to think about optimization.
After optimization, 96 lines will suffice
@Darren_Murphy Don’t agonize in vain.
If can’t do a loop, I will reduce the number of clicks by creating multiple actions for 1, 2, 4, 8, 16, 32, 64 string actions.
To change the number of rows to 127 would require a maximum of 7 clicks with 7 actions.
With the addition of a few lines of action works.
But deleting multiple rows doesn’t work, it always deletes 1. How to switch to another line after deleting the current one? “Shuffle order” and “Set column value” between deletions do not solve the problem.
The deletion problem has been solved.
I made Relation with extra lines and delete referring to it.