How to update a Google Sheet checkbox cell using Make - Update a Row

How To
1

I’m attempting to update a Google Sheet cell that is formatted as a checkbox using the Google Sheets module - Update a Row activity. The underlying value should be a boolean true or false. I’ve tried the following in the Values section:
false
FALSE
{{false}}
{{FALSE}}

I used the Make AI feature to set the value as a Boolean and it returned {{false}}. But that didn’t work either. It keeps overwriting the checkbox with a string value.

image
image442×640 19.4 KB

image
image292×185 2.26 KB

Note, I’m having the same issue with setting a timestamp but I assume solving the first one will solve the second one.

3

Hey Erik,

it should be FALSE (text string all caps) or TRUE respectively, to change the checkbox value.