# Custom action, "Add row" - how to fill with a numerical value? **URL:** \ **Category:** Ask for Help\ **Created:** [June 24, 2021, 4:10pm UTC](https://community.glideapps.com/t/custom-action-add-row-how-to-fill-with-a-numerical-value/28321 "2021-06-24T16:10:49Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Daniil](https://avatars.discourse-cdn.com/v4/letter/d/3d9bf3/32.png) [@Daniil](https://community.glideapps.com/u/Daniil)\ **Post date:** [June 24, 2021, 4:10pm UTC](https://community.glideapps.com/t/custom-action-add-row-how-to-fill-with-a-numerical-value/28321/1 "2021-06-24T16:10:49Z")
Hi all. Situation - there is a field in numeric format. When filling this field via “Add row”, the value is a text value, while I need a numeric value. There is an option, of course, via a formula in Google.Sheet to convert this value to numeric, but this is wrong. Is there any working way to do it quickly and without pain)? ---
**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:** [June 24, 2021, 4:31pm UTC](https://community.glideapps.com/t/custom-action-add-row-how-to-fill-with-a-numerical-value/28321/2 "2021-06-24T16:31:25Z")
Are you filling that destination column with another column or a custom value? ---
**Author:** ![Daniil](https://avatars.discourse-cdn.com/v4/letter/d/3d9bf3/32.png) [@Daniil](https://community.glideapps.com/u/Daniil)\ **Post date:** [June 25, 2021, 7:30am UTC](https://community.glideapps.com/t/custom-action-add-row-how-to-fill-with-a-numerical-value/28321/3 "2021-06-25T07:30:16Z")
I am filling it as a custom value. It is expected that as the field has a numeric value, only the numeric value will go there, the other types of value will be replaced by NULL ---
**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:** [June 25, 2021, 7:44am UTC](https://community.glideapps.com/t/custom-action-add-row-how-to-fill-with-a-numerical-value/28321/4 "2021-06-25T07:44:26Z")
So this is more about the formatting in Sheets, you already have that column as a number column inside Glide right? ---
**Author:** ![Daniil](https://avatars.discourse-cdn.com/v4/letter/d/3d9bf3/32.png) [@Daniil](https://community.glideapps.com/u/Daniil)\ **Post date:** [June 25, 2021, 12:39pm UTC](https://community.glideapps.com/t/custom-action-add-row-how-to-fill-with-a-numerical-value/28321/5 "2021-06-25T12:39:42Z")
Yes, in the GlideApps editor the field is of data type “Number” ---
**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:** [June 25, 2021, 12:48pm UTC](https://community.glideapps.com/t/custom-action-add-row-how-to-fill-with-a-numerical-value/28321/6 "2021-06-25T12:48:59Z")
Yeah, I can confirm I faced this before. It seems like the custom values are automatically formatted as a text. My workaround back then was to have a math column with a single number then write that column to the destination. It works, but it should have been automatic. ---
**Author:** ![Daniil](https://avatars.discourse-cdn.com/v4/letter/d/3d9bf3/32.png) [@Daniil](https://community.glideapps.com/u/Daniil)\ **Post date:** [June 25, 2021, 12:50pm UTC](https://community.glideapps.com/t/custom-action-add-row-how-to-fill-with-a-numerical-value/28321/7 "2021-06-25T12:50:04Z")
I have the same implementation now, but it doesn’t seem quite right to me - the value type conversion should be at the GlideApps level. Thanks for the comments, question closed.