Drop down prompt per row of data

[Rdscutters]

Hi, i have a simple text input of 3 columns and multiple rows, first column is the store number, second column contains sales data and the third column is called “override” and this override column is blank to begin with. What i need is to pass this data to a macro and have the macro prompt the user with a yes/no dropdown option for every single row. Eg it asks me yes/no for row 1, then row 2 etc. The macro will then enter the users selection into the override column so that the out put of the macro would be something like Row 1=yes, row 2= No, row 3 = yes etc. Is this achievable if so can anyone offer any guidance?

Example data before entering macro;

Store	sales value	Override
A	1000	null
B	2000	null
C	3000	null

example data after entering macro

Store	sales value	override
A	1000	Yes
B	2000	No
C	3000	Yes

[cycyg]

Hey @Rdscutters,

 Did you manage to solve this? I have the same "use case"

[OllieClarke]

@Rdscutters @cycyg 

I'm afraid this isn't possible with the dropdown interface tool - Unless you know exactly how many rows there will be, and that number will never change. Even then it would be a pain to set up.

In the usecase above, it's probably easier to have a multi-line text input so users can type in their desired value 1 per line, and then in the macro you can join that in based on record position.

Hope that helps,

Ollie

[cycyg]

Hi @OllieClarke ,

Thank you for your reply. I already managed to do that with the text tool as per my comments in this thread: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-Drop-Down-tool-to-manually-input...

I was trying to see if there was any other solution on community but failed to do so😢.

Thank you anyways for your help!