if you ever have known all of your filters on a table but not known the ID, this is the article for you.
- Make a table query with all of your required filters. Be sure there is a Limit =1.
- Make an aggregation that is Mode of the ID field
- Load a table record by the`Table Aggregation
Watch this video to see how the methodology can be applied to managing a sequence of tasks
Here is my Table Query:
Here is my Aggregation:
Trigger behind ‘Move Up’
I think you can guess what the ‘Move Down’ trigger looks like