# Set Dropdown default Value to Database Value **URL:** \ **Category:** Need help\ **Created:** [November 24, 2023, 8:54am UTC](https://forum.bubble.io/t/set-dropdown-default-value-to-database-value/294633 "2023-11-24T08:54:54Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Rallis](https://avatars.discourse-cdn.com/v4/letter/r/dfb087/32.png) [@Rallis](https://forum.bubble.io/u/Rallis)\ **Post date:** [November 24, 2023, 8:54am UTC](https://forum.bubble.io/t/set-dropdown-default-value-to-database-value/294633/1 "2023-11-24T08:54:54Z")
Hi. I´m using an external database. And want the default value in a dropdown to be the value in the database. How can I achieve that? I have tried to add a filter constraint but the default value field turns red. Any idea how to solve this? 🙂 ![Skjermbilde 2023-11-24 kl. 09.54.29](https://us1.discourse-cdn.com/bubble/original/3X/e/6/e68964dc3b3e316d9fb3d5a50732424678edb38a.png) ---
**Author:** ![msgiblin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/msgiblin/32/119904_2.png) [@msgiblin](https://forum.bubble.io/u/msgiblin)\ **Post date:** [November 24, 2023, 7:52pm UTC](https://forum.bubble.io/t/set-dropdown-default-value-to-database-value/294633/2 "2023-11-24T19:52:15Z")
Have you tried setting your Default Value exactly like you have the Placeholder in the screenshot? ---
**Author:** ![Rallis](https://avatars.discourse-cdn.com/v4/letter/r/dfb087/32.png) [@Rallis](https://forum.bubble.io/u/Rallis)\ **Post date:** [November 27, 2023, 11:54am UTC](https://forum.bubble.io/t/set-dropdown-default-value-to-database-value/294633/3 "2023-11-27T11:54:49Z")
I solved the default value on my “insert” functionality. But I got another problem: I’ve successfully implemented an edit function in my Bubble application, but I’ve encountered a new challenge. Specifically, I’m working on retrieving a Unique ID from a row to edit the corresponding data. I’m currently facing an issue with the Bubble editor where I need to use two different queries – one for the Choice source and another to fetch the default value (the value already registered on the record). Bubble seems to be posing a challenge in handling this dual-query scenario. I would greatly appreciate any tips or guidance on how to effectively manage two distinct queries for the Choice source and default value in the Bubble editor. ---
**Author:** ![renato.wiltgen](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/renato.wiltgen/32/91687_2.png) [@renato.wiltgen](https://forum.bubble.io/u/renato.wiltgen)\ **Post date:** [January 13, 2024, 2:30am UTC](https://forum.bubble.io/t/set-dropdown-default-value-to-database-value/294633/4 "2024-01-13T02:30:45Z")
have you got any luck? I’m facing exactly the same issue. I have a list of users and a list o roles. In a repeating group I have my users listed and one field is a dropdown with all available roles in the databse. It works fine. I can see the choices and when I choose one it triggers an edit which is work fine too. The problem resides when I list the users, I need the Default Value of that dropdown to be the role ID for each user but this is not working. It reverts to the Place Holder… if I choose any choice, the EDIT trigger works just fine. Anyone can help me with that? Thanks in advance ---
**Author:** ![Rallis](https://avatars.discourse-cdn.com/v4/letter/r/dfb087/32.png) [@Rallis](https://forum.bubble.io/u/Rallis)\ **Post date:** [January 14, 2024, 11:38am UTC](https://forum.bubble.io/t/set-dropdown-default-value-to-database-value/294633/5 "2024-01-14T11:38:16Z")
Yes! I solved it like this: ![Skjermbilde 2024-01-14 kl. 12.37.58](https://us1.discourse-cdn.com/bubble/original/3X/5/f/5fa632b11cea6e8d391b212217581c23c97c660f.png) ---
**Author:** ![renato.wiltgen](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/renato.wiltgen/32/91687_2.png) [@renato.wiltgen](https://forum.bubble.io/u/renato.wiltgen)\ **Post date:** [January 14, 2024, 12:11pm UTC](https://forum.bubble.io/t/set-dropdown-default-value-to-database-value/294633/6 "2024-01-14T12:11:22Z")
Fantastic! Thank you very much. Worked like a charm I owe you a 🍺 ---
**Author:** ![Rallis](https://avatars.discourse-cdn.com/v4/letter/r/dfb087/32.png) [@Rallis](https://forum.bubble.io/u/Rallis)\ **Post date:** [January 14, 2024, 3:16pm UTC](https://forum.bubble.io/t/set-dropdown-default-value-to-database-value/294633/7 "2024-01-14T15:16:43Z")
Perfect! ---
**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\ **Post date:** [February 2, 2024, 8:55am UTC](https://forum.bubble.io/t/set-dropdown-default-value-to-database-value/294633/8 "2024-02-02T08:55:30Z")
Closed on February 2, 2024, 8:55am UTC This topic was automatically closed after 70 days. New replies are no longer allowed.