Hi! Have not figured out this yet. It seems like a task, but I am not sure what the most elegant solution is.
How can you add a +1 to a number if something happens in a record?
Automations don’t understand formulas, so you would need to create a new formula field where the NEW NUMBER already exists. (In other words, you would create a formula field which is equal to your original number field +1.)
Then, set an Airtable Automation to set your original number field to the contents of the formula field, which will kick in whenever your trigger happens.
@ScottWorld - Must say - your posts are fantastically helpful! They have helped me many a time!!
I have just found this. Wanted to do the same, and the best I could think of was to add another field to my table (+ 1 of the original number) and insert that. Was hoping it could be done within the formula as it would be much cleaner but doesn’t seem to be possible. Oh well!
That is so nice of you to say! :blush: :sparkles:
Thanks so much, and I’m so glad that my posts have been helpful for you on multiple occasions! :grinning_face_with_big_eyes: :raised_hands: