Make Combo box visible if multiple selections are made in another combo box

(0) Share

Report

Posted on by LS579

130

Hello,

I am having trouble getting a combo box to show if "Other" is selected as well as "Other" and other selections in another combo box.

The functionality of this form is to select an office location that you would like the employee to work from. There are 11 main locations that should be considered first and then an "Other" option if you would like to get approval for any of the other office locations. Right now, I have "comboboxOther" showing if just "Other" is selected from "comboboxLocations", but I need "comboboxOther" to show if "Other" and any of the other locations are selected.

Please see photos. Screenshot 2024-02-26 120829.png Screenshot 2024-02-26 121015.png Screenshot 2024-02-26 121120.png

Categories:

General Questions

All responses (4)

Answers (1)

LS579 130 on at

Like (0)

Report

Re: Make Combo box visible if multiple selections are made in another combo box

That worked! I did have to change the "> 1" to ">= 1" because it wasn't showing when just "Other" was selected, but now it works perfectly! Thank you so much for your help!
Verified answer

LaurensM 12,510 Super User 2025 Season 1 on at

Like (1)

Report
Re: Make Combo box visible if multiple selections are made in another combo box

@LS579,

Thanks for the info! 😊

Your current code will not work as expected when allowing multiple selections. '.Selected.Value' is used to access the selection of a single-select combobox. Using this approach with a multi-select combobox will result in only the last selected value being evaluated.

Could you try the following code:

//Returns true of Other is selected & at least 1 additional selection has been made "Other" in cboLocations.SelectedItems.Value && CountRows(cboLocations.SelectedItems) > 1

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!
LS579 130 on at

Like (0)

Report
Re: Make Combo box visible if multiple selections are made in another combo box

Actually, my Visible property is set to:
If(cboLocations.Selected.Value = "Other", true, false)
Would your code above work the same with this? Or should I change it to what you have exactly?
LaurensM 12,510 Super User 2025 Season 1 on at

Like (0)

Report
Re: Make Combo box visible if multiple selections are made in another combo box

Hi @LS579,

I assume that your current Visible property is most likely similar to:

//Change .Value if needed "Other" in comboboxLocations.SelectedItems.Value

In addition to this logic, we will have to check whether at least 2 selections have been made and Other is one of those:

//Change .Value if needed "Other" in comboboxLocations.SelectedItems.Value && CountRows(comboboxLocations.SelectedItems) > 1

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!