# Database Dropdown List with button

**URL:** <https://forum.wixstudio.com/t/database-dropdown-list-with-button/929>\
**Category:** Ask the community\
**Tags:** code, question\
**Created:** [February 16, 2021, 2:27pm UTC](https://forum.wixstudio.com/t/database-dropdown-list-with-button/929 "2021-02-16T14:27:19Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![rebecarpop](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/rebecarpop/32/9049_2.png) [@rebecarpop](https://forum.wixstudio.com/u/rebecarpop)\
**Post date:** [February 16, 2021, 2:27pm UTC](https://forum.wixstudio.com/t/database-dropdown-list-with-button/929/1 "2021-02-16T14:27:19Z")

</div>

I need help setting up a dropdown and a button, the first time I tried it worked, I followed the steps from this post - [https://www.wix.com/velo/forum/community-discussion/dropdown-box-url-button-linked-database](https://www.wix.com/velo/forum/community-discussion/dropdown-box-url-button-linked-database)  
Everytime I click my button. It takes me to the first URL on my database, not the corresponding URL on the database  
This is my code -  
import wixData from ‘wix-data’ ;  
import wixLocation from ‘wix-location’ ;

export function dropdown1\_change(event, $w) {  
$w( “#dataset1” ).setCurrentItemIndex(event.target.selectedIndex)

}  
export function button1\_click(event, $w) {  
wixLocation.to($w( “#dataset1” ).getCurrentItem().url);

}

How do I change it so it links to the correct one?

---

<div class="post-metadata">

**Author:** ![rebecarpop](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/rebecarpop/32/9049_2.png) [@rebecarpop](https://forum.wixstudio.com/u/rebecarpop)\
**Post date:** [February 16, 2021, 2:29pm UTC](https://forum.wixstudio.com/t/database-dropdown-list-with-button/929/2 "2021-02-16T14:29:40Z")

</div>

This is how my dropdown, button and dataset are set up

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [February 17, 2021, 4:38am UTC](https://forum.wixstudio.com/t/database-dropdown-list-with-button/929/3 "2021-02-17T04:38:30Z")

</div>

Already tried to disconnect your button from DATASET?

---

<div class="post-metadata">

**Author:** ![rebecarpop](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/rebecarpop/32/9049_2.png) [@rebecarpop](https://forum.wixstudio.com/u/rebecarpop)\
**Post date:** [February 17, 2021, 7:02am UTC](https://forum.wixstudio.com/t/database-dropdown-list-with-button/929/4 "2021-02-17T07:02:38Z")

</div>

I tried now but it doesn’t work

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [February 17, 2021, 2:24pm UTC](https://forum.wixstudio.com/t/database-dropdown-list-with-button/929/5 "2021-02-17T14:24:02Z")

</div>

Try this one and take also a look into the CONSOLE!  
Which resulst and messages do you get there?

```javascript
import wixData from'wix-data'; 
import wixLocation from'wix-location';

$w.onReady(()=>{
    $w("#dataset1").onReady(()=>{
        $w('#dropdown1').onChange((event)={console.log("DropDown-changed")
           console.log(event.target.selectedIndex)
           $w("#dataset1").setCurrentItemIndex(event.target.selectedIndex)
        })
    })
        
    $w("#button1").onClick(()=>{console.log("Button-clicked")
        wixLocation.to($w("#dataset1").getCurrentItem().url)
    })
})

```

Do your button-actions work ?

---

<div class="post-metadata">

**Author:** ![rebecarpop](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/rebecarpop/32/9049_2.png) [@rebecarpop](https://forum.wixstudio.com/u/rebecarpop)\
**Post date:** [February 17, 2021, 2:36pm UTC](https://forum.wixstudio.com/t/database-dropdown-list-with-button/929/6 "2021-02-17T14:36:31Z")

</div>

@russian-dima Thank you! I managed to make it work

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [February 17, 2021, 2:37pm UTC](https://forum.wixstudio.com/t/database-dropdown-list-with-button/929/7 "2021-02-17T14:37:24Z")

</div>

@rebecarpop  
Do not forget to like it, if you really liked it 😉

Good luck and happy coding.