Forum Discussion

NathanielHammer's avatar
NathanielHammer
Qrew Cadet
6 years ago

Creating a "Component" of with a varying amount of other components from other Tables and Applications

I have been an App designer on Quick Base for approaching 3 years. My Applications are starting to get bigger and more complex. The newest application I have been tasked with entering and creating is ...
App builders
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Quick Base nicely supports Conditional Drop downs.  So, if you have selected in a field a type of PLC, you can then set the field for the drop down relationship to be conditional

Look for

The values in this field depend on a selection in another field

as a field property for the field [related component] - the reference field in selecting a part.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
NathanielHammer's avatar
NathanielHammer
Qrew Cadet
6 years ago
Below, 
I show the first table which is components and all their relevant information.
The second table is the Control Panel Component Work Order sheet. I tried to configure a conditional drop down for the PLC for example. My multiple choice field then shows nothing in the field to select when I set the [Related Component] Field property up. I need to set y PLC Field in the work order to only look at PLC CPU [Component Type] part numbers. Then I have to turn around and use that same logic PLC Power Supply[component type] etc.  So how do I go about adding a [Component Type] to multiple fields to condition all selections of that component?

Also, I used a drop down in Panel Size to pull all part numbers from the Components list, I basically want to conditon that drop down to just show Panel Enclosures. I hope this can give more information to my problem.




------------------------------
Nathaniel Hammersmith
------------------------------