Showing results for 
Search instead for 
Did you mean: 

Drawloop - Insert-Update for Child Records


In order to do achieve this, it will be using the Excel as Middleware functionality with the Insert-Update.


For this example, we are running from the Account object and updating a checkbox on the Opportunity (child object).
  1. Create an Excel file and tag at least two columns in row two. Have one of the tags be the ID tag. Make sure to have the start tag to replicate the rows as well.
User-added image

2. In another column, create a formula that will bring in the value of the ID. For this example, we are using =IF(B2="", "", B2). Create the formula respective to reach row for how ever many records you potentially think you may have.
User-added image
  1. For each cell where you have set the formula in, give the cell a name
User-added image
  1. Save your Excel file and upload it to the DocGen Package.
  2. Create a new Insert-Update. For the record ID field value pair, insert the name of the cell we have created in step 3 with the bracket around it (ex: <<InsertUpdate1>>)
User-added image
  1. Create a filter criteria so the insert-update will not run if the value is blank. This is so when the insert-update sees a blank value for the cell, the insert-update will not run. Otherwise your DocGen Package will fail to run.
User-added image
  1. Clone the Insert-Update and update the tags up to however many cells you have created in your Excel.


Additional Information

Labels: (2)
Version history
Revision #:
10 of 14
Last update:
Updated by: