Help

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

Solved
Jump to Solution
1015 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Joachim_Brindea
6 - Interface Innovator
6 - Interface Innovator

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
AlliAlosa
10 - Mercury
10 - Mercury

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

Joachim_Brindea
6 - Interface Innovator
6 - Interface Innovator

It worked! Thanks a lot!