I have created a table in Airtable in which I have a running sum at the bottom of a particular field. I would like to create a zap when the sum for that field hits $50,000 and then one for when it hits $75,000. I can't figure out if it's possible to have a particular sum as a trigger since the sum is not part of a record. Thanks!
Best answer by AndrewJDavison
Hi
I'm wondering if you could create another column with a formula that tallies the total, and then create a view that filters until this total goes over $50k? Then you could create a "New Record In View"-triggered zap.
+11Hi
I'm wondering if you could create another column with a formula that tallies the total, and then create a view that filters until this total goes over $50k? Then you could create a "New Record In View"-triggered zap.
+3Hi
Thank you. I can't seem to find a reasonable way to tally a running total but I'll play around with a rollup field. I'm still learning Airtable so I'll try and figure it out. Thanks so much
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
