Home File Templates

File Templates

Learn how to create and use Vsimple File Templates! File Templates allow you to automatically generate pre-filled word and excel documents. You also can use File Templates to pre-fill a pdf for Vsignature.
Henry Lynch
By Henry Lynch
4 articles

Creating an Excel File Template

1. Open any Excel document, it can be blank or a document you've use previously. 2. Add a page to your Excel and name it (suggestion: "Vsimple Mapping") 3. On your Vsimple workflow, click Admin then File Templates 4. On the top right corner of this page, click View Document Keyspaces 5. In this pop-up window, click the icon to the very left of the field you'd like mapped onto your Excel document. This icon "copies" the keyspace code. 6. In your Excel document, "paste" the keyspace onto the newly created page. 7. Once you've added the fields applicable to your document, click on the main page of your Excel and type the "equals" key into the cell, then on your "Vsimple Mapping" page, highlight the cell that this is related to and hit "Enter" on your keyboard. Repeat until all the fields are accounted for. 8. To add a table, you only need to add a single row of keyspaces. The additional rows from Vsimple will automatically map in the fields below. 9. Add any formulas necessary at this point! 10. When you're ready, right click on the "Vsimple Mapping" page's tab and select "hide." 11. Save the Excel and in the Vsimple File Template's page, click "New File Template" and choose the document created. 12. To generate or test the file you've created, head to an individual record and under your name in the top right, click Actions then click the name of the file you've just added. This file will generate into your downloads folder.

Last updated on Dec 20, 2023

Creating a Vsignature File Template

Vsignature file templates pre-fill a contract with Vsimple record information and explicitly define where a signer should add information like: - Signature (required at least once) - Signer Name or Company Name - Signer Job Title, Phone Number, Email, or Address - Checkboxes (A user chooses to check or uncheck a single box) - Radio Buttons (A user chooses to check one option out of many) - Custom Text Fields To learn how to pre-fill Vsimple record information, check out this help article about Word File Templates. Vsignature Keyspaces work similarly. Copy the Keyspace onto the page where you would like a signer to add particular information. However, there are a few differences: 1. For Custom Text Fields, the copied value is "${vsign.custom-*}", you must replace the * with the field label that you would like to appear for the signer. For example, "${vsign.custom-Preferred Contact Method}" 2. For Radio Buttons, the copied value is "${vsign.radio-*}", use numbers to flag groups of radio buttons. For example, if radio button ${vsign.radio-1} is used in three places, a user will be required to select one of those three options: Would appear like this to a signer: 3. By default, Vsignature Keyspaces are required. To make them optional, add ":optional" to the keyspace like this: "${vsign.custom-6:optional}" 4. By default, Vsignature Keyspaces are assigned to the 1st Signer, add ":sig_2" to the keyspace like this "${vsign.signature:sig_2}" to assign to a 2nd signer (the same format works for up to 5 signers by using sig_3, sig_4, and sig_5.

Last updated on Mar 01, 2024