Hi,
I would like to create an automation that checks if one field (number) becomes equal to another field’s value then it riggers something. Is that possible? I only see in the condition to input a value but not select another field
thanks a lot
Solved
Run Automation when two fields are equal
Best answer by Justin_Barrett
@John_McGarvey is on the right track. That formula could be simplified a bit further, though. The result of an expression like {Field 1} = {Field 2} is a boolean value (True or False) which the IF() function uses to determine which other argument to evaluate and return. However, Airtable will display boolean values as a number (1 or 0). You can use that to your advantage here and drop the surrounding IF() function entirely, using this as your complete formula (with correct field names, of course):
{Field 1} = {Field 2}
That alone is sufficient to produce a 1/0 output and act as trigger for an automation as described.
+3Here is how I would accomplish this - there could be better ways, but I’m still learning too :-).
Create a formula field with an If/Then statement: IF(Field1 = Field2, 1, 0).
Then create a filtered view for only the records polulated with 1 from the formula.
Your automation can then use the When Record Enters View trigger.
+21@John_McGarvey is on the right track. That formula could be simplified a bit further, though. The result of an expression like {Field 1} = {Field 2} is a boolean value (True or False) which the IF() function uses to determine which other argument to evaluate and return. However, Airtable will display boolean values as a number (1 or 0). You can use that to your advantage here and drop the surrounding IF() function entirely, using this as your complete formula (with correct field names, of course):
{Field 1} = {Field 2}
That alone is sufficient to produce a 1/0 output and act as trigger for an automation as described.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.