# User Specific Number Field with Default Value

**URL:** <https://community.glideapps.com/t/user-specific-number-field-with-default-value/11894>\
**Category:** Ask for Help\
**Created:** [July 3, 2020, 7:57am UTC](https://community.glideapps.com/t/user-specific-number-field-with-default-value/11894 "2020-07-03T07:57:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\
**Post date:** [July 3, 2020, 7:57am UTC](https://community.glideapps.com/t/user-specific-number-field-with-default-value/11894/1 "2020-07-03T07:57:53Z")

</div>

Is there a way or a workaround to set a ‘default’ value for a user specific field?

So they all start with a value of ‘1’ for example, instead of a blank.

---

<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 3, 2020, 8:25am UTC](https://community.glideapps.com/t/user-specific-number-field-with-default-value/11894/2 "2020-07-03T08:25:30Z")

</div>

I don’t know if this is possible, hope somebody can chime in with an idea, but while we’re at it I would appreciate if you can describe your use case so we can think of a workaround.

---

<div class="post-metadata">

**Author:** ![jiabmsu\_msu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jiabmsu_msu/32/8945_2.png) [@jiabmsu\_msu](https://community.glideapps.com/u/jiabmsu_msu)\
**Post date:** [July 3, 2020, 9:53am UTC](https://community.glideapps.com/t/user-specific-number-field-with-default-value/11894/3 "2020-07-03T09:53:25Z")

</div>

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f11d494808dda7b37749888bd00ffe4d3c67423.jpeg "Single Value Column | Glide Data Editor Tutorial") ](https://www.youtube.com/watch?v=h31dASRgd1k)

Is something like this?

---

<div class="post-metadata">

**Author:** ![Cmstewart42](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cmstewart42/32/7319_2.png) [@Cmstewart42](https://community.glideapps.com/u/Cmstewart42)\
**Post date:** [July 3, 2020, 1:21pm UTC](https://community.glideapps.com/t/user-specific-number-field-with-default-value/11894/4 "2020-07-03T13:21:26Z")

</div>

Hi @qb15,

As long as whatever component you’re using to display the information can display an if/else column the below should work.

- default value column: in sheets create an array formula that simply returns the default value into every cell that has data in it (or perhaps a single value column as mentioned above)
- user column (user specific) : if the user wants to override the default this is where they will put the data
- display column: this column will be the one shown to the users. It will contain an if else. If user column is empty show default value else show user column. (this column should also be user specific by default as its logic references a user specific column)

---

<div class="post-metadata">

**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\
**Post date:** [July 4, 2020, 8:05am UTC](https://community.glideapps.com/t/user-specific-number-field-with-default-value/11894/5 "2020-07-04T08:05:03Z")

</div>

Hey @Cmstewart42 thanks for this solution. I tried to implement it.

The issue I ran into was that:

1. IF THAN ELSE columns: These do not appear to be able to be made ‘user specific’.
2. CHOICE: I’m using a choice field for the user to update the value. I had trouble linking this to the IF THAN ELSE/ so they coincided with each other.

So, I did figure it out though. I used the FEATURE \> Visibility and created Default Value components for all displayed components. Set them to display only with no CHOICE option set, and set the CHOICE option components (the dynamic ones linked to USERS) to only be visibile once a choice is made (i.e. not NULL).

Thanks for all your help with this guys.

---

<div class="post-metadata">

**Author:** ![Cmstewart42](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cmstewart42/32/7319_2.png) [@Cmstewart42](https://community.glideapps.com/u/Cmstewart42)\
**Post date:** [July 4, 2020, 2:28pm UTC](https://community.glideapps.com/t/user-specific-number-field-with-default-value/11894/6 "2020-07-04T14:28:49Z")

</div>

Hi @qb15,

I believe the if/else column inherently becomes user specific if it references a user specific column or owned row (please let me know if you find this not to be the case).

The if/else column should look something like:

- if userchoicecolumn is empty then default column else userchoicecolumn
