Help creating a dynamic form

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I want to setup up a form where different data and calculations can occur.

I have a table that defines the packages assigned to each customer, a table that defines the components in each package, and a table with details on each of the components.

I want to collect and store the data on each batch that is calculated based on the package that is selected.  User would select customer and then only the packages assigned to customer would display in the next drop down filtered for that customer.  The Package table lists all the components of the package.  I would want each of the components to display based on the package that is selected by the user.  There would be multiple components for each package.  Data entry and calculations would then occur on  those component records.

How do I connect these all together and create a dynamic form?
Photo of QBuser

QBuser

  • 370 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
You will want to start by setting up the relationships between those tables in the appropriate manner.

Once you have that layout, you can begin to make the summary fields, and calculations you need.

Then you can start working to design your forms and use conditional dropdowns.


Basically this is the meat and potatoes of designing, building and fine tuning an application.

Trying to describe this in a forum setting isn't very feasible .
I'd recommend you look at some of the QB University 
https://university.quickbase.com/

Or working with somebody to help mentor you.