Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Automations
Solved
Jump to Solution
314 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

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

Image

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

1 Solution

Accepted Solutions

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.

Screen Shot 2022-06-02 at 6.31.42 AM

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

Screen Shot 2022-06-02 at 6.30.49 AM

See Solution in Thread

4 Replies 4

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

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
  1. The webhook from airtable receives the data
  2. I find the user in the user contributor table
  3. I find the liked page in the softr tips table
  4. 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.

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.

Screen Shot 2022-06-02 at 6.31.42 AM

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

Screen Shot 2022-06-02 at 6.30.49 AM

It worked! Thanks a lot!