Forum Discussion

KarenHenke's avatar
Qrew Cadet
2 years ago

Conditional multi-select field based on values in another multi-select field?

Hi - I've searched but can't find a similar use case to mine....

I have a multi-select text field where users can choose all of the products related to the content they are submitting.

When we promote the content, we can only show 5 products max. So I need the user to tell me which 5 products to show.

Right now, I have two fields: [Products All] and [Products to Promote]
The response options in both fields are identical.

The user selects up to 20 in the [Products All] field then selects the 5 they want to promote in the [Products to Promote]

You would be amazed at how many people choose [Products to Promote] which they did not choose in [Products All]

Is there a way to make the response options in the [Products to Promote] field mirror what the user has chosen in the [Products All] field (so they can choose their 5 products from this filtered list)?

Karen Henke

2 Replies

  • Hello, I think this guy is better at controlling relationships.

    Have a table with the products you selected and only from that table can you select the products to promote.

    Marcelo Benavides Torres

  • It would be possible to come up with a formula for a warning message to tell the user that they have selected invalid choice(s) to promote.

    Mark Shnier (Your Quickbase Coach)