Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Compare two fields in Automations

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

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!