Conditionally filtering options from Radio control

(1) Share

Report

Posted on by ShanePhillips

Hello all, I swear I posted this yesterday morning but do not see my post in the forum or in "My Activity".

I'd like to conditionally filter options from a radio button. The set up is that I have a primary radio selection, and based on the option selected in radio1, radio2's options are filtered by if there are any of those options still available.

If the specific combination of Radio1's option and Radio2's option are out of stock, then filter that radio (or grey out) that Radio2 option as being available.

That condition will apply to each Radio2 option for each Radio1 option selected. I can do this with an If statement one at a time, but haven't figured out how to do it across multiple options.

Is this possible? This is for a sign up sheet but it's basically a order picker. I can't find my answer but I may not be using the correct keywords in my searching.

Categories:

Using Apps Using Formulas

All responses (8)

Answers (0)

ShanePhillips 70 on at

Like (0)

Report

Conditionally filtering options from Radio control

Yes I have worked through many of them. They don't necessarily teach the best way to set up a model from scratch if you've never done it before, though I'll dig back through them.
Suggested answer

ronaldwalcott 3,820 on at

Like (0)

Report

Conditionally filtering options from Radio control

Have you been though the learn modules yet? If you face a problem then you can ask it here but I don't believe that anyone will have the time to walk through the entire solution design and how to program it.

Please like the replies if they were of any help. Thanks.
ShanePhillips 70 on at

Like (0)

Report

Conditionally filtering options from Radio control

I've started working on it but am still very much learning and cannot say I have a model in place. Thank you for taking the time to help me learn.

You have the workflow correct. To add to that, if I'm all out of sizes then that tshirt color is removed from the first radio control.
ronaldwalcott 3,820 on at

Like (0)

Report
Conditionally filtering options from Radio control

I don't know your complete design so I am only proposing a possible solution.

You said that you wanted two radio controls. The options in a radio control are normally unique hence using two collections.

I am presuming that your workflow is

Select a colored t-shirt from the radio button (your first radio button can therefore use a collection containing the types of t-shirt colours)

When the t-shirt is chosen you can check your inventory and select the sizes that have stock and add those sizes to the collection used by the size radio control

You now know the type of shirt and the size chosen by the user

Have you started working on a solution or are you in the concept phase?
ShanePhillips 70 on at

Like (0)

Report

Conditionally filtering options from Radio control

Can you explain to me the benefits of two collection tables, and are you recommending two source tables? Why not one table? I've looked into collections and am learning, but I don't understand yet how this helps solve. Thanks in advance.
ronaldwalcott 3,820 on at

Like (0)

Report

Conditionally filtering options from Radio control

One way is you would have a table with the t-shirts then another table linked to it with the sizes and quantity available.

Create a collection for the radio button based on the t-shirts.

Create a collection for the second radio button based on the availability of the size.
ShanePhillips 70 on at

Like (0)

Report

Conditionally filtering options from Radio control

Hi Ronald, thanks for responding. This is actually part of that signup sheet question I'd posted recently that you responded to as well.

Option 1 radio control could be set to Item in the below table.

Option 2 radio control could be set to Size.

If user selects Red Tshirt and there are no more smalls available, small is removed from the option 2 radio control because it's out of stock.

Honestly I'm not sure what the best option for setting up the data source would be either. I could make a table of each line item, and do a count and remove options via an IF statement, or I patch in user names into a column and I have a row for each option combo and only display blank options in the control.
ronaldwalcott 3,820 on at

Like (0)

Report

Conditionally filtering options from Radio control

The Radio options are provided by a list or other source of data. What is the If statement you are using and what do mean by doing it across multiple options?

If I select option A in Radio1 then can't you adjust the values in Radio2? I think it could be done by storing the radio items in a collection with a column indicating which options are active based on the option chosen in Radio1.

I may be misunderstanding your requirements.