# Trigger Boolean into Column

**URL:** <https://community.glideapps.com/t/trigger-boolean-into-column/46302>\
**Category:** Ask for Help\
**Created:** [August 9, 2022, 7:03am UTC](https://community.glideapps.com/t/trigger-boolean-into-column/46302 "2022-08-09T07:03:03Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [August 9, 2022, 7:03am UTC](https://community.glideapps.com/t/trigger-boolean-into-column/46302/1 "2022-08-09T07:03:03Z")

</div>

Dear Community,

How do we set the If-Else-Then to Trigger a Boolean into another Column “Need Work Pass” which in turn will update the boolean value in Google Sheet.

 ![Need Work pass will trigger True in Need Work Pass Column](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/9229daac2c11e934f776957b2ea894900dc404b5.png)

Thanks in Advance.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 9, 2022, 7:06am UTC](https://community.glideapps.com/t/trigger-boolean-into-column/46302/2 "2022-08-09T07:06:13Z")

</div>

The only way to do that would be with an action.  
So you probably need to go back to whatever it is that changes to set the value in your “If Local” column, and set it at that point.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [August 9, 2022, 10:17am UTC](https://community.glideapps.com/t/trigger-boolean-into-column/46302/3 "2022-08-09T10:17:53Z")

</div>

Got it!

If the column in Glidetable is a Boolean column, what is the value i should indicate in the Action Step - Set Column to show the checked box in Google Sheet, instead of True?

 ![show checked box](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d1954691473e2801b9c5f80e319c41f011d6be87.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 9, 2022, 10:28am UTC](https://community.glideapps.com/t/trigger-boolean-into-column/46302/4 "2022-08-09T10:28:19Z")

</div>

I don’t believe that can be controlled from the Glide side. Although, you might try using uppercase TRUE. The Google Sheet might recognise that as a boolean value and insert a checkbox.  
You can also format the entire column in the Google Sheet as boolean by using “Insert → Checkbox”.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [August 9, 2022, 10:36am UTC](https://community.glideapps.com/t/trigger-boolean-into-column/46302/5 "2022-08-09T10:36:04Z")

</div>

THanks for your reply & support…

After reading [Action Set column true or 1 - #14 by Mishta\_P](https://community.glideapps.com/t/action-set-column-true-or-1/18470/14), decided to make it simply use and set text as “Yes” for glidetable and google sheet.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 10, 2022, 10:36am UTC](https://community.glideapps.com/t/trigger-boolean-into-column/46302/6 "2022-08-10T10:36:17Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.