Help

Automation: Working With Linked Records Arrays in Conditions

Topic Labels: Automations
1628 1
cancel
Showing results for 
Search instead for 
Did you mean: 
pixel
4 - Data Explorer
4 - Data Explorer

Hello!

I’m trying to achieve the same effect as this post but running into problems actually inserting the string value of a linked record’s recordID as a dynamic automation value.

I’ve followed the directions from this post. I converted the array of linked records to a string for use in the automation. However, the automation interface does not present me with an “Insert” button for this string value, only a “continue” button which also leads me nowhere.

I’ve attempted this using both the formula and rollup fields. For each of these methods, I’ve appended a &"" to force the value to a string. I’ve also attempted to use the “Insert Records As [List/Grid]” feature with my string but this does not appear to function after running a Action Test.

Here are some nitty gritty details about the general project I’m building.
Screen Shot 2021-03-26 at 9.23.29 AM Screen Shot 2021-03-26 at 9.37.40 AM Screen Shot 2021-03-26 at 9.37.50 AM Screen Shot 2021-03-26 at 9.37.59 AM Screen Shot 2021-03-26 at 9.38.03 AM
I have an Items table and an Updates table. Each Update record references just one Item record and also references the last-entered Update record, creating a linked list I need for calculating some metrics.

I am looking to create an automation that effectively creates this linked list of updates automatically in order of update submission. I want the automation to look like this:
Step1 - Trigger: new record created

  • in updates table
    Step2 - Action 1: Find records
  • in updates table where:
  • [item] contains [step1:item]
  • [latest_update] is unchecked
    Step3 - Action 2: Update record
  • in updates table where Record ID is [step1:Record ID]
  • set field last_update to [step2:Record ID]

Any help is greatly appreciated.
Thank you!

1 Reply 1

Unfortunately the “Find records” action is only designed to work with the two “Send email” actions (Airtable’s and Gmail’s). According to Airtable support (via another user who asked), it’s technically not supported when feeding its results into anything else. To request support for updating records from the results of “Find records”, I recommend reaching out to Airtable support directly.