Skip to main content
Question

Generating a template using the inputs given in a form by individual

  • September 13, 2021
  • 0 replies
  • 33 views

Hi guys,

I am looking to setup a process in QB to generate BOM's depending on the selections made in the form by each user. The user should enter their choices from the dropdown list and from the choices QB should generate a report with the info. Is there a way to create this process? Any suggestions will be helpful.

Thanks,

Ravi J



------------------------------
ravi kiran jaladi
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • September 13, 2021
no problem.

Create a table of Products and set up a Child table to hold the Child BOM Master Items and populate with the correct BOM Items for each Product.  I cannot tell from your post whether the current drop-down list for the products is a multiple choice filled or taken from a relationship but you will need to have those choices come from the relationship.

Then set up an automation to run that when a new "Product Order" is created to copy the BOM Master Items from the Child BOM Master to become Product Order BOMs.  He'll be able to filter the automation so that only the correct children will be copied across where the Product in the Child BOM Master matches the Product selected on the "Product Order".

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement