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) ?
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.