Hey all, this is my first post, so I hope I do this right!
I have created an automation that, when a field box is ticked, a series of Find Records run. Each Find Record action gathers a list of records (people) that meet certain conditions. This is followed by an Update Record, that adds the linked records to a single field.
The Update Record step looks like this: Find Record 1 record ID, Find Record 2 record ID, Find Record 3 record ID.
This works perfectly unless one of the Find Records comes back empty, in which case the whole automation fails. Two the Find Records often come back empty, so this is a problem. I’ve played around with conditional actions, which is messy but it kind of works until a conditional action has an empty Find Record, where the automation stops and doesn’t move down to the next condition(s).
Can anyone think of a workaround? Thanks in advance!
Hi Lindsay, if you’re on a Pro account you can add a Run a script step that would clean up the find record results for you so that you could use it in the Update Record step
A workaround that you could try would be to get your current automation to put the results of those find record actions into individual fields and then using a formula field to concatenate them together, and then have another automation that triggers when the formula field gets updated to paste the concatenated values into a linked field perhaps?