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
NathanielHammer's avatar
NathanielHammer
Qrew Cadet
6 years ago
I also mentioned creating a work-order to create such smaller components. The best Example I can give is the same place where I am stuck in my app.

The electrical department builds our Control Panels with a work order.
The work-order tells them the amount and type of components to use. 
- I have a table of all the electrical components, part numbers, price, mfg etc.
- I have another table that allows my electrical supervisor to create a work order. The form leads him to select the different options that a control panel can have and how many of each he wants in it.
Currently these two tables are unrelated. How do I go about getting every component to be related in the work order dependent on the type of component it is? I don't want any 'Ethernet switch' component to show up when I ask him what 'PLC' he wants to use.

I have to do this component selection process for about 35 fields in the form.

------------------------------
Nathaniel Hammersmith
------------------------------
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
    Alright!

    I have almost never used conditional drop downs. Thanks again Mark!

    ------------------------------
    Nathaniel Hammersmith
    ------------------------------
  • 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
    ------------------------------