update - property field code with 'property field' (property field code text needed for next action)
Find record - (in another table) where episode number = episode number and property field code = property field code
if matching record in the other table is found:
update link field with matching record
if no matching record found:
send a slack message
if no conditions are met - no actions run
So, this automation is running great, when the initial record's episode number is updated it's linking the record from the other table nicely.
However, when the episode number was deleted from a record, the automation run failed at the Find Record action. Why is this run 'failing' rather than just running as the second conditional action - no record found (ideally like: episode number is empty = then no record found) is my question? Thanks!
Hi, yes this is the case. But when someone is changing the episode number, they delete the old one and the automation fails and they put in the new number then it runs properly. Is there a way to stop it failing mid episode number change?