Hi, I have a DropDown Tool with the fields in a Select Tool... And I would like to select the one I choose in The dropDown and unselect de one that is comming for defoult. So I have this workflow In the Drop Down I have set this And The Select is like this I dont find the way to Unselect "Total_moroso" and Select the new choice the users make in de DropDown Tool. I know it is in the Action Tool, but I have troubles by making the Formula to do it. Thanks for your Help

Select and Unselect Items in SELECT Tool

Hi,

I have a DropDown Tool with the fields in a Select Tool... And I would like to select the one I choose in The dropDown and unselect de one that is comming for defoult.

So I have this workflow

Imagen 1.jpg

In the Drop Down I have set this

Imagen 2.jpg

And The Select is like this

Imagen 4.jpg

I dont find the way to Unselect "Total_moroso" and Select the new choice the users make in de DropDown Tool. I know it is in the Action Tool, but I have troubles by making the Formula to do it.

Thanks for your Help

Apps

Preparation

Accepted answers

kane_glendenning

Hi Macabrera,

I quite often have problems trying to de-select fields in the select tool. To do it, you would need an action tool to deselect, and an action tool to select the correct one, however in the example that you have given, you don't need any fields selected at first and therefore you won't have to de-select.

The User always has to select the field that they want even if it is Total, so in the select tool, have none of the fields selected (apart from your Date) and then just have the action tool select the relevant field.

Let me know if this isn't clear.

Kane

HannahSinclair

I agree with Kane that you should start with only the fields that must always be selected checked within the Select tool. Also I am guessing the reason you are using a DropDown tool instead of using a List Box and therefore the "Update Select with multi-Select List Box" option is to limit the user to selecting only one field. In that case there is not a very direct way to do this, but I have attached a module with two possible solutions for you to look at.

The first actually uses the List Box and corresponding Update action, but also includes an Error Message tool which will throw an error if the user selects more than one option.This just requires a long formula for checking all valid combinations of the check boxes within the Error Message tool.

The second option uses the DropDown tool as you have it and then adds an action per DropDown value. In each Action I use the "Update Value with Formula" to check whether the DropDown Selection equals a field and if so then set the Select to True, else set it to False.