How to pre-fill a document using external IDs

If you are looking for how to pre-fill documents for Bulk Send, see this article instead.

It is possible to pre-fill a SignRequest document with information derived from an external source.  (You may be familiar with the term "mail merge")

In order to do this, you will need to work with "External IDs".  An External ID is a code that you can assign to placeholders (a place where someone needs to add a signature or text) in a document.

For more information on how to create templates, click here.

The External IDs in a document are references to data that exists in another external location (like a spreadsheet, for example).

As you can see in the below screenshot, I have assigned the External ID "contact_1_name" to this text placeholder.

How_to_prefill_a_document.jpg

As an alternative to preparing the placeholders within the SignRequest web platform, it is possible to upload a document with template tags that include External IDs.

This External ID corresponds to a spreadsheet that has the exact same criteria:

(See screenshot below)

Prefill_with_external_ID_s.png

Web-based SignRequest users will need to use Zapier to complete this integration:

Zapier Setup:

For this example, I am using Google Sheets as the source of my data.

1. Choose the two applications you need to connect.

Google_Sheets_x_Signrequest.jpg

2. Choose the spreadsheet from which the data is going to be derived:

Zapier_x_SIgnRequest.jpg

3. Choose your SignRequest account, Team, and Template:

Screen_Shot_2019-09-24_at_5.43.13_PM.png4. Enter the JSON array.  Make sure to parse the field from the spreadsheet as so:

Using_external_ID_s.jpg

4a. For workflows with multiple signers, use the Advanced Signers Configuration:

Prefilling_a_document_with_external_ID_s.jpg

*It is important to note that the signing order settings that you use in Zapier will override the settings of your SignRequest template, so it is important that you set this code properly within Zapier.

 

For Multi-Line Text Fields:

For workflows where you would like to prefill "multi-line" text data using Zapier, you'll need to add some additional code in the 'Advanced Tags Prefill' section within your Zap.

For each line break, you will need to input a ' \n ' at the beginning of each line.

See below:

For example, the code should appear similar to this...Multiline_Text_Zapier.png

So that a text field like this...Multiline_Text_field.png

Will produce text inputs like this...Multiline_text_as_it_appears.png

Contact support@signrequest.com if you have any additional questions.

  

Was this article helpful?
3 out of 4 found this helpful

Comments

0 comments

Please sign in to leave a comment.