Forum Discussion

ravi_kiranjalad's avatar
ravi_kiranjalad
Qrew Member
4 years ago

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

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
------------------------------
Pipelines
Quickbase Automations
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    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
    ------------------------------
    • ravi_kiranjalad's avatar
      ravi_kiranjalad
      Qrew Member
      4 years ago
      Hi Mark,

      Thank you very much. Could we achieve this using the pipelines to generate template with data from the inputs entered as per each user.

      Thanks,
      Ravi J

      ------------------------------
      ravi kiran jaladi
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        If you are asking if what can be done with Automations can also be done with Pipelines, then answer in general is yes.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------