Re: Condition: If the value of field 1 is the value of field 2

246 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I've tried to create such an automation:

When one updates the value of field 1,

if this value matches that of field 2,

input a static value into field 3!

How do you let people do this?

Because AirTable doesn't let us set this condition, I've done this:

a. added a hidden field with the formula: 

IF({field 1}={field 2}, "1")
One can input any value after the condition / first comma.
One can add an "else" output after a second comma.
b. set the condition: If this field 4 has the value 1
I've added step a because some service providers make service users do costly work.
Service providers are supposed to do the main work. This is a part of the main work.
1 Reply 1

You could try using a formula field to check if they match, and then trigger the automation off of that?

Screenshot 2024-03-06 at 8.54.59 PM.png