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 t…

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.…

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…

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 …

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…

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	2221	March 20, 2021
Trigger Boolean into Column Ask for Help	5	1092	August 9, 2022
Setting Column Action Ask for Help	5	284	October 21, 2021
Custom action not working properly Ask for Help actions	10	1143	January 17, 2024
Transform a 2 option column into a true / false boolean column Ask for Help	5	419	January 17, 2024

Action Set column true or 1

Related topics