Skip to main content
Solved

Help with "IF CONDITION" in an automation for "when record updated"

  • October 17, 2024
  • 2 replies
  • 42 views

nishant_tank
Forum|alt.badge.img+7

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.

Best answer by TheTimeSavingCo

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

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6457 replies
  • Answer
  • October 18, 2024

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


nishant_tank
Forum|alt.badge.img+7
  • Author
  • New Participant
  • 3 replies
  • October 18, 2024

Thanks Adam

You were spot on. I had to change the operator from "or" to "and" 👍.