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

IF Checkbox, add +1

Topic Labels: Formulas
Solved
Jump to Solution
697 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there

I’d like to make a formula that whenever I mark the checkbox (I’ll unmark it later again), it will add +1. It’s a counter for how many times I already did a recurring task.

Any ideas on how to do that?

Many thanks in advance

Cheers

Marc

1 Solution

Accepted Solutions

I don’t think you’ll be able to do that natively in airtable within a specific record. You could write up a script in zapier or integromat to make something happen.

If you wanted to keep it within airtable I would recommend creating 2 tables, “Tasks” and “Events”. Tasks would be a list of each individual type of reoccuring task. Events would include a new record for each time a task is run. You could toggle this from a form or something to get you close to a single button press to trigger. Records in the event table would link to a task. In the Tasks table, 1 field would be a rollup to count the number of events for that task.

See Solution in Thread

2 Replies 2

I don’t think you’ll be able to do that natively in airtable within a specific record. You could write up a script in zapier or integromat to make something happen.

If you wanted to keep it within airtable I would recommend creating 2 tables, “Tasks” and “Events”. Tasks would be a list of each individual type of reoccuring task. Events would include a new record for each time a task is run. You could toggle this from a form or something to get you close to a single button press to trigger. Records in the event table would link to a task. In the Tasks table, 1 field would be a rollup to count the number of events for that task.

Oh I see. Thank you very much in any case. I think I’ll refrain from using Zapier and such for now and just copy the tasks. Make groups like “current” and “upcoming” :slightly_smiling_face: