Proxy fields

Question

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...

Goal	options	additional options
Pick a color?	Pink
	Green	Blue
		Purple
		Orange
Pick another color?	Black
	Red	White
		Pink
		Teal

Hopefully this makes sense...

- LB

DonLarson · Accepted Answer

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

DonLarson · Answer

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.

Sign up

Login to the community