Save the date! Join us on October 16 for our Product Ops launch event. Register here.
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.
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:
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).
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:
contributor
tablesoftr tips
tablecontributor
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.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:
Jun 02, 2022 10:04 AM
It worked! Thanks a lot!