Multiple choice input dialog with variables

[RobbieJ]

Hello everybody!

Im wondering is it possible to add variables to my multiple choice input dialog? im guessing it is

This is what kind of data im working with (below)

Also if anyone has a good tip on how to filter the data in my excel table according to the multiple choice, that has been chosen (e.g. 51€-100€) so that it only shows results that are between 51 and 100 euros, either in a dialog box, or so that is removes all results outside the chosen euro range.

any help would be much appreciated!

-Robbie the robot

[seanrockvz13 (Sean Jerome Llanto)]

Hello!

Please check this high level flow. Currently i have hardcoded the options. But what you can do is you can actually pass an array variable there depending on the number of options you have. This way, your solution will not be fixed with the number of options.

For filtering, the “Value entered” field will give you the selection the user selected.
You can then use filter data table accordingly to filter based on the selection.

Hope it helps!

Please mark as solution if it helped you

[RobbieJ]

Perfect this is exactly what i was looking for, thank you very much @seanrockvz13!

[seanrockvz13 (Sean Jerome Llanto)]

All the best! Cheers!