Action triggered despite it being a new Google Sheets row entry not an updated one

Hi ​@Ray_Pfaff 

Add a Filter as Zap step 2: https://zapier.com/apps/filter/help

Set a condition to check for the value in the desired trigger column.

Hey ​@Ray_Pfaff 👋

How did you get on with that filter Troy suggested adding? Did that allow you to prevent the Zap from continuing if the checkbox was not checked?

Keen to ensure you’re all squared away on this so would love to hear how you’re getting on - happy to help if you’re still stuck at all! 🙂

Hi ​@Troy Tessalone and ​@SamB ,

Appreciate both of you for your help and encouragement. I think I am close but notice an issue. My fields are checkboxs in my trigger column. When creating a filter I can select the appropriate column but my options for the condition don’t seem to line up. I expected to find something along the lines of “if checked” or “if not checked” I have options for text, date, Boolean, and numbers. Screenshot attached.

I think once I figure this step out I should be good!

Thanks for getting back to me, ​@Ray_Pfaff! 🙂

Often with checkbox type fields they will use Boolean values to indicate whether they are checked or not, e.g. checked = true, unchecked = false. Sure enough, I had double-checked a checkbox field from my own Google Sheets spreadsheet and when it is unchecked we see the value of FALSE come through:

So in the filter you’d want to select the (Boolean) Is true option. That will ensure that the Zap only continues to run if the row that triggers the Zap has the checkbox ‘checked’.

Can you give that a try and let us know if that works as hoped?

​@Ray_Pfaff 

If you still need help, post screenshots showing the DATA OUT from Zap step 1 that you are trying to use, so we can see the actual data values.

Yay! 😁🎉 That’s fantastic news, ​@Ray_Pfaff. Thanks so much for following up here to keep us updated, and great work on getting it all sorted! 🙌

Please do reach back out to the Community if we can help with anything else. Until then, happy Zapping! ⚡