Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Conditional logic fail

Topic Labels: Automations
372 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there,

I am building an automation that should trigger when a record is added to a view

1

That part completes flawlessly

2

The last field is C2.

Conditional automation should trigger when C2 contains Testing

3

And even though the record field C2 contains Testing, the automation errors out

4

With a super unhelpful lack of an explanation for why this isn’t working.

Help is appreciated!

Best,
David

2 Replies 2

Hi,
what’s inside C2 formula? is it a link to some lookup field?
i know that some time ago Airtable condition logic might fail when comparing with something containing array (lookup or multiselect field), but for most cases it was fixed.

i would try 3 things:

  • ensure you test step 1 before this condition step. If you add/remove/change steps, always test all one by one starting from first.
  • if C2 formula is like a simple link to other field, e.g. {SomeField}, change it to CONCATENATE({SomeField}), it will turn array into string. (or use ‘add empty string’ method: ''&{SomeField} )
  • insert ‘oneliner’ script step, using C2 as input and some var (e.g. C2result) as output. Set condition as " C2result contains ‘Testing’ "
    image

That worked like a charm!