ContributionsMost RecentMost LikesSolutionsRe: Creating a "Component" of with a varying amount of other components from other Tables and Applications 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 ------------------------------ Re: Creating a "Component" of with a varying amount of other components from other Tables and ApplicationsAlright! I have almost never used conditional drop downs. Thanks again Mark! ------------------------------ Nathaniel Hammersmith ------------------------------ Re: Creating a "Component" of with a varying amount of other components from other Tables and ApplicationsI 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 ------------------------------ Re: Creating a "Component" of with a varying amount of other components from other Tables and ApplicationsThat's ultimately what they want to get out of the application. We know the labor side(thanks to the first app) and a round-about number of the material side due to varying nature of every machine. It takes a lot of man-hours to count the components on a machine (purchased or built in-house). I forgot the mention cost: TJ wants to reflect varying costs changes in purchased components into the overall cost of the machine. Thank you for the tip! ------------------------------ Nathaniel Hammersmith ------------------------------ Creating a "Component" of with a varying amount of other components from other Tables and ApplicationsI 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 something along the following lines: -Be able to create an inventory list for departments utilizing vendors, mfgs. price. min order qty. etc -Be able to create a department work order (or Component I would call it) out of the above 'purchased inventory list'. -Track the hours it took to create that component with the employee(s) that worked on it (I already do this a lot). -Be able to create a larger "component" comprised of other components (purchased or made here in-house by different departments ie the one listed above) into a Larger List of components. All of which will eventually have a home on a machine we build and be inventoried to that machine along with its hours it took to get it to Finish Goods ( Again, I already have an application tracking all hours by every department down to the employee hour level. So, I just need to add an inventory list to that machine....eventually). Lay of the Land for my application is this: Main Application Tracks: Employees, Departments, Customers, Customer jobs, Customer job work orders, Job Hours, Work Order Hours, Employee Work order hours My Other Two Applications are almost identical. They Track the in-house side of departmental work. I have electrical and I have tooling. Tooling: Creates Stock Components, Creates Work Orders to Make stock components then tracks time for employees Electrical is where I am starting the above venture due to the nature of the department. They have to use both purchased and in-house components of varying quantites to create a larger component in an almost endless combination(currently the field count is in the upper 70s). I want to track that combination as a work order and relate every component they use to either tooling or a purchased component. Once I figure out how to create components from other components and then into even larger more complex components I will track the hours it took to get there. I am asking the community for some help in arranging my next application. Mostly, how would you go about creating larger components from a multitude of smaller components from different departments and purchased components. Do you think the data will be usable when one record is just a non-stop combinational nightmare of components? If you are curious what my company does, we are a tier 3 automotive supplier that works to create production machines. Our work can be seen on companies like Honda, Tesla, Ford, GM, FCA, Nissan, the list goes on. Thank you for any repsponse in advance! ------------------------------ Nathaniel Hammersmith ------------------------------Re: How to set up a child record to automatically select its parent?As a side note, I like to keep a sandbox of my application to do such things as change key fields without actually affecting integral data. To do so, Go to your apps home page>settings>App Management>copy App>Select Copy App with data> the Press Copy App. You then have a play area to experiment in. I am attempting to do something that is the same as you in nature. I will let you know if mine works and how I did it. Good Luck! ------------------------------ nathaniel hammersmith ------------------------------ Re: I need a report to summarize a totals columnsOne last Question, is a form rule more efficient than an automation in terms of performance. It seems that I can copy the formula field to text field via automation when record is created or modified or via a dynamic form rule. Which is better developing applications?Re: I need a report to summarize a totals columnsAlright I will get this underway. Thank you for all your help!Re: I need a report to summarize a totals columnsPlan B makes sense. If I don't want to take the performance hit; even though on my apps scale it would be minimal, how would I accomplish plan A? Everything from Emp name, date complete, job, work order, is a lookup field aside from actual hours and the Quickbase fields. Using record ID somehow might work.Re: I need a report to summarize a totals columnsPlan B makes sense. If I don't want to take the performance hit; even though on my apps scale it would be minimal, how would I accomplish plan A? Everything from Emp name, date complete, job, work order, is a lookup field aside from actual hours and the Quickbase fields. Using record ID somehow might work.