# Automations: clearing a Boolean field
**URL:** https://community.baserow.io/t/automations-clearing-a-boolean-field/12507
**Category:** Baserow Help
**Created:** [June 10, 2026, 10:16am UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507 "2026-06-10T10:16:10Z")
**Posts on this page:** 14
**Page:** 2
### Author:  [@Thimpturaw](https://community.baserow.io/u/Thimpturaw)
#### Post date: [June 23, 2026, 2:02pm UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/21 "2026-06-23T14:02:39Z")
> [@Rickus3126](#):
>
> ### Are you using our SaaS platform ([Baserow.io](http://Baserow.io)) or self-hosting Baserow?
>
> SaaS
>
> ### What do you need help with?
>
> So I have a Boolean field called “Stock Checked” this field gets ticked once the specific info in the row has been confirmed. Easy. But now every Monday, I need to clear the “Stock Checked” field for the admin team to do it all over again during the new week. There is about 650 rows to clear every Monday morning. I was trying to do an automation but it seems like its not working. Not too sure what I am doing wrong.
>
> the automation route i had was as follow:
> start with periodic trigger
> there after an Iterator
> update row.
>
> with everything set up like it should. i come to find that it has not cleared my boolean field.
It seems like your idea is sound, but these things often break down not in the logic, but in the details.
I’d first check two things:
Does the list of rows even reach the Iterator?
Sometimes it doesn’t return all the records or even an empty array due to filtering/pagination.
Is the correct ID being passed to the Update Row?
This is the most common problem: everything looks fine visually, but the wrong entity is updated, or nothing happens at all.
And another thing:
Sometimes these automations “silently” crash on some rows due to limits or timeouts, especially when there are 600+ of them.
---
### Author:  [@Rickus3126](https://community.baserow.io/u/Rickus3126)
#### Post date: [July 27, 2026, 10:32am UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/22 "2026-07-27T10:32:56Z")
Can i please get a reply from ANYONE??? this is just nog working. no matter what i do.
---
### Author:  [@jrmi](https://community.baserow.io/u/jrmi)
#### Post date: [July 27, 2026, 3:25pm UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/23 "2026-07-27T15:25:51Z")
Hey @Rickus3126
Could you be more precise about what didn’t work in the two previous answers to your issue.
@picklepete mentionned that the application you exported is working, do you have a new blocking point?
---
### Author:  [@Rickus3126](https://community.baserow.io/u/Rickus3126)
#### Post date: [August 17, 2026, 7:33am UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/24 "2026-08-17T07:33:52Z")
it constantly says Ran successfully. but it is not doing anything. I had to clear 650 rows again this morning.
Baserow is really frustrating me at this moment now. if its not this issue. its my other issues. Im done!!!
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [August 17, 2026, 2:28pm UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/25 "2026-08-17T14:28:05Z")
Hey @Rickus3126 did you try out what @picklepete suggested here: [Automations: clearing a Boolean field - #20 by picklepete](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/20)
---
### Author:  [@davide](https://community.baserow.io/u/davide)
#### Post date: [August 18, 2026, 9:36am UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/26 "2026-08-18T09:36:02Z")
Hey @Rickus3126,
in your “List rows in Main Contracts File”, which is the value of “Default result count”?
If it’s the default, which is 20, your loop is only analyzing the first 20 rows.
---
### Author:  [@Rickus3126](https://community.baserow.io/u/Rickus3126)
#### Post date: [August 18, 2026, 12:22pm UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/27 "2026-08-18T12:22:11Z")
Yes it is on 20. so how do i do 650 rows? i see the max is only 200
---
### Author:  [@davide](https://community.baserow.io/u/davide)
#### Post date: [August 18, 2026, 3:25pm UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/28 "2026-08-18T15:25:17Z")
You need to filter the rows you want to update in the `Refinements` by adding a filter to return only the rows you want to change: “Stock Checked” is selected
The you add a Go to Node after the iterator node to go back to listing rows if the length of the returned rows is greater than zero.
To give you an example, I built this around our `Project tracker` template:
You have to adapt it to your tables and fields, but you should get the idea.
---
### Author:  [@Rickus3126](https://community.baserow.io/u/Rickus3126)
#### Post date: [August 18, 2026, 6:00pm UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/29 "2026-08-18T18:00:38Z")
thank you. i will do exactly what you explained and share the results here.
when executing dummy tests. everything works perfectly. the real test will be on Monday morning at 5am (3am your time) when it needs to run automatically.
---
### Author:  [@Rickus3126](https://community.baserow.io/u/Rickus3126)
#### Post date: [August 19, 2026, 5:04am UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/30 "2026-08-19T05:04:12Z")
Hi there
ok so i implemented the automation update and it worked upon publish, however, although it worked perfectly and did what i actually wanted it to do, it cleared all the boolean fields, BUT i need to get all that data back ASAP. i need my admin to report by the end of the week.
of about 650 entries, they lost around 380 when the automation kicked in during the test yesterday and its not going to be an easy thing to get that info back again. is there a way i can undo?
Thanks
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [August 19, 2026, 10:54am UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/31 "2026-08-19T10:54:03Z")
Hi @Rickus3126,
I’m sorry this happened. The automation ran on your live data, so when it updated the boolean fields, those changes were saved directly to the database. Unfortunately, there isn’t currently an “undo” option that can revert all changes made by an automation.
One option is to use the Audit Log, which shows which rows were changed. This is available on the Advanced plan. From there, you could identify the affected rows and restore the boolean fields manually, with a script, or with another automation.
If you don’t have an Audit Log or snapshot from before the automation ran, there isn’t currently a way to automatically restore the previous values.
For future testing, we recommend creating a snapshot or testing with a copy of the data before publishing an automation that updates records.
---
### Author:  [@Rickus3126](https://community.baserow.io/u/Rickus3126)
#### Post date: [August 19, 2026, 11:39am UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/32 "2026-08-19T11:39:41Z")
Thank you. i appreciate it. i am just happy that it actually worked. but like i said, the real test will be next week Monday morning when it should run automatically.
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [August 19, 2026, 1:06pm UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/33 "2026-08-19T13:06:18Z")
Please make sure you have a snapshot and first test the automation on a duplicated table to avoid any data loss.
---
### Author:  [@Rickus3126](https://community.baserow.io/u/Rickus3126)
#### Post date: [August 24, 2026, 3:56am UTC](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507/34 "2026-08-24T03:56:56Z")
some good feedback this morning. The automation ran and it was successful. thank you so much. i appreciate
[Previous page](https://community.baserow.io/t/automations-clearing-a-boolean-field/12507.md?page=1)