Can I use a formula to clear a checkbox?

[Valerie_Tate]

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!

Valerie

[ScottWorld]

Valerie_Tate:

Since I’m just setting all checkboxes back to empty, is there a way to just tell it to change ALL records in the “Done” field to false regardless of current status?

Yes, just do a search on something that will always yield true, like simply a field name (or a formula field name) that will always have something in it.

This is what your scenario overview could look like (unless someone has an even better idea than this):

And for your 3 modules, they could look like this:

[ScottWorld]

Actually, @Valerie_Tate, I stand corrected. I believe that if you leave that “Formula” field blank, that it will return all the records. I just tested this, and it returned all of my records.

[Justin_Barrett]

You also don’t need the iterator module. Integromat automatically iterates through all records found in the “Search Records” module. The two Airtable modules alone will do the trick.

[Valerie_Tate]

Okay, based on y’all’s comments, here’s what I’ve got, but it’s giving me an error.

Here’s step 1:

Here’s step 2:

Here’s the error:

What am I doing wrong?

(Again, thanks for taking so much time to help me out! Y’all rock!)

[ScottWorld]

Justin_Barrett:

You also don’t need the iterator module. Integromat automatically iterates through all records found in the “Search Records” module. The two Airtable modules alone will do the trick.

What?!? For real!? I’ve always been using the iterator module!! :grimacing: :grimacing:

I’m going to test now! Then what would we need the iterator module for?

[ScottWorld · Accepted solution]

Valerie_Tate:

What am I doing wrong?

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

[Justin_Barrett]

ScottWorld:

What?!? For real!?

For real. The first module in any scenario typically returns one or more bundles. For example, with a search module, there will be one bundle for each Airtable record found. Integromat then iterates through the bundles, feeding them one by one through the rest of the modules in the scenario. If any later modules create their own bundles, those will cause another level of iteration from that module onward with those results.

ScottWorld:

Then what would we need the iterator module for?

The Iterator module is meant to iterate through arrays. The example that the Integromat docs give is that you’re processing a single email message found by the first module, but that message has several attachments, which will be stored in an array. If you want to process each of those attachments individually, you need to iterate through the attachment array, passing each item to later modules (i.e. upload to Dropbox). To do that, drop in the Iterator module, having it grab the array from the first module, and then the rest of the scenario will run once per array item.

[ScottWorld]

Wow, thanks so much for this, @Justin_Barrett! All this time, I was wasting my time using iterators! This is a game-changer for me. Thank you!! :slightly_smiling_face:

[Valerie_Tate]

IT WORKS!! Y’all are the bomb. Thank you so much for all your help!!