Compare two fields in Automations

Topic Labels: Automations
1288 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

In the same table I have a column that has a running tally of copies sold (I sell books) and in another column I have the Sold Out Amount. I’d like to create an automation that triggers when Copies Sold equals the same amount as the integer in Sold Out Amount which seems like an easy thing to have happen but the automation won’t let me put in a field name to compare

2 Replies 2

Welcome to the Airtable community!

Create a formula field that compare the two values, and then trigger your automation off the of the formula field.

You cannot use dynamic condition values in the trigger of an automation, only in the “find” records action.

oh good idea! thanks!