Adam C - Workflow and Web Application Consulting


Searching with Dynamically Modified Values

Before searching, keyed in values needed to be multiplied, and the search had to be done on a filtered set of records derived from said multipled values

View the solution base here

Base Details

  1. Data Records table

    1. Each record contains a Number value (amongst various other fields that do not concern us at this point)
      Data Records table.png
  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
        Group Records table.png
  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
        Query table.png

Scope

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

The Solution

Result.gif

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

"

Adam’s service is amazing! Not only is he an expert in programming and script writing, but he is also a true problem solver.

He helped me to solve a complex issue in Airtable that had been stumping me for days. After taking the time to explain my issue in more detail, Adam quickly identified the root cause of the problem and provided a clear and concise solution. I was thrilled with the result and grateful for his expertise.

His communication is excellent, and he is always willing to take the time to provide detailed explanations.

I would highly recommend Adam to anyone looking for a talented programmer or script writer. He is a true asset to any team.

Thanks, Adam!

"

-Patricia


adam@thetimesaving.company