Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Conditional automation condition failing

Topic Labels: Automations Formulas
230 3
cancel
Showing results for 
Search instead for 
Did you mean: 
laurenCTCL
6 - Interface Innovator
6 - Interface Innovator

Hi! I'm trying to set up a conditional automation and the "Otherwise" condition is giving me an error.

Trigger: A record enters a view. The view relies on the field {1 week} not being empty. The two possible values are "1 week late" and "2 weeks late"

 Screenshot 2025-02-04 at 8.40.05 AM.png

First condition:
If {1 week} contains 1

Screenshot 2025-02-04 at 8.41.35 AM.png

Condition 2 should be either:

  • Otherwise, or
  • 1 week contains 2 (or equals "2 weeks late")

I get success after the first condition but the second condition fails
Screenshot 2025-02-04 at 8.43.26 AM.png

It feels like i'm missing something obvious! Thanks!

3 Replies 3
Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

In the screenshot you posted, the input is "1 week late" when the Otherwise condition fails.

This makes sense as "1 week late" satisfies condition 1, so it should never make it to the Otherwise case with the current test record.

Did you change something about the test record so that it would display as "2 weeks late"?

If so, you need to reload the test record in your Automations window so that the input is "2 weeks late." It should run through the Otherwise condition at that point.

In other words: When you load a test record to test an automation, Airtable loads the record data as is at that moment. It does not watch the record for live updates that change it, and will assume the record is unchanged until it is reloaded.

Aha, okay! So, to be clear: If the test record only meets the first IF test, that test will pass but the second one will fail, so I need to test with a record that meets the otherwise?

The view I'm using as the trigger will only contain records that meet one of the two conditions (contains either "1 week late" or "2 weeks late.")

How do I go about testing if both work? If I go back to the start and choose a record that doesn't meet the first condition (contains "1") but does meet the second (otherwise or contains "2"), my test fails at the first step (which makes sense, since it doesn't contain "1").

Correct.

To test the second step, you need to load a different test record that you expect to fall into the Otherwise condition.