Load Record without knowing ID

[sackley]

Hi everyone!!

if you ever have known all of your filters on a table but not known the ID, this is the article for you.

1. Make a table query with all of your required filters. Be sure there is a Limit =1.
2. Make an aggregation that is Mode of the ID field
3. 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