1. 1. Create a relationship to replicate the related list of contacts
      1. Excel Replication Documentation: ClickHere.
      2. Copy Type must be Row.
      3. Tag Document: ClickHere

1. 1. Logic to specify recipients and desired signing order
      1. Name the Cells for the Contact Name & Email on the output sheet.  (These will be used in the recipient configuration)

1. 1. 1. 1. DocuSign_Name_1 & DocuSign_Email_1
         2. DocuSign_Name_2 & DocuSign_Email_2
2. 1. 2. Select any excel logic suited for your use case.
         1. The example below evaluates if the replicated rows are populated or blank from a different input sheet.
            =IF(('Related List Replication'!B2)="","", ('Related List Replication'!B2))
3. 1. 3. Related list Replication is the sheet we replicated the related list data.
          
      4. DocuSignDelivery is the sheet which is specifying the list of recipients to be used for the DocuSign delivery option.

Now the Excel as Middleware document should be configured.

-------------------------------------------------------------------------------------------------------------------
2. DocuSign Recipients Configuration:

1. Create a ‘Document Custom Field’ for the Dynamic Recipients in the DocuSign Admin Account.
   https://support.docusign.com/en/guides/ndse-admin-guide-custom-fields
   1. Field configuration example:
      1. Name = Drawloop dynamic Signhere
      2. Type = Sign Here (this type is signer required)
      3. Tooltip = Please Sign Here
      4. AutoPlace Text = /dl.signhere.{r}/

2. b. This ‘AutoPlace Text’ is what will be replicating in the word template using Word functionality {AutoNUM}.

2. Configure the Recipients on the DocuSign delivery option:

1. 1. Add the maximum number of dynamic signers 1-10].
      1. See section >c] below for configuration.
   2. Add the necessary static recipients

1. 3. Dynamic recipient configuration:
      1. Ensure all ndynamic recipients] do not have any sign options. (The DocuSign - Custom Field ‘AutoPlace Text’ will be placed in the template document and display in the DocuSign signing application.)
      2. The Static Name and Email are from the Excel as middleware template section.

1. 4. Static/Standard recipient configuration:

      1. Recipients that require a specific signing order & recipient number must contain the Sign Option, commonly,  ‘dl.signhere’

      2. This allows Drawloop to control the specific signing order and recipient id when passing to the DocuSign application.

-------------------------------------------------------------------------------------------------------------------

3.Word Template – Signer Block:

1. Document package configuration:
   1. Relationship configuration
      1. Use the same relationship used for Excel Row replication.
      2. Word Replication Documentation: ClickHere
      3. Tag Document: ClickHere

2. Word Template configuration:
3. 1. Create Signing block relationship replication.
      1. Create a 2x2 Table in word
      2. Add the related list replication tags.

1. 1. Dynamic DocuSign signing tag with Word.
      1. Word has formula field codes with an Auto number feature. ClickHere
      2. Add this field code to the end of the DocuSign – Document Custom Field created in section 2.

 

3. Save and upload the documents into your document package.
4. Now the following has been configured:
   1. Excel as Middleware - logic.
   2. DocuSign - Document Custom Field
   3. Word Template - Signer Block

**Run the document package and verify the desired output.**