Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
29 days ago

Duplicate Record & Add new/different data PIPELINE

parent table - TAKE/OFFs 

child table - TAKE/OFF CALCULATIONS

Take/Offs create record in Take/Off Calculations using a pipeline

Take/Offs  FIELD [PLAN OR OPTION NAME] contains MASTER is the only field "pipelined" into the TAKE/OFF CALCULATIONS table

Now, I need a PIPELINE  to add 5 additional records duplicating same [PLAN OR OPTION NAME]......New records will then contain selections from multiple choice field [CALCULATION TYPE]

In summary, starts with this record:

TEST.PLAN.MASTER - no data in CALCULATION TYPE field

Need:

TEST.PLAN.MASTER with selection from Calculation Type field - WALLS.INTERIOR and

TEST.PLAN.MASTER with selection from Calculation Type field - CEILING.INTERIOR and

TEST.PLAN.MASTER with selection from Calculation Type field - WALLS EXTERIOR and

ETC

thank you

 

 

 

  • DonLarson's avatar
    DonLarson
    Qrew Commander

    A Pipeline can create those records with six steps

    Triggering event on the Parent Table

    Five Create Records

    Assuming you want this to happen with the creation of the Take Off record, that would be Step A

    Steps B, C, D, E, and F  are Create Records where you specify the Parent Record and the value in the field of the Child.

    Did you build the first Pipeline?   Depending on your business rules it may just make sense to expand that one to include the new functionality.