Need help with an error message “Run Condition Not Met” table linked to SFDC. The column is Create a New Record in SFDC:
I have table set up with a Lookup Record column to see if the record exists. The next column is Update Record (if it exists based on the Lookup Record column). The last column is Create a New Record if
Why this condition wasn’t met:
The condition is false because “Lookup Record” is an object (not empty or false), so it counts as true, but “Lookup Record (2)” is also an object (not false or empty), so the part that requires it to be either empty or exactly false is not met. To make the condition true, “Lookup Record (2)” needs to be either empty (null/undefined) or explicitly set to false, not just an object with no records.
Settings: see screenshot attached
Only Run If Formula: {{Lookup Record}} && !!{{Final Email}} && (!{{Lookup Record (2)}} || {{Lookup Record (2)}} === false)