How to assign integer value via the set columns action?

Ask for Help
1

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

2

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

1 Like
3

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

2 Likes
4

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.

5

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