Hi, I hope someone can help.
I have an automation where
When a record is updated - Episode number field
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!