Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to get array of linked record by IDs

Topic Labels: Scripting extentions
215 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone,

I have a table Company and a table Benefits.
Company has many Benefits.

When I get the list of linked records (Benefits) from a Company record (trigger by update), it gives me an array of the linked records but with its name.
I would like to get the array but with ids instead.

I use the input variables interface to get the fields Benefits (relation) in my Company record.
There is a way to get this array of benefits by id within the interface or do I need to code in the script (beginner in scripting) ?

Thank you so much for your help!

1 Reply 1

Hi,

you have 2 options:

  • add formula field ‘RECORD_ID()’ in Benefits and use list of it’s values
  • more smart and tricky - without extra field. If Company linked to several benefits that means each of them linked to company. Do Find Records, in Benefits, where ‘Link to Company’ contains company name.
    Then in next step you can use ids of all found records as list.

image