Load Record without knowing ID

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:
Screen Shot 2021-09-29 at 2.00.30 PM

Trigger behind ‘Move Up’

I think you can guess what the ‘Move Down’ trigger looks like :smiley:

3 Likes