Making an app with a dropdown - running into a problem

I am trying to make an app where I want a dropdown menu connected to a select tool so that the user can choose which column, in this case the month. I have made an example app attached.

No matter which month I choose on the dropdown it always gives me July, which I don't really understand. I also want the first field to always be there and not on the dropdown. Any advice? Thanks

test dropdown salesperson.yxwz

Apps

Accepted answers

mceleavey

@BillyL14 ,

no problem at all.

I've built that for you now using the Dynamic Select tool and updating the value with from the action.:

test dropdown salesperson.yxwz

All comments

mceleavey

Hi @BillyL14 ,

can you please provide the data so we can run this?

Mock data is fine

mceleavey

@BillyL14 ,

I've mocked the build that you need to do to populate the dropdown.

As you can see, you need to populate the dropdown tool with the column headers, not the column values:

I hope this helps,

test dropdown salesperson.yxwz

BillyL14

@mceleavey thanks a lot, I tried your solution out and I still got the July value whichever I chose, not sure why?

Have attached my sample data

dropdown test.xlsx

mceleavey

Hi @BillyL14 ,

You haven't connected your action tool to the correct tool, and your data might not be in the right format.

Can you package your data (options, export workflow) and send it to me so I can build it for you.

You need to have a filter after your data input and connect the action tool to this. In the filter, select Month = X. In the action tool, set it to overwrite the value X

I can build it if you send the data.

BillyL14

Hi @mceleavey, thanks a lot, I know I must be doing something wrong, have attached, thanks again

Exported workflow.yxzp

mceleavey

@BillyL14 ,

no problem at all.

I've built that for you now using the Dynamic Select tool and updating the value with from the action.:

test dropdown salesperson.yxwz

BillyL14

@mceleavey thanks, I'm trying it out

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335