Create PDF Copies of Completed Forms

Open your project in Form Studio, if not already open.

If you want to record completed forms by producing a pdf copy of the completed form, you will need to provide a means for the form to be submitted. You can create the PDF template before you do this, although we suggest you do it afterwards.

The simplest way to allow users to submit your form, is to add a Submit Button Element to the form. The user will click or tap this button to submit their form, once completed.

Other ways you can submit the form include using the Submit form action in an Event or using the submitForm scripting function in a custom JavaScript.

If you intend to use the Capita Pay360 payment service to take payment for goods or services, you can submit the form as part of the payment process, rather than use a Submit button. In this case, you will need to add a Capita Pay360 Cart Element to the form and configure the Element to submit the form.

Once you have added a means to submit your form, click on the Project tab in the Project Explorer.

Expand the Forms node in the project tree view.

Right-click on the form name.

Choose Generate Word template.

The Studio will generate a Microsoft Word template including all Elements on your form which have an output mapping and some other Elements such as titles, labels and images. Before you generate the template, make sure you have output mapped all the Elements on the form whose values you want to include in your PDF file.

When Word generation completes, the template is written to a temporary file and a temporary file dialog box is displayed:

To check the temporary file, click the View Template button. This isn't a prerequisite and you can, if you wish, save or reject the template without examining it first. Note that Digitise Forms will attempt to load the template in MS Word. If you don't have Word, it will attempt to load the template in the default program associated with the .dotx file extension. If you don't have an association configured, a message will be displayed informing you that Form Studio cannot display the template.

Once the temporary file has opened in Word (or in the default, associated program), it can be edited in the usual way. Elements can be added or removed, and changes to the wording of static text items (e.g., element Labels, Label and Paragraph elements, recordset column header Display text etc.) can be applied.

If you view the temporary file and decide not to keep it, close Word. Select the dialog box's Reject Template option, then click OK. The template will be discarded and any existing template will be retained. You can also discard a template by clicking the Cancel button, or by clicking the cross in the dialog box's upper, right-hand corner.

If you view and edit the template and want to keep your changes, save the template in Word then exit the application. Note that you won't need to choose a file name or enter a file location when saving the template in Word. The location and file name are specified when you select the Save Template option. Select Save Template, then click OK. The temporary file will be saved and changes made to it will be retained. Any existing template will be overwritten.

If you view the temporary file and decide not to make changes but still wish to keep it, exit Word. Select the Save Template option, then click OK. The temporary file will be saved using the untouched, auto-generated content and any existing template will be overwritten.

When you select Save Template, a second dialog box showing the save location will appear:

By default, the following information will appear in the Save location box (which shows C:\Users in the above image)

C:\Users\<username>\Documents\NDL Software\Form Studio\Projects\<project name>\

WordTemplates\<form name>.dotx

If you select the Save without editing template option then click Finish, the template will be saved in the above location. If, however, you select Open template for editing then click Finish, the template will still be saved in the above location, but it will open in Word, where you can make and save changes as described above. Click Cancel to abandon the template-saving process, or click the cross in the dialog box's upper, right-hand corner.

As well as being able to generate a Word template by expanding the Forms node in the project tree view and right-clicking on the form name, you can also update the Word template or preview the generated PDF. When you right-click on the form name and select Update Word template, you will be presented with the same dialog box which appears when Generate Word template is selected. When you right-click on the form name and select Preview PDF generation, a PDF will open which contains all of the elements which have been flagged for visibility within the PDF along with accompanying Labels and any static text etc.

You can also preview, edit and generate the PDF using the options provided on the Ribbon's Data tab:

The drop-down above the Preview, Edit and Generate buttons allows you to select the form that you wish to generate a PDF for. When you select Preview, the PDF will open. When you select either Edit or Generate, you will be presented with the same dialog box which appears when Generate Word template is selected.

If you view the temporary file before generating the PDF, it is worth noting that labels are bookmarked to enable updating. The tables in which bookmarks are placed may be restructured if new elements are added, or if their visibility within the PDF is switched on. In these instances, the template may offer a less accurate representation of the eventual PDF. Also, if elements are re-ordered in the form, the updated Word template may not capture the revised order correctly. We therefore recommend previewing the PDF where items have been re-ordered, or where significant changes have been made.

To obtain a preview of your PDF, you will need to have created a Publishing Profile first (see the Publishing Profiles section of the Publish your Form topic). You won't need to publish the project in order to obtain a PDF preview, but the preview requires a Publishing Profile to be present which contains Configuration and Logging database connection strings.

If you have applied HTML/CSS styling to an element using the inline editor, or if an input-mapped database field contains HTML markup, the styling or formatting defined by the markup will be implemented in the PDF. If the markup does not explicitly define the font name, the PDF will use the font defined by the current paragraph. Note that to check any styling applied to an element, you will need to preview the PDF preview. The generated Word template will not display any styling and will show placeholders only for items added to your form. See the Styles and Map Data to Elements topics for more information.

By default, your PDF files will be called:

<form name>_nnn.pdf

where nnn is the record ID in the submission database table record for the submitted form. The record ID links the PDF file to an individual copy of the form so that users can only access the PDF files they have created.

If you want to use the default name for your PDFs, you don't need to do anything. However, you should make sure you give each form a unique name so that you can identify the PDF files generated by different forms and to ensure that files from one form won't overwrite files from a different form with the same name, if you use the same folder to store PDF files from different forms.

Alternatively you can specify your own file name for your PDFs, if you prefer, and you can even include values entered by a user on the form within the file name to help identify individual PDFs.

When you generate the Word template, as described above under Generate a PDF template, Form Studio will automatically add a function, called getPDFFilename, into the custom JavaScript for the form, which defines the file name to be used for PDFs.

To change the file name, you need to edit the default function to specify your own choice of name. To do this:

Click on the Projects tab in the Project Explorer.

Under the Forms node, find the relevant form and expand that node to see its Script node, if not already visible.

Click on the Scripts node.

The custom JavaScript file will open in an editor.

Scroll down the file to find the getPDFFilename function. The default function will look like this:

 

function getPDFFilename(recordID)

{

// Hint: You can specify a unique file name for the PDF using values from the various elements used on the form.

// e.g.

// var pdfFileName = form1.page1.ndltextbox1.value;

// Make sure to create unique pdf names. Otherwise, there is a risk of the files getting overwritten.

// If the file name contains invalid characters like '"', '/', '\', ':', '*', '?', '>', '<' or '|', the invalid characters will be replaced with '_' .

// If the file name is longer than the default length(260 characters), the file name will be changed to the default format (formname_recordID).

var pdfFileName = 'Form1_' + recordID;

return pdfFileName;

}

 

You can now edit the function and replace the default file name, 'Form1_' + recordID, with your own choice of file name. If you want to include data values within the file name, you can reference these in the same way as you would anywhere else in the Script file. For example, you could combine the values input into two of the form fields like this:

var pdfFileName = form1.page1.txtSurname.value + "_" + form1.page2.txtpnlReason.value + "_" + recordID;

When deciding on your file names, you need to ensure that each generated PDF will have a unique file name, to prevent one user viewing a file created by another, if you include a Get PDF Button on your form, and to prevent a file being overwritten by another file with the same file name.

At runtime, if a file name is generated which includes characters that are not allowed within file names, such as '*' or '\', these characters will automatically be replaced with underscore characters, '_'. In this situation, a message will be added to the Server Log to warn you. If the file name generated is invalid, e.g. an empty name, or is greater than 260 characters in length, the default file name, described above, will be used instead.

When you are ready to publish your form, select your Publishing Profile.

To specify that a PDF copy of the form should be automatically created whenever the user submits the form, select the Create PDF on submit option within the Profile's settings.

If you are including PDF file creation in your form, either automatic (using the Create PDF on submit option just mentioned) or allowing a user to manually request a PDF copy (using the Get PDF Button Element), you will need to specify the folder to which you want the PDF files to be saved. This is also done within the Publishing Profile, in the PDF Folder option.

 

In earlier versions of Digitise Forms, only output-mapped elements were visible within PDFs, along with static items such as titles, labels and images etc. Now, input-mapped values are automatically included in the PDF when the PDF template is generated (described above). The visibility of input-mapped and other items within the PDF is, however, subject to the Is Visible in PDF option being selected for each form element. The Store Request Data item also needs to be selected for configured Datasources within your form's Publishing Profile. For more information, see the Publish Your Form and Map Data to Elements topics.

 

If you have a droplist or a checklist where the label and value properties of the list are mapped to different dataset fields and the value is output-mapped, the PDF will now automatically show the value of the selected label property, even though the value recorded in the database record is that of the selected value property.

In the following example, using a lookup for personal titles, the droplist and checklist are mapped to a record where the dataset field mapped to the value property is an integer and the dataset field mapped to the label property is a string containing the string value associated with it. The string value is displayed in the PDF:

 

You can include the Primary Key of the main record created by the form in your PDF by input-mapping it to an element such as the Label element. The Label element allows non-editable text to be displayed on your form, so when the Primary Key is included on your form using this element, you won't be able to amend it.

For more information on working with a form's Primary Key, see the How do I access the last submitted record's unique ID? question in this guide's FAQs section.