# Saving drop down list to database

**URL:** <https://forum.bubble.io/t/saving-drop-down-list-to-database/9895>\
**Category:** Database\
**Created:** [January 25, 2017, 9:08pm UTC](https://forum.bubble.io/t/saving-drop-down-list-to-database/9895 "2017-01-25T21:08:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ruigie](https://avatars.discourse-cdn.com/v4/letter/r/e19b73/32.png) [@ruigie](https://forum.bubble.io/u/ruigie)\
**Post date:** [January 25, 2017, 9:08pm UTC](https://forum.bubble.io/t/saving-drop-down-list-to-database/9895/1 "2017-01-25T21:08:43Z")

</div>

So, I have a dropdown list with plans that are listed out. I’m trying to get the workflow to reflect a yes/no for which plans were picked. I have 4 fields 12 months/3 months/6 Months/ and Month to Month. So far i see that the data on the database reflects my plans, but for some reason it’s not reflecting the data correctly.

How do i display which value that is selected in my dropdown as yes/no properly on the database?

 ![](https://us1.discourse-cdn.com/bubble/original/2X/0/0b557aa8065f71e472e6fa105742ddadd16e88f7.png) ![](https://us1.discourse-cdn.com/bubble/original/2X/1/16f502bef642d67f6fadaa59f671f3b751591c40.png) ![](https://us1.discourse-cdn.com/bubble/original/2X/e/ef649f5b2ce5d3aebadf15634127929e1bbe492a.png)

---

<div class="post-metadata">

**Author:** ![romanmg](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/romanmg/32/237672_2.png) [@romanmg](https://forum.bubble.io/u/romanmg)\
**Post date:** [January 25, 2017, 9:16pm UTC](https://forum.bubble.io/t/saving-drop-down-list-to-database/9895/2 "2017-01-25T21:16:15Z")

</div>

The values you’re setting return a yes/no response to whether the value is empty or not. Look at it like a question is being asked: Is dropdown’s payment plan’s value not empty? yes or no? It’s always going to be yes because something is going to be selected.

It should be:

12 months = Dropdown Payment Plan’s value is 12 months  
3 months = Dropdown Payment Plan’s value is 3 months

The important thing is that the value you type in after “is” needs to be the exact same (case-sensitive) as how you have it written in the dropdown options.

Now, the “answer” to those values should only be “yes” for the one that is true and “no” for those that are false. Make sense?

* * *

Gaby | [Coaching Bubble](https://coachingbubble.com)

---

<div class="post-metadata">

**Author:** ![ruigie](https://avatars.discourse-cdn.com/v4/letter/r/e19b73/32.png) [@ruigie](https://forum.bubble.io/u/ruigie)\
**Post date:** [January 25, 2017, 10:34pm UTC](https://forum.bubble.io/t/saving-drop-down-list-to-database/9895/3 "2017-01-25T22:34:56Z")

</div>

Thank you, definitely made sense.

---

<div class="post-metadata">

**Author:** ![jones.alves](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@jones.alves](https://forum.bubble.io/u/jones.alves)\
**Post date:** [April 15, 2022, 11:53am UTC](https://forum.bubble.io/t/saving-drop-down-list-to-database/9895/4 "2022-04-15T11:53:30Z")

</div>

It would be more practical if there was an option to save the index!  
Is there this?
