Is it possible to link a Select to 2 different collection depending on a variable?

Ask us anything
1

Hi,

I have 2 select boxes on a form - the first one selects between Inbound and Outbound. If Inbound is selected, I would like the 2nd select to get populated from a Suppliers collection and if it is Outbound, I would like to use a Customers Collection.

Is it possible to change the collection depending on what has been chosen in Select #1?

If not, how best can I accomplish this?

Thanks
Steve

2

Hi,

I’m not sure that you can dynamically bound collections in select boxes. You may run into issues with the values you’ve mapped for the select label and value.

One way to approach this would be to have three select boxes, not two – One for each collection. You would then use conditional visibility to show/hide the relevant second select box.

So if the value of select box #1 = Inbound, then display the select box bound to the suppliers collection
And if the value of select box #1 = outbound, then display the select box bound to the Customers collection.

Hope that helps.