Working with other add-ons

In all cases

We strongly recommend leaving the Form Response Sheet unmodified. It should only receive data from the Form.

Make a dynamic copy of the data first.

Make note of these:

  • The name of your Response Sheet. Normally this is "Form Responses 1". We'll refer to it as <<NAME>>
  • The last column of data in your Response Sheet. E.g. "D". We'll refer to it as <<COL>>
  • Create a new Sheet
  • In cell A1, paste this formula, replacing the bold values with your own:

=ARRAYFORMULA('<<NAME>>'!A:<<COL>>)


Now you have a dynamically updating copy of your Form Response data, without touching the source data itself

Autocrat

Make note of these:


Now you can build this formula to match your own Form:

=ARRAY_CONSTRAIN(ARRAYFORMULA(SUBSTITUTE(SUBSTITUTE($<<COL>>$2:<<COL>>,"alt=fullSingle","alt=download")&"&imagePos=0","https://script.google.com/macros/s/AKfycbzPfSdWV_Vdaz8eu9NtRbgGgvUZT23qgS4gqGhVLZ1e2PqhsDc/exec","https://us-central1-signature-ba9e0.cloudfunctions.net/signatureMultiV2ImageServer")),COUNTA($A:$A)-1,1)

Locale note: Formulas use either commas or semicolons depending on your locale. The version with semicolons is below:

=ARRAY_CONSTRAIN(ARRAYFORMULA(SUBSTITUTE(SUBSTITUTE($<<COL>>$2:<<COL>>;"alt=fullSingle";"alt=download")&"&imagePos=0";"https://script.google.com/macros/s/AKfycbzPfSdWV_Vdaz8eu9NtRbgGgvUZT23qgS4gqGhVLZ1e2PqhsDc/exec";"https://us-central1-signature-ba9e0.cloudfunctions.net/signatureMultiV2ImageServer"));COUNTA($A:$A)-1;1)


Paste it in to the first empty column to the right of your data, in row 2

Set row 1 as a unique header - you'll refer to it by this name in Autocrat


The results will be links that start with "https://us-central1 ..." - this is a simple Google Cloud Function that fetches the image data from the Response Sheet and provides it as a standard image format. Nothing is stored.

In Autocrat, this is an Image data type, and will work like any other image link. It is the first signature for the response.


If you're receiving more than one signature per response, you can repeat the formula in subsequent columns and replace:

"&imagePos=0" with "&imagePos=1"

You can continue incrementing that number to match the highest number of signatures per response

formMule

Similar to Autocrat, but wrapped in HTML image tags. This will actually display the signature(s) as in-line images in the email

Make note of these:


Now you can build this formula to match your own Form:

=ARRAY_CONSTRAIN(ARRAYFORMULA("<img src='"&VLOOKUP(MID($<<COL>>2:$<<COL>>,FIND("uuid=",$<<COL>>2:$<<COL>>)+5,36),'Signature <<FormID>>'!A:C,3,FALSE)&"' />"),COUNTA(A:A)-1,1)

Locale note: Formulas use either commas or semicolons depending on your locale. The version with semicolons is below:

=ARRAY_CONSTRAIN(ARRAYFORMULA("<img src='"&VLOOKUP(MID($<<COL>>2:$<<COL>>;FIND("uuid=";$<<COL>>2:$<<COL>>)+5;36);'Signature <<FormID>>'!A:C;3;FALSE)&"' />");COUNTA(A:A)-1;1)


Paste it in to the first empty column to the right of your data, in row 2

Set row 1 as a unique header - you'll refer to it by this name in formMule


This will give you data that starts with "<img src='data:image/jpeg;base64,/9j/4A ... " - this works with formMule!

In formMule, you can lay out this tag on it's own line. It is the first signature for the response.


If you're receiving more than one signature per response, you can repeat the formula in subsequent columns with the following change:

Replace "Signature <<FormID>>'!A:C,3" with "Signature <<FormID>>'!A:D,4" - the letter and number have been incremented upwards. Repeat as necessary!

Document Studio

No integration possible yet - but we have been in contact with the developer and hope to find a solution!