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)?
- Get input values. (automation)
- Sort those and put sorted values into another field. (script)
- Look-up matching values for this set (just how my airtables are set-up)
- 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?