1. Data Records table

   1. Each record contains a Number value (amongst various other fields that do not concern us at this point)
      

2. Group Records table

   1. Records that group together records from the Data Records table
      1. For example, assume Data Records has 1000 records.
      2. Records 1-50 in from Data Records would be linked to Record 1 in Group Records, Records 51-100 to Record 2, etc
         

3. Queries table

   1. For users to submit new queries with the following data:
      1. Group Records records to indicate which subset of records from the Data Records table to find
      2. A Multiplier value
      3. A Minimum value
      4. A Maximum value
         

The client wanted to be able to create new records in Queries, and automatically find records from Data Records that matched the conditions they set.

The conditions were the following:

1. The Data Record needed to be linked to one of the linked Grouped Records
2. For each Data Record, we would need to generate a Number to Check value by multiplying the record's Number by the Multiplier value the client had set in the query
3. The Number to Check value had to be above the Minimum and below the Maximum value that was set

After finding all of these records, the client wanted the following data to be updated into the record in Queries :

1. The lowest Number to Check value that was higher than the Minimum
2. The highest Number to Check value that was lower than the Maximum
3. A customized line of text that displayed data from each of the found records

We created an automation that would run a script once the client had set the:

1. Minimum value
2. Maximum value
3. Multiplier value
4. Linked Group Records

The script would:

1. Find all the records from Data Records linked to the Group Records the client had set
2. Find the lowest and highest values as mentioned above by going through each record and:
   1. Multiplying the record's Number value by the Multiplier to generate Number to Check
   2. Checking whether this multipled value was above the Minimum and below the Maximum
3. Update the original record that triggered the automation with the following data:
   1. The lowest Number to Check value that was higher than the Minimum
   2. The highest Number to Check value that was lower than the Maximum
   3. The custom text that pulled data from each of the found records