Drop Down Menus

Question

This is a little complicated to explain.&nbsp; I have a table that lists company information, including contacts.&nbsp; Not all of the locations will have the same kind of contacts.&nbsp; Is there a way to add a multiple choice menu where when you pick the type of contact you want to display, it would then give you the option to fill in the fields for that type of contact?&nbsp; Here's a screenshot of what I am currently working with, but basically we would like to clean this up.
------------------------------Rebecca Moore------------------------------

paulpeterson1 · Answer

You need to set up a Conditional Drop Down.&nbsp;&nbsp;This&nbsp;post does a nice job of explaining the setup.------------------------------Paul Peterson------------------------------

markshnier__you · Answer

Rebecca, a much better design would be to have a child table of contacts and that way you can add as many contacts as you like and identify them by Type of Contact.

But if you did want to stick with your current design, then you will want to use Dynamic Form Rules https://help.quickbase.com/user-assistance/form_rules.html to show or hide certain fields depending on the multi choice field you mentioned.

But when making those rules, be sure to think about them a row at a time.

For example, for the row of fields for Buyer/Purchasing, make a rule to control that row.

Then make a separate row for the "Accounts payable". That way your rules will not conflict with each other.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Forum Discussion

Drop Down Menus

Related Content

Form Edit/Design Menu

Conditional Drop down

Employee Records not appearing in drop down selection menu

Conditional Drop-down

Options in a drop down