Drawloop - Insert-Update for Child Records

  • 15 February 2022
  • 0 replies
  • 133 views

Userlevel 3
Badge +8

Topic

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

 

Instructions

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.
7860iDB225BB990D3ED3A.png

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.
7861iD6584A5AB5F2D980.png
  1. For each cell where you have set the formula in, give the cell a name
7862i87FFC2D7A0BCC7CF.png
  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>>)
7863i015E7026B085A4D8.png
  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.
7864i5D1C10C733EDB15F.png
  1. Clone the Insert-Update and update the tags up to however many cells you have created in your Excel.

 

 

Additional Information

 


0 replies

Be the first to reply!

Reply