I have a zap which sends a row from one google sheet to another when a check box is ticked. I notice that the zap now says the check box column is considered updated even when new a row is added and the box is empty. It does say I can use a filter step to ensure that this doesn't happen.
The problem is Zapier doesn't seem to recognise the empty check box as a value I can filter by.
Does anyone know how I can get Zapier to register an empty check box so that I can filter by whether it is empty or ticked?
Best answer by SamB
Hey there @Laurence Hidson!
I just did a test in one of my Google Sheets with a checkbox column and it looks like empty checkboxes come through with a value of FALSE: And they come through as TRUE when they’re checked.
Are you getting a TRUE or FALSE value in the column that contains the checkbox for the row?
If so, you could set up the Filter to see if the value in the checkbox column has a value of TRUE. That would mean that the Zap would only continue if the checkbox is ticked.
Hopefully that helps. Please keep us in the loop on this!
I just did a test in one of my Google Sheets with a checkbox column and it looks like empty checkboxes come through with a value of FALSE: And they come through as TRUE when they’re checked.
Are you getting a TRUE or FALSE value in the column that contains the checkbox for the row?
If so, you could set up the Filter to see if the value in the checkbox column has a value of TRUE. That would mean that the Zap would only continue if the checkbox is ticked.
Hopefully that helps. Please keep us in the loop on this!