# Custom action not working properly **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [January 16, 2021, 6:36pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271 "2021-01-16T18:36:42Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [January 16, 2021, 6:36pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/1 "2021-01-16T18:36:42Z")
I have a custom action on add a new item (Requests sheet) which has two columns, pickup (type boolean in Glide table) and pickup option (type text in Glide table) In the form there is a checkbox for **pickup** , based on when it is checked or not, I need to populate pickup option column in Google Sheet with different text. In my custom action (as shown below) I have two paths based on **pick** up value (I am assuming pick will be TRUE if user selects the checkbox on form else it will be FALSE, I hope this assumption is correct), I am first adding a row and then updating the value of **pickup option** , using set column. With this action, first of all two identical records are being added (looks like condition is being ignored) and Set column is not setting the value for pick up option. Am I not using the custom action in the right way? ![Screen Shot 2021-01-16 at 1.22.15 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/e/9e251d702477d0eb8659ad61f34d13e76913e22c.png) ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [January 16, 2021, 6:51pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/2 "2021-01-16T18:51:11Z")
Just wanted to provide some additional context. I need to have **pickup option** column in Google sheet (not just Glide table) as my Zap needs to use that value in an email message. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [January 16, 2021, 7:54pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/3 "2021-01-16T19:54:42Z")
Try to change the True condition to 1 and see if it works. Boolean values are acting a bit oddly in actions — at least for me! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 16, 2021, 7:59pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/4 "2021-01-16T19:59:16Z")
Lowercase ‘true’ might be something to try too if ‘1’ doesn’t working. I usually do my conditions with lowercase true and haven’t noticed any issues. ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [January 17, 2021, 3:21am UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/5 "2021-01-17T03:21:57Z")
I tried both 1 and lowercase **true** and neither of them worked. ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [January 17, 2021, 4:52pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/6 "2021-01-17T16:52:58Z")
So I have identified the issue is not with **if** logic but with the **set columns** action. It is not updating the column value. I wonder if that is a bug as mentioned in this post [Set column doesn't update GSheet - #14 by Mns\_Glide](https://community.glideapps.com/t/set-column-doesnt-update-gsheet/20893/14) . Also duplication was caused by **Add row** in my custom action. The data from the form is already added to Sheet, by the time you come in custom action. Once I took **add row** action out, no more duplicate rows. Can any of Glide experts @Jeff_Hager@eltintero ?? or Glide support comment on **set columns** issue? ---
**Author:** ![McJagger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjagger/32/18616_2.png) [@McJagger](https://community.glideapps.com/u/McJagger)\ **Post date:** [January 17, 2021, 4:55pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/7 "2021-01-17T16:55:15Z")
Do you have video of your scenario? Maybe as you build out the action? ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [January 17, 2021, 5:26pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/8 "2021-01-17T17:26:56Z")
I wrote a small test app to replicate the issue. Check it out [https://precious-kick-8647.glideapp.io/](https://precious-kick-8647.glideapp.io/) ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [January 17, 2021, 5:35pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/9 "2021-01-17T17:35:48Z")
and here is a link to Video [Glide test app](https://www.loom.com/share/becd9e9272f849e9badd54350f41b735) ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [January 24, 2021, 6:02pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/10 "2021-01-24T18:02:07Z")
BTW Glide support has acknowledged this as a bug because of the way they create record in GSheet, it cannot be immediately followed by updating a column in the same row. The fix may not come soon. BTW I have implemented a fix in GSheet using IF and ARRAYFORMULA which does the job for me. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/custom-action-not-working-properly/21271/11 "2024-01-17T16:53:44Z")