Oct 17, 2024 01:25 PM
I am new to AirTable automations, so kindly excuse my basic nature of questions and problems.
Please refer to the attached screenshot to see what the description below refers to.
When testing an automation, I am expecting the “Update record” action to NOT be executed due to the "IF Condition" preceding the action.
For this, before I click on “Test automation” button, I am setting the API_Response = ‘record rollback complete’ and Status = ‘record rollback’.
However, the test Output on the right hand side panel shows the condition evaluated to TRUE, when clearly the input section shows the API_Response and Status values were such that it should have evaluated to FALSE.
I need help to understand why this is happening and how can I set the If Condition so that the desired result is achieved.
Thanks in advance.
Solved! Go to Solution.
Oct 17, 2024 06:34 PM
Hm, looks like you've set up an "OR", so if any of those conditions pass then it'll run I think. To test this try removing all the conditions except the Status check to see whether it works as expected
Oct 17, 2024 06:34 PM
Hm, looks like you've set up an "OR", so if any of those conditions pass then it'll run I think. To test this try removing all the conditions except the Status check to see whether it works as expected
Oct 18, 2024 05:10 AM
Thanks Adam
You were spot on. I had to change the operator from "or" to "and" 👍.