# How to assign integer value via the set columns action?

**URL:** <https://community.glideapps.com/t/how-to-assign-integer-value-via-the-set-columns-action/29541>\
**Category:** Ask for Help\
**Created:** [July 26, 2021, 4:45am UTC](https://community.glideapps.com/t/how-to-assign-integer-value-via-the-set-columns-action/29541 "2021-07-26T04:45:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jirang\_Kumnuanta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jirang_kumnuanta/32/26602_2.png) [@Jirang\_Kumnuanta](https://community.glideapps.com/u/Jirang_Kumnuanta)\
**Post date:** [July 26, 2021, 4:45am UTC](https://community.glideapps.com/t/how-to-assign-integer-value-via-the-set-columns-action/29541/1 "2021-07-26T04:45:58Z")

</div>

Hello guys, I need help.

Is there anyway to assign integer value via the set columns action?  
I found that when I put 5 in the custom field, it set '5 (string) into the cell instead of 5 (number).

Best Regards,  
Joe

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [July 26, 2021, 6:00am UTC](https://community.glideapps.com/t/how-to-assign-integer-value-via-the-set-columns-action/29541/2 "2021-07-26T06:00:30Z")

</div>

Hi

I remember seeing a similar post the other day. Perhaps related? It has a solution, worth a read

[https://community.glideapps.com/t/apostrophe-mark-is-added-to-gs-cells/29325](https://community.glideapps.com/t/apostrophe-mark-is-added-to-gs-cells/29325)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 26, 2021, 8:07am UTC](https://community.glideapps.com/t/how-to-assign-integer-value-via-the-set-columns-action/29541/3 "2021-07-26T08:07:36Z")

</div>

As said in the thread @Rosewebstudio provided, if you source it from a numeric column (and not from a custom value or a non-numeric column) then it will work.

[https://community.glideapps.com/t/apostrophe-mark-is-added-to-gs-cells/29325/11?u=thinhdinh](https://community.glideapps.com/t/apostrophe-mark-is-added-to-gs-cells/29325/11)

---

<div class="post-metadata">

**Author:** ![Jirang\_Kumnuanta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jirang_kumnuanta/32/26602_2.png) [@Jirang\_Kumnuanta](https://community.glideapps.com/u/Jirang_Kumnuanta)\
**Post date:** [July 26, 2021, 9:17pm UTC](https://community.glideapps.com/t/how-to-assign-integer-value-via-the-set-columns-action/29541/4 "2021-07-26T21:17:59Z")

</div>

Thank you @Rosewebstudio, but I don’t understand the solution. My app uses that column to calculate for another column by using vlookup formula in google sheets.

yes @ThinhDinh, I also found that problem. I wonder that the column was fixed to number entry, but why when user typed numbers in a form, Glide app stored it as text.

My fix was modifying the user’s input (text) to store in a glide table, then assign that value back to the intended column.

What I wondered was about why I just can’t use the user’s number entry directly as it should be stored as number, not a text.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 26, 2021, 11:46pm UTC](https://community.glideapps.com/t/how-to-assign-integer-value-via-the-set-columns-action/29541/5 "2021-07-26T23:46:14Z")

</div>

> [@Jirang\_Kumnuanta](#):
>
> What I wondered was about why I just can’t use the user’s number entry directly as it should be stored as number, not a text.

Well as you said, I think this is a bug.