[AUTOMATION] Link to records from two steps in one field

[Joachim_Brindea]

Hello,

Do you know how to link to records from two steps in one field in an automation?

Right now it’s concatenating the records into one new record instead of linking to the two records separately.

I’ve tried adding “,” and “;” or even just a space to no avail.

Thank you for your help,

Joachim

[AlliAlosa]

You’re close! You definitely need to separate with commas (no quotes necessary). I would also change the value you’re pulling from the find records steps to be the record IDs instead of the names. Using the names can fail for a number of reasons (for example if you have a leading or trailing space in one of the names, this could cause an error).

[Joachim_Brindea]

Unfortunately, if I add a comma, I get an error.
I don’t know what I’m missing…

To understand the video:

1. I have a like button sending:

• URL of the liked page
• Email of the logged in user

2. The webhook from airtable receives the data
3. I find the user in the user contributor table
4. I find the liked page in the softr tips table
5. In the contributor table, I try to update the liked field with the list of softr tips records the user already liked + the softr tip from step 4 of this process.

[AlliAlosa · Accepted solution]

Ah! Super helpful video - thank you!

This is quite interesting. I believe the issue is that the contributor you’re trying to update doesn’t yet have anything in the field, {Liked}.

I just did a little test on my end and confirmed that if the first list of record IDs is empty, the automation fails.

The good news is, if you flip the order around, it works. :thumbs_up:

[Joachim_Brindea]

It worked! Thanks a lot!