# Default values? \[Feb 05\]

**URL:** <https://community.nocodb.com/t/default-values-feb-05/242>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 8:08am UTC](https://community.nocodb.com/t/default-values-feb-05/242 "2022-11-03T08:08:29Z")\
**Posts on this page:** 14\
**Page:** 2

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:08am UTC](https://community.nocodb.com/t/default-values-feb-05/242/21 "2022-11-03T08:08:51Z")

</div>

> 💁 **o1lab** _replied_

#### I’m on mobile so I’m unable to confirm exactly

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:08am UTC](https://community.nocodb.com/t/default-values-feb-05/242/22 "2022-11-03T08:08:52Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### Ok, I’ll mention both 👍 thanks for your time

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:08am UTC](https://community.nocodb.com/t/default-values-feb-05/242/23 "2022-11-03T08:08:53Z")

</div>

> 💁 **o1lab** _replied_

#### Thanks for your patience, will have a fix in upcoming release

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:08am UTC](https://community.nocodb.com/t/default-values-feb-05/242/24 "2022-11-03T08:08:54Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### Hi Shard@discord. The default values are assigned to columns when they are not specified. They won’t show in UI when you create a new row nor a form view.

#### 

#### System fields are disabled in Form View on purpose.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:08am UTC](https://community.nocodb.com/t/default-values-feb-05/242/25 "2022-11-03T08:08:55Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### for the “Option” field even though the type of it is text, I can only use integers as Default value.

#### 

#### I believe you missed the single quote

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:08am UTC](https://community.nocodb.com/t/default-values-feb-05/242/26 "2022-11-03T08:08:56Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### Do you mean that I need to hide the field from the form so it gets the default value?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:08am UTC](https://community.nocodb.com/t/default-values-feb-05/242/27 "2022-11-03T08:08:57Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### And for the option field if I want to set a default text value I need to write it like this: “blabla” ?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:08am UTC](https://community.nocodb.com/t/default-values-feb-05/242/28 "2022-11-03T08:08:59Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### e.g. ‘blablabla’

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:09am UTC](https://community.nocodb.com/t/default-values-feb-05/242/29 "2022-11-03T08:09:00Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### you don’t need to hide anything. Default value means if the column takes this value if it s not present.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:09am UTC](https://community.nocodb.com/t/default-values-feb-05/242/30 "2022-11-03T08:09:01Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### For example, if i hv a column called ‘colA’ with default value ‘abcde’ and a column called ‘colB’.

#### 

#### Let’s say i input colB with sth, when i submit the form, it ll triggere the API to insert the data to db. the db sees there is no value for colA, then it ll feed the default value there

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:09am UTC](https://community.nocodb.com/t/default-values-feb-05/242/31 "2022-11-03T08:09:02Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### so when u go back to the grid view, u should be able to see the default value ‘abcde’ in colA

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:09am UTC](https://community.nocodb.com/t/default-values-feb-05/242/32 "2022-11-03T08:09:03Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### another case is I input something to ‘colA’, says ‘xyz’. the db sees there s a value for colA, so it would take it. when u go back to the grid view, u should see ‘xyz’ instead of the default value ‘abcde’

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:09am UTC](https://community.nocodb.com/t/default-values-feb-05/242/33 "2022-11-03T08:09:04Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### Ok, I understand it now. Thanks 👍

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:09am UTC](https://community.nocodb.com/t/default-values-feb-05/242/34 "2022-11-03T08:09:05Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/938544444695793687)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)

[Previous page](https://community.nocodb.com/t/default-values-feb-05/242.md?page=1)
