Compare two fields in Automations

[Angela_Trigg]

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

[kuovonne]

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.

[Angela_Trigg]

oh good idea! thanks!