Hi there -

I’ve built an automation that the first automation will update records to a table.

That automatically pulls matching values from another table.

I want to access the matching values for the second automation without needing to write a script to do what’s being done automatically. (or is this the only way)?

Process:

1. Get input values. (automation)


2. Sort those and put sorted values into another field. (script)


3. Look-up matching values for this set (just how my airtables are set-up)


4. Run second script and provide an output based on the above three steps.

I have tried doing a selectRecordsAsync after I’ve done the updaterecordsAsync but it still isn’t working – my values are undefined despite values being in the field.

What’s the most efficient way to do this?

Help!