Hi, I am trying to create the following actions for a button for user to indicate their “attendance” to an event. When user clicks on button their information is captured to a “response sheet” by adding a row. this works fine. the second action is set column (which is actually set cell). i want to set a boolean to a cell to “True” or “1” but kind of stuck on how to get it done as options available are all related to the columns in the sheet only. Once I set this cell, I will see it for other purposes such as “sorting” or “visibility”. Suggestions please.

Create a template column with value True and set the column you need to that template column.

Can also use the increment action with increment = 1

ok, set column works fine with ideas from Thinh and Manan…what I am attempting to do is use this Boolean cell to setup visibility condition. That means if button is click, the user have registered and the cell, we call “bookmark”, is pulled to “true”. what i noticed is this switch is user specific. So if it is manually pulled by the user, then the visibility conditions work. But if we use the “set column” method, visibility condition does not work. It is somehow related to user specific columns… Further suggestions much appreciated.

Can you describe more about the visibility conditions you want after this?

I had the same situation over the weekend with the set column. For some reason the set column didn’t like setting from “true”, but it does seem to work if you use the set column to copy another boolean column that is already ticked.

I have the same “issue” that with set columns action “true” seems to be considered a text word like any other word instead of a Boolean value. The copy of the value suggested seems to me more a workaround than a solution. Would it be possible to understand if there is a way to give the Boolean value correctly without adding a column? Thanks, Bye bye!!

Have your tried “True” with T capital or “TRUE” with everything capital? I think both of these work fine.

I’ve successfully changed a Boolean column using the set column action with the custom value true

I’ve run into issues where I have an IFTHEN that is looking at a Boolean value. I can’t remember for sure how it messed up, but I think the action was setting a Boolean to “1” , then I had an IFTHEN checking if the column was “true”. It didn’t work until I changed the IFTHEN to check for “1” as the value of the Boolean. In other cases I can think of in Glide, true and 1 were seen the same in an IFTHEN… but when the 1 is set by an action, that doesn’t seem to be the case.

I agree with fabio - there is definitely something fishy going on when you set a value in a Boolean column in a set columns action. And it doesn’t matter whether you write “1”, “true”, “TRUE”, “True” or any other reasonable value. The problem is that the value is stored as text. But it is very hard to figure out, as it seems like Glide to some extent cope correctly with the text value. It is even presented correctly in a Boolean column (see picture below): [Problems with booleans in Glide] However, Sheets is not fooled. If you try to treat the corresponding cells in Sheets as Boolean values it will not work, because Sheets recognize it as text - it turns out that the cell actually contains 'TRUE and not TRUE, i.e. Sheets see it as text. Consequently, you can’t expect that you can use any kind of logic in Sheets correctly on these values - unless you know what is going on. Why Glide works like that I have no clue. But it is extremely tricky to figure out why your app doesn’t work when you try to set a Boolean value in a set columns action. My workaround has been to change the Boolean column to a text column and then fill it “Yes” and “No” values instead. Then I’m not in doubt, that it is actually a text value. But, of course, if you need to set values in the same column in a checkbox component too that workaround will not work.

Action Set column true or 1

Ask for Help

rickc August 30, 2022, 1:14pm 20

At least this workaround is still working.

Topic		Replies	Views
Action "Set columns" won't set boolean but strings as[ 'TRUE ] [ 'FALSE ] Report a Bug	11	2313	March 20, 2021
Trigger Boolean into Column Ask for Help	4	1134	August 9, 2022
Setting Column Action Ask for Help	5	317	October 21, 2021
Custom action not working properly Ask for Help actions	9	1192	January 24, 2021
Transform a 2 option column into a true / false boolean column Ask for Help	4	463	February 5, 2021

Action Set column true or 1

Related topics