- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2022 12:07 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2022 03:33 AM
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:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2022 02:03 AM
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).
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2022 02:52 AM
Unfortunately, if I add a comma, I get an error.
I don’t know what I’m missing…
To understand the video:
- I have a like button sending:
- URL of the liked page
- Email of the logged in user
- The webhook from airtable receives the data
- I find the user in the user
contributor
table - I find the liked page in the
softr tips
table - In the
contributor
table, I try to update theliked
field with the list ofsoftr tips
records the user already liked + the softr tip from step 4 of this process.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2022 03:33 AM
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:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2022 10:04 AM
It worked! Thanks a lot!