Can I use a formula to clear a checkbox?

Topic Labels: Formulas
Jump to Solution
1786 18
Showing results for 
Search instead for 
Did you mean: 

Hi all, this is my first post on the Airtable community. :slightly_smiling_face:

I have a base that I use to track my FB groups activity. So I have a column with a checkbox to mark when I’ve completed something in that group.

What I’d like to do is have those checkmarks automatically clear off at the beginning of each new week.

Is that possible with a formula? If so, can someone point me in the right direction of where to get started?

Thanks so much for any help!


1 Solution

Accepted Solutions

You have to put the Record ID into the ID section, not your checkbox field. See my 3rd photo above.

See Solution in Thread

18 Replies 18

Welcome to the community, @Valerie_Tate!

There are no automations built into Airtable, so you would have to turn to something external to make this an automatic process that happens every week.

You could write a custom JavaScript script to do this with the Scripting Block, but you would need to remember to manually run this script once a week, since the scripting block can’t be scheduled.

If you’d like this fully automated so that it happens all on its own every week, you could create a scenario in Integromat that runs once a week. When it runs, it can search for all your records that have the checkbox checked, and then clear the checkbox from all of them.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

Welcome, @Valerie_Tate.

I don’t think you’ll be able to do that with a Formula. Formulas are only capable of outputting some value into the field(column) they are programmed for – they are not capable of changing the value of other fields(columns).

With your use case (tracking a FB group’s activity), I have to imagine you are probably using a Free Airtable workspace. If that’s true, then the easiest solutions to your dilemma are only available to you until September (as far as I know) – that’s the Scripting Block.

Blocks, in general, are the way to go for the kind of functionality you are wanting. The “Bulk Update” block, for example, could give you a single button to click to clear all the checkboxes on a Monday. It still requires your input, but it would take a single click. The “Bulk Update” block will not be available to you at all, though, if you are in a Free workspace.

So the next best option is the Scripting block, which is available to all workspace, including Free ones, but only until September – at which point, I presume, they will make the Scripting block only available to Pro accounts, like the rest of the Blocks. A script that clears all the checkboxes with a single button click would be pretty easy to write. It would require input from you, again, but still just a single button click.

Lastly, you could simple click the field(column) header for your checkbox field (this will select that field for all records in the table/view) and then hit backspace – this will prompt a pop-up dialog like so:
CleanShot 2020-06-02 at 17.09.27
Clicking continue will clear the checks in any checkboxes for you – so, this action takes 2 clicks and a keyboard tap in all.

As you’ll have gathered by this point, Airtable doesn’t have anything built in that will automate this process for you on a schedule. And I’m hesitant to suggest any external tools for doing this sort of thing – I’ll leave that to other people, should they choose to chime in :slightly_smiling_face:

Ah yes, I forgot about the Batch Update block! Another great option for you, @Valerie_Tate, if you don’t mind manually running it yourself every week.

I don’t have anything to add to the options listed above, aside from my own opinion. For something purely automatic, my preference would be what @ScottWorld mentioned re: Integromat. I have quite a few Integromat scenarios running on specific schedules, including one that runs daily and clears checkboxes in certain records, which is pretty close to your original request, @Valerie_Tate .