# Add to List - setting a field to a default

**URL:** https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569
**Category:** Ask for Help
**Created:** [December 8, 2020, 6:48pm UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569 "2020-12-08T18:48:15Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![NigelG](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nigelg/32/12818_2.png) [@NigelG](https://community.glideapps.com/u/NigelG)
#### Post date: [December 8, 2020, 6:48pm UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/1 "2020-12-08T18:48:15Z")

</div>

I have a list of items that the user can add to.

Ideally, the item will go through a set of statuses Draft \> Open \> Closed

Using a Button Action I can use “Set Columns” to set the status using a Template column value. And the new Actions can kick off a Zap … hurrah for Actions 🙂

What I can’t do is set the field to “Draft” when it is created. I can set the owner using a “Special Value” but just can’t work out how to default something.

Can’t update a template column, so it can’t be that. Maybe empty = “draft” ?

Any pointers would be great, thanks.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 8, 2020, 7:07pm UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/2 "2020-12-08T19:07:57Z")

</div>

I hope that someday we have the option to set a column value by typing it in within actions. Are you using a Form Button or the Add function to add records? Depending on how your app is set up (a form for example), you should be able to create a template column with the default value in the sheet the is being used to display the form button. Then you can pass that default value through the form/add-row/set-column and write it to the final destination sheet.

---

<div class="post-metadata">

### Author: ![NigelG](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nigelg/32/12818_2.png) [@NigelG](https://community.glideapps.com/u/NigelG)
#### Post date: [December 8, 2020, 9:04pm UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/3 "2020-12-08T21:04:19Z")

</div>

Thanks. I am using the Add function, but can’t see how to add this.

I can set up a field on the form and then hide it, but it doesn’t then get updated. Am I missing something on setting up the Add function ?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 8, 2020, 9:32pm UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/4 "2020-12-08T21:32:08Z")

</div>

In a form you have the Column Value components which allow you to pull values from the parent sheet and pass then to the form sheet without having to display anything on the screen. I believe the same is true for setting values from the parent sheet row when using the set columns or add row actions.

> **[Screen columns](https://docs.glideapps.com/all/reference/values/column-values)**
>
> Submit existing column values on behalf of the user.

However, the Add function does not give you the option for Column Values, because when you select the Add function, you are not view a specific row. Only a list of row, so there isn’t specific details from a single row that it can pull from. There is the option though to set up User Profiles and then in your user profile sheet, you can create a template column with the value of ‘Draft’. The Add function will allow you pass through values from the user profile much the same as how Column Values works.

So if you plan the use the Add function (plus/add button at the top right of the screen), then I would recommend the template column in the user profile sheet and just pass that template value through to the sheet you are adding to.

---

<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: [December 8, 2020, 11:50pm UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/5 "2020-12-08T23:50:25Z")

</div>

Not sure about this as I haven’t tested, but would a text entry with a default value, then set visibility condition to hidden work here? I assume it would?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 9, 2020, 12:44am UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/6 "2020-12-09T00:44:59Z")

</div>

I’d have to test that out too. I’m not sure if hiding an entry component holds on to the default value. Something to try though. It would be much simpler.

---

<div class="post-metadata">

### Author: ![NigelG](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nigelg/32/12818_2.png) [@NigelG](https://community.glideapps.com/u/NigelG)
#### Post date: [December 9, 2020, 1:15am UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/7 "2020-12-09T01:15:19Z")

</div>

I did try that, and it doesn’t work.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 9, 2020, 6:53am UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/8 "2020-12-09T06:53:13Z")

</div>

Did you try the other methods I posted?

---

<div class="post-metadata">

### Author: ![NigelG](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nigelg/32/12818_2.png) [@NigelG](https://community.glideapps.com/u/NigelG)
#### Post date: [December 9, 2020, 9:08am UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/9 "2020-12-09T09:08:00Z")

</div>

Argh, I was staring at those User Profile columns wondering if I could set all my Profile Names to “Default”. And completely missed the obvious option of adding a new one.

Thank you 🙂

So I can now set Owner and Status on the built in List “Add”

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a3b04a827bc9b0276a365de1f7db3051ad104ab.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/111b9cc1199b20bcfcea2f70cc03b78601024f4d.png)

---

<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: [December 9, 2020, 11:25am UTC](https://community.glideapps.com/t/add-to-list-setting-a-field-to-a-default/19569/10 "2020-12-09T11:25:44Z")

</div>

@NigelG it’s great when you work something out and get the results you need. Nice one ☝
