Forum Discussion

LB's avatar
LB
Qrew Cadet
7 days ago
Solved

Proxy fields

Is it possible to have fields built in a table be used as individual options based off selections in another table?

For example - would it be possible to have a table that houses the item and options and additional options based on the option selected and then relate this  have this table relate to another table to display and allow the user to select only certain options and additional options?

I've tried to visualize this in a spreadsheet...in the example below if the user selects pink from the options in the proxy field it won't provide any additional options, however if they select green then they will be able to select additional options and so on...

Goaloptionsadditional options
Pick a color?Pink 
 GreenBlue
  Purple
  Orange
Pick another color?Black 
 RedWhite
  Pink
  Teal

Hopefully this makes sense...

- LB

  • Absolutely.

    There is a feature called a Conditional Drop Down.   Here is a link that explains it in more detail.

    https://helpv2.quickbase.com/hc/en-us/articles/4570407379604-How-to-add-Cascading-Dropdowns?_gl=1%2A95t3eh%2A_ga%2AMTMyMDQzNDY2LjE3NDIwNzA1Mjc.%2A_ga_YZ6780317K%2AMTc0MjU3MzM3Mi4xMy4xLjE3NDI1NzM0NzMuMjkuMC4w

     

  • Absolutely.

    There is a feature called a Conditional Drop Down.   Here is a link that explains it in more detail.

    https://helpv2.quickbase.com/hc/en-us/articles/4570407379604-How-to-add-Cascading-Dropdowns?_gl=1%2A95t3eh%2A_ga%2AMTMyMDQzNDY2LjE3NDIwNzA1Mjc.%2A_ga_YZ6780317K%2AMTc0MjU3MzM3Mi4xMy4xLjE3NDI1NzM0NzMuMjkuMC4w

     

  • One more thing.  I suggest you spin up a new application and build the example in the article.   It will help you alot to do that one and then apply the lessons learned to your real application.