Live Forms Latest - This documentation is for Live Forms 9.0. Not for you? Earlier documentation is available too.

Skip to end of metadata
Go to start of metadata

Wizards make it easier to configure what happens to the data when a user submits your form and what the users see after submitting the form. The wizards are accessible from the form/flow designer toolbars via the Edit Forms/Flows properties icons. Specify Form Actions (what the user sees) and Document Actions (what happens to my data) on the associated tabs in these wizards. The action settings are summarized in the form/flow properties Form Info tab.



An email notification is sent to all tenant administrators or the flow administrator(s) (if configured) when a Form Action post, DOC URI or DOC Action fails and the submission does not reach it's intended destination. When the form/flow is submitted, the user sees the message "Thank You! Your submission has been received." and then the appropriate admin is notified via email. The email is sent when the following Form/Doc actions are configured in a form/flow:

This is not applicable to the email doc action since it is asynchronous and the notification would fail if the service were unavailable. Refer to each topic for more information.

Doc action wizards are single select. If you set up one of the wizards then configure an action using a second wizard, the information configured on the first wizard will no longer display. This is as designed.

Let's say you want to send an email after your form/flow is submitted but you are also using the Filesystem connector to save your submissions to a directory on a local server. You configure the Filesystem connector wizard to do this. Then your configure the Email data to a specified address wizard to send the email. If you return to the Filesystem connector wizard, after configuring the email wizard, the information that you entered on the Filesystem connector screens will no longer display. In this situation, you can use the email wizard on the Additional Email tab to configure your email. Refer to How to setup Multiple Document Actions for an example.

Form Actions

The Form/Flow Action wizards help set up what the user sees when the form/flow is submitted.

You can access the Form/Flow Action tabs in three ways:

  • Click the  Edit Form/Flow Properties icon on the Forms/Flow Designer toolbar. This will launch the Forms/Flows Properties wizard. Click the Form/Flow Actions tab.
  • Click anywhere in the Form/Flow Actions section in the Properties Navigator. This takes you directly to the Form/Flow Actions tab.
  • Click the inside the Form/Flow Actions section in the Properties Navigator. This takes you directly to the Form/Flow Actions tab.

The wizards help guide you through the configuration process. Many of the wizards allow you to use form controls as templates to dynamically create what the users sees rather than hard coding this. See the section on using templates in form/doc/error actions for full details. Hover over any field in the wizards for a helpful hint.

You can only configure one Form action for a form/flow. This is as designed.

On this page:

Success

The Form Actions available on the Success tab are:

  • Display Message when User Submits Form

  • Forward Users to a web page of your choice

  • Post Data and forward users to your web page

  • Forward to Paypal to complete payment


Display Message when User Submits Form

After the user submits the form/flow, the browser will display a standard Live Forms page with a text message. For example, the message might say, “Thank you for completing our form.” You supply the specific text in the Message field. This option works best for relatively brief messages. It can be tricky to enter or edit large amounts of text in the wizard's Message field, so for verbose messages consider creating a simple HTML page for your message and choosing the Forward User to your Web Page wizard.

The message can be customized, using the wizard's control dropdown, with values the user enters into the form. For example if your form contains a fields named firstName and lastName, you can set your message to "Thank you {firstName} {lastName}". Now when a user submits the form the controls templates {firstName} and {lastName} will automatically be replaced with field values "Thank you Joe Smith". See using templates in form/doc/error actions for full details.

Another useful message is to display a link back to the form. For example the display message:

The display message would be written as follows. The URL back to the form is the share dialog Raw Form link.

The form/flow URL in the above HTML example can be constructed dynamically in a business rule. See this rule example.

Javascript is not allowed in the display message. Plain text, html and control templates are allowed. Anything else will break the message and nothing will be displayed.

Show In

Both the display message wizard and the forward to web page wizard allow you to select where the message is displayed on the page using the "Show In" dropdown. There are three choices: Frame, Parent and Top. This tells the browser where to show the text (if you chose Display Message) or the new Web page (if you chose the Forward to Web Page).

  • Frame means inside the form's iframe
  • Parent means inside the form iframe’s immediate parent
  • Top means at the top of the page, regardless of how many parents are outside the iframe.

Forward Users to a web page of your choice

After the user submits the form/flow, the browser will be redirected to another URL, which you supply in the  URL field. You must include the http:// prefix (e.g., http://myhost.com/thankyou.html). The application can have a Form Action Base URL which you set in the application properties. For example, you can have http://myhost.com/ in the application  baseURL and simply “thankyou.html” in the Form Action URL field.

You can use a form/flow field template in the URL field. Ex: http://localhost:8082/URL!encode=false}. The encode=false template parameter is important to avoid mangling the URL. See Templatized String Parameters for details.

Show In

These are the same options as described under the display message wizard above. Unless you have created a special page that you know will fit correctly within the form’s iframe you should not choose iframe. Choose the Parent or Top option instead.

 

Forwarding users to a web page that is located in a different domain will not work.

Post Data and forward users to your web page

After the user submits the form, the browser will POST the user’s data to the URL you specify in the wizard’s URL field and display whatever is returned—the next page to display.

Fill in the Post Submission to your Application wizard with the following information:

  • Enter the URL to the application where you want to post data:
    • Your URL field must include the http:// prefix (e.g., http://myhost.com/services/processPayment). The application can have a Form Action Base URL which you set in the application properties. For example, you can have http://myhost.com/services/ in the application baseURL and simply “processPayment” in the Form Action URL field.
    • The URL can also include control templates. This can be useful when you wish to specify a production versus a test server. For example: http://{serverURL}/services/processPayment/{customerId}. Using this form URL, you can specify serverURL using &_data=(serverURL:'testhost'). This makes switching from a test server to a production server a matter of setting the form URL parameter "serverURL" rather than editing the form itself. See Initializing Forms with Data for more details on _data usage.
    • You can use a form field template in the URL field. The encode=false template parameter is important to avoid mangling the URL. See Templatized String Parameters for details.
  • Send the data as a PDF attachment or other image type using the Send Snapshot dropdown. The image type options are PDF, PNG or JPG.  Select the blank option from the dropdown to exclude this attachment in the submission.
  • Attach an XML data document using the Data checkbox. This checkbox is checked by default. Uncheck it to exclude the XML data document in the submission.
  • Attachments uploaded to your form/flow are included if the Attachments checkbox is checked. This checkbox is checked by default. Uncheck it to exclude attachments in the submission.
  • If you have Pixel Perfect mapped PDFs (ex: W-4, I-9 etc…) associated with your forms/flows, choose  the action you want to take from the Send Generated PDF Forms control:

    • Check All to send all the mapped PDFs. This is the default value.
    • Check None to send none of the mapped PDFs
    • Check Select to display a list of all the mapped PDFs associated with your form/flow. Click the ones you want to be part of the submission. Click again to deselect.
  • POST responses must be displayed in the frevvo form frame.



Forwarding users to a web page that is located in a different domain will not work.  

Forward to Paypal to complete payment

When the form is submitted, users will be forwarded to Paypal to complete payment. This multi-step wizard guides you through configuration:

  • Paypal account login
  • Paypal invoice description based on form values
  • Paypal payment amount from form values

and more...

Error

These wizards optionally allow you to customize what the user sees if an error occurs. You can either display a message or forward users to a web page of your choice. The wizards behave exactly like the corresponding Form Action wizards above. The Display message can be customized to display the actual error that occurred by adding the special {_frevvo_root_cause_msg} template to your message text. This is helpful for debugging, especially if your are using Live Forms Online.

Display Message if an error occurs

Forward users to an error page of your choice

 

Document Actions

The document action wizards configure what happens to the entered data when a user submits your form/flow.

You can access the Document Actions tab in three ways:

  • Click the  Edit Form/Flow Properties icon on the Forms/Flow Designer toolbar. This will launch the Forms/Flows Properties wizard. Click the Document Actions tab.
  • Click anywhere in the Document Actions section in the Properties Navigator. This takes you directly to the Document Actions tab.
  • Click the inside the Form/Flow Actions section in the Properties Navigator. This takes you directly to the Document Actions tab.

The wizards help guide you through the configuration process. Many of the wizards allow you to use form controls as templates for dynamic behavior. See the section on using templates in form/doc/error actions for full details. Hover over any field in the wizards for a helpful hint.

See Doc URI Wizards below for details on using the wizards to configure doc URI settings. Please also refer to the processing submissions tutorial.

This wizard has three tabs as shown in the screen image below:

  • Doc Actions
  • Additional Email
  • Doc URIs  

Send Documents

Using these wizards you can:

  • Do nothing with the data
  • Email the data to an email address
  • Post the form data to your web application
  • Save the data to PaperVision®/ImageSilo®
  • Save the data to a Google Document.
  • Save the Live Forms submissions to a local or remote filesystem using the Filesystem connector.
  • Save submissions to a SharePoint site.

The wizards help guide you through connecting your forms/flows to various destinations. Many of the wizards allow you to use form controls as templates to dynamically configuring wizard parameters. For example you can dynamically set the email address to send the data to instead of hard coding an email address. See the section on using templates in doc action/doc URI wizards for full details.

Doc action wizards are single select. If you set up one of the wizards then configure an action using a second wizard, the information configured on the first wizard will no longer display. This is as designed.

Let's say you want to send an email after your form/flow is submitted but you are also using the Filesystem connector to save your submissions to a directory on a local server. You configure the Filesystem connector wizard to do this. Then your configure the Email data to a specified address wizard to send the email. If you return to the Filesystem connector wizard, after configuring the email wizard, the information that you entered on the Filesystem connector screens will no longer display. In this situation, you can use the email wizard on the Additional Email tab to configure your email

Do Nothing

This is the default option, which simply stores the data in Live Forms' submissions repository. (The other options also store the data in the repository but provide additional functionality.)

Do nothing is typically selected when you plan to do one or more of the following: 

The form's save property controls whether or not your form submission data is also stored in Live Forms' submission repository

Send Email

When the form/flow is submitted, Live Forms will send an email message with the following selectable options attached. These include submission data,  an XML document, an image of the filled form/flow, attachments uploaded to the form/flow and any, all or none of the Generated Forms (mapped PDFs) associated with your form/flow.

Fill in the Send Email wizard with the following information:

  • Enter destination email addresses in the To: Reply to: Cc;, Bcc: fields. The email can be sent to multiple addresses separated by a comma or a semicolon. The "To:" email address is required. All other email fields are optional.

    The tenant admin can configure the from email address on the tenant admin's Edit Tenant page. If you want an email to show a different From:address than what is configured on the Edit Tenant page, enter that address in the From: field. You can enter a static address or use templates to make the the address dynamic. The From address replaces the default no-reply@… , an address configured on the Edit Tenant screen or any settings in web.xml or frevvo.xml config files for In-house customers.

    You can even use the standard internet address convention, for example: From: frevvo Client Services <services@frevvo.com>, so that your emails appear in people's inboxes looking like this:

  • Customize the email body and Subject text in the Message field. You can use HTML and templates.
  • Send the form/flow data as a PDF attachment or other image type using the Send Snapshot dropdown. The image type options are PDF, PNG or JPG.  Select the blank option from the dropdown to exclude this attachment in the submission.
  • Attach an XML data document using the Data checkbox. This checkbox is checked by default. Uncheck it to exclude the XML data document in the email.
  • Files uploaded to your form/flow are included if the Attachments checkbox is checked. This checkbox is checked by default. Uncheck it to exclude attachments in the submission. 
    • If you have Pixel Perfect mapped PDFs (ex: W-4, I-9 etc…) associated with your forms/flows, choose  the action you want to take from the Send Generated PDF Forms control :

      •Check All to send all the mapped PDFs. This is the default value.
      •Check None to send none of the mapped PDFs
      •Check Select to display a list of all the mapped PDFs associated with your form/flow. Click the ones you want to be part of the submission. Click again to deselect. 
     

See Email Integration for further details.

POST data to your web application

When the form is submitted, Live Forms POSTs the document set to the specified URI and ignores any returned XHTML or redirect. This option may be used for additional processing of data. Use form action post if you want to both submit data to your URI and forward to a web page or display returned XHTML.

Fill in the Post Data to your web application wizard with the following information:

  • Enter the URL to the application where you want to post data:
    • Your URL field must include the http:// prefix (e.g., http://myhost.com/services/processPayment). The application can have a Form Action Base URL which you set in the application properties. For example, you can have http://myhost.com/services/ in the application baseURL and simply “processPayment” in the Form Action URL field.
    • The URL can also include control templates. This can be useful when you wish to specify a production versus a test server. For example: http://{serverURL}/services/processPayment/{customerId}. Using this form URL, you can specify serverURL using &_data=(serverURL:'testhost'). This makes switching from a test server to a production server a matter of setting the form URL parameter "serverURL" rather than editing the form itself. See Initializing Forms with Data for more details on _data usage.
    • You can use a form field template in the URL field. The encode=false template parameter is important to avoid mangling the URL. See Templatized String Parameters for details.
  • Send the data as a PDF attachment or other image type using the Send Snapshot dropdown. The image choices are PDF, PNG and JPG. Select the blank option from the dropdown to exclude this attachment in the submission.
  • Attach an XML data document using the Data checkbox. This checkbox is checked by default. Uncheck it to exclude the XML data document in the submission.
  • Attachments uploaded to your form/flow are included if the Attachment checkbox is checked. This checkbox is checked by default. Uncheck it to exclude attachments in the submission. 
    • If you have Pixel Perfect mapped PDFs (ex: W-4, I-9 etc…) associated with your forms/flows, choose  the action you want to take from the Send Generated PDF Forms control :

      •Check All to send all the mapped PDFs. This is the default value.
      •Check None to send none of the mapped PDFs
      •Check Select to display a list of all the mapped PDFs associated with your form/flow. Click the ones you want to be part of the submission. Click again to deselect.

If a form is configured to Post Data to a web application and it does not reach it's intended destination successfully, Live Forms notifies the tenant admin of the failure via an email. If there are users given the flow admin permission for the workflow, they will receive the email instead of the tenant admin.

Send to PaperVision® or ImageSilo®

Live Forms integrates directly with Digitech Systems' PaperVision® and ImageSilo® document management products. This Wizard enables an easy way for you to save form/flow submissions to your PaperVision® and ImageSilo® document management repository as PDF, PNG and .JPG  format.

The wizards walks you through simple steps to login to your PaperVision®/ImageSilo® account and select the items you want to include in the submission:

A Doc Action Wizard steps you thru the process of connecting your form to PaperVision.

  1. Log into your Live Forms tenant as a designer user.
  2. Open your form/flow in the appropriate designer.
  3. Click the Edit Form/Flow Properties wizard on the designer toolbar.
  4. Click the Document Actions tab. Select Send to ImageSilo or PaperVision Enterprise on the Send Documents tab.
  5. Enter your PaperVision/ImageSilo entity, username and password and click the login button
  6. The wizard connects to your account and now displays a dropdown with all your PaperVision/ImageSilo projects
  7. Select the project where you want to save the form/flow submission
  8. Select the image type: PDF, PNG or JPG from the Send Snapshot dropdown. PDF is the default option. Select the blank option from the dropdown to exclude this attachment in the submission.
  9. Check the Data checkbox if you want to store the xml data document in addition to the form image document
  10. Attachments uploaded to your form/flow are included if the Attachment Files checkbox is checked. This checkbox is unchecked by default.
  11. Choose  the action you want to take from the Send Generated PDF Forms control if you have Pixel Perfect mapped PDFs (ex: W-4, I-9 etc…) associated with your forms/flows, 

    1. Check All to send all the mapped Pixel Perfect PDFs. This is the default value.
    2. Check None to send none of the mapped PDFs.
    3. Check Select to display a list of all the PDFs associated with your form/flow. Click the ones you want to be part of the submission. Click again to deselect.
  12. The wizard connects to your selected project and retrieves the list of key index fields from PaperVision/ImageSilo
  13. Map each PaperVision/ImageSilo key index field to a field on your Live Forms form/flow. The dropdown contains a list of all the form/flow fields listed by field name (not field label). Fields in different sections that have the same name may only appear once. Checking the Data checkbox will show both fields. Consider using unique names even when fields are in different sections to improve clarity.
  14. Click Submit. 
  15. Save the form/flow.

Your form is now connected to PaperVision/ImageSilo. When you use your form and click the submit button the form/flow image, and all items selected in the doc action wizard will be saved into your PaperVision/ImageSilo project.

When a users fills and submits your form the selected items will automatically be stored into the selected PaperVision®/ImageSilo® project. The document's index fields will be set to the values the user entered into the form.

The pve connector by default does not send handwritten signature images to ImageSilo. This can be overridden by setting frevvo.send.signature.xml parameter to true in web.xml in the pve.war. 

If a form/flow submission does not reach PaperVision®/ImageSilo® successfully, Live Forms notifies the tenant admin of the failure via an email. If flow administrator(s) are configured the flow admin(s) will receive the email instead of the tenant admin.

 See  ImageSilo® integration for full details. 

Send to Google Drive

The Send to Google Drive wizard steps you through the process of saving your documents to Google Drive.

  1. In Google Drive, create a parent folder that will hold all the submissions for this form/flow.
  2. Log into your Live Forms tenant as a designer user.
  3. Open your form/flow in the appropriate designer.
  4. Click the Edit Form/Flow Properties wizard on the designer toolbar.
  5. Click the Document Actions tab. Select Send to Google Drive on the Send Documents tab.
  6. In the wizard that appears, enter your credentials (see above for how to get an access token).
  7. Select the parent folder you created earlier in Step 1.
  8. For Submission folder, you may enter a fixed value (not recommended) or use a template. In this case, we have chosen the StudentsName control. For example, if you enter John Adams in the Student Name control, the submission documents will be stored in a subfolder called JohnAdams.

  • Do not use spaces or special characters when creating submission folder names.
  • If you want to save a pdf of your form/flow to the Google folder, make sure you have Save PDF checked. An optional field that is used to name the pdfs displays. You can use templates in this field. For example, if you have a control called EmployeeName in your form, you can type {EmployeeName} into the PDF Name field and the pdf's in the Google folder will be named {EmployeeName}.pdf
  • If a form/flow does not reach the specified folder in your Google drive successfully, Live Forms notifies the tenant admin of the failure via an email. If flow administrator(s) are configured, the flow admin(s) receive the email instead of the tenant admin.

     

See Google Connector for full details. Also refer to the Leave Approval Workflow Tutorial for step by step instructions.

Send to File System

The Save to Filesystem wizard is used to connect forms/flows to the frevvo Filesystem Connector. The connector saves submissions in a specified location and can be configured to create metadata files for importing your submissions into a document Management system.

Filesystem Connector
Saving files to a local or remote location is easily done with the Save to File System wizard if generating metadata is not required.

Let's begin with a very simple example. Here are the requirements:

  1. You have created a small form that has a Name, Address, City, State and Zip Code fields. A mapped W - 4 PDF is included in the form. The Save PDF property is selected and the PDF Name property is configured with the template {Name}.

  2. You want to store the submission files for this form in a directory on your local machine named Submissions. 
  3. You want to create a sub directory for each submission under the Submissions directory. The name of the sub directory is created from the value entered into the Name field on the form
  4. You want to save the form/flow PDF, any mapped PDFs associated with the form, an xml file and any attachments uploaded to the form in the subdirectory. 

Follow these steps to fulfill the requirements by using the doc action Send to Filesystem wizard

    1. Log into your Live Forms tenant as a designer user.
    2. Open your form/flow in the appropriate designer.
    3. Click the Edit Form/Flow Properties wizard on the designer toolbar.
    4. Click the Document Actions tab. Select Send to Filesystem on the Send Documents tab.
    5. To fulfill the requirements listed above, we only need to fill in the URL, Submission Directory and File sections of the wizard. Here is an explanation of the fields:

      1. The URL: this is the URL to the location where you installed the Filesystem Connector. Be sure to include the /filesystem/submission in the URL after you change the server and port.

        1. In-house: The location of the Filesystem connector is set for the installation using the frevvo.filesystem.connector.url parameter in the <frevvo-home>\tomcat\conf\frevvo-config.properties file. It defaults to http://localhost:8082/filesystem in the tomcat build. The <localhost:8082> in the default URL can be changed to the <server:port> where you installed the Filesystem connector in your environment. This is a required field. The value entered here overrides the value in the frevvo-config.properties file.

        2. Cloud customers will see the placeholder http(s)://host:port/filesystem/submission - enter the https url to the location where you installed your Live Forms Filesystem Connector.


           

      2. Submissions Directory - Enter a relative path from the root directory specified by the connector.file.root.dir parameter in the configuration file created above. Control templates are allowed in this field. You can use a control template to store submissions in subdirectories. The template, {Name}, will populate the Template field. Copy the template from the Template field and add it to the Submissions Directory path after the forward or backward slash. Note the forward or backward slash can be used to create subfolders.

        Examples
      3. If the value of the connector.file.root.dir parameter in the configuration file is "c:\" then entering Submissions in the Submission Directory field in the wizard saves the files in the local directory c:\Submissions.
      4. File Section - One or more types of submission content can be specified by checking the Send Snapshot, Files, Gen Forms and Data checkboxes:
        1. Select the snapshot format to be sent by selecting a choice form the Send Snapshot dropdown. The format choices are PDF, PNG or JPEG.
          1. Check the Attachments checkbox to send any file attachments uploaded to the form.
          2. Check the Gen Forms(PDF) checkbox to send the mapped W - 4 PDF.
          3. Check the Data checkbox to send the form XML document for the form.
    6. Click the Submit button.
    7. Click the save and exit icon to save your changes.
    8. Create some submissions by clicking the Test button, filling in the form and clicking submit.
    9. The results of 3 submissions are shown in the image.

Refer to the Filesystem Connector chapter for the installation and configuration details plus information about using the Save to File System wizard and generating metadata.

Send to SharePoint

Connecting your forms/flows to your SharePoint site is easy with the Save to SharePoint wizard. Your tenant must be configured for SharePoint in order for this wizard to display.

  1. Login as a Live Forms designer user. If you are In-House Live Formsconnecting to Sharepoint in the cloud, use the URL https://<server>:<SSL port>/frevvo/web/login. Example: https://localhost:8443/frevvo/web/login. Port 8443 is the default.

  2. Create your form or flow with controls that capture the data that you want to store in the columns configured in the Lists and Libraries on your SharePoint website
  3. Click on the Edit Form/Flow Properties icon on the designer toolbar.

  4. Select Send to Sharepoint. If the tenant is not configured for SharePoint, the Send to SharePoint option will not display.



  5. Click Login. You’ll be redirected to login to SharePoint or Office 365 if you are logging into your account for the first time.
    1. On successful login, you will be asked to grant or deny access for your Live Forms SharePoint add-in.


      Click Trust It to authenticate and grant permission to Live Forms. You will not see the trust screen on subsequent logins. The wizard will display.

      • We recommend that you create a separate user in SharePoint for frevvo forms connection, and use that user while configuring the Save to SharePoint wizard in frevvo forms. This frevvo specific SharePoint user always remains active and eliminates issues if the designer user configured your forms to submit to SharePoint using their own SharePoint login and then leaves the company.
      •  At least one designer user must also be a SharePoint user with the correct privileges to provide consent when invoking the Save to SharePoint wizard if your tenant is configured with the Azure SAML Security Manager .
  6. You can set up a single Document Action to write to multiple places (SharePoint Library and List). Add a route for the second destination by clicking the Route 2 icon.



    1. Select a format for the Snapshot to be saved in SharePoint. The choices are: PDF, PNG or JPEG. If you do not check the Snapshot checkbox under the Destination Type section, you can leave this field empty. PDF is the default.
    2. Enter the site URL - this is the SharePoint site or subsite containing the destination e.g. https://frevvo.sharepoint.com - Remember this URL must specify the https protocol. This value is read in from the SharePoint tenant configuration screen for Route 1.

    3. Set up the first location (route) where you want to save your files in SharePoint. SharePoint destinations can be a Library (and optionally a Folder), or List. Select Library or List from the Destination Type dropdown.

    4. The wizard pulls the list of Libraries and Lists configured on your SharePoint site to populate the Library/List dropdown. Select Library or List. Only destinations that the user has access to are displayed.
      1. If your Library has folders configured, the wizard will display a dropdown listing them. Select the destination folder from the list.
    5. Select a Content Type from the dropdown. The wizard automatically pulls the content type choices from your SharePoint site. The Content Type determines the available metadata column names for mapping. For example, if the destination is a Document list you would see Item as a choice for the Content Type. This means your submission is saved as a new item on your SharePoint list. Document Libraries show Document.as the Content Type.

    6. Check the types of files to be saved to the selected destination. The choices are:
      1. Data - include the Live Forms XML document

      2. Snapshot - include a snapshot of your form/flow in the format selected in the Send Snapshot field

      3. Attachments - include attachments uploaded to your forms/flows. The wizard automatically lists the Upload Controls in your form/flow by name when Files is checked. The attachments for the selected Upload Controls will be saved in the configured destination. 

      4. Gen Forms(PDF) - this checkbox appears if you have mapped PDFs associated with your form/flow e.g. W-4 and I-9 filled out by a new employee. Check it to send all mapped PDFs to SharePoint.

    7. Map the Control Names in your form/flow to the column names in your SharePoint destination. The wizard will populate the Column Name dropdown with all the columns in the destination but a maximum of 15 controls can be mapped.

      When mapping Message controls with templates to the SharePoint Connector, the Save Value property should be checked.

  7. Click Submit.

  8. Click the save and test icon to save the form/flow and bring up Test mode popup.

  9. If you configure a second Route, clicking the Clear Route button removes the information for Route 2 only.

Refer to the SharePoint Connector chapter for configuration details and more information on the Send to SharePoint wizard.

Send Data

Using these wizards you can:

  • Do Nothing
  • Post submissions to a Google Spreadsheet
  • Manually set document URIs - to connect to database and other back end systems

The Send Data wizards enable you to manually set a URI to which the data will be sent when your form is submitted.

Do nothing

This is the default option. If one of the other 2 options is set you can clear them by clicking this one.

Post Submissions to a Google Sheet

Live Forms supports direct connectivity with Google Spreadsheets. This wizard allows you to save submissions directly into Google Spreadsheets. It also provides additional assistance in setting up the login to your Google account and in selecting the spreadsheet.

After the user submits the form, the data will be written into a new row in the Google spreadsheet. This wizards steps you through the process of logging into your google account and locating the spreadsheet you where you want to save the submissions.

  1. Edit your form/flow
  2. Click the  Edit Form/flow Properties icon in the designer(s) toolbar.
  3. Click on the Document Actions tab, then click the Send Data tab.
  4. Check Post Submissions to a Google Spreadsheet.



  5. This launches the Google Sheet Wizard.
    1. Login using your user id and auth token (from Step 1).
  6. A Spreadsheet dropdown appears listing all the spreadsheets in your Google account
  7. Select the Google Sheet from the list. 
  8. Select the worksheet of your Google Sheet from the dropdown.
  9. Click Submit.

  10. That’s it. When the form is submitted, the data will be saved to the selected Google Sheet.  

See the Live Forms Save your Submissions to a Google Sheet for details.

Here is an example Google spreadsheet that is updated with a new row each time the form is submitted.

Manually set document URIs

After you have generated controls from the elements in your database schema, set your form’s Document URI to the database connector query URL. Follow these steps:

  1. Click the Edit Form/Flow Properties icon in the toolbar at the top of the form.
  2. Click the Document Actions tab. Click Send Data then select Manually set document URIs.


The first section in the wizard is for the form's default document. This is indicated by the Document Name of "default" displayed in the wizard. The default document maps to all of the controls you added to this form by dragging and  dropping from the palette. This is typically not the document you want to configure.

  • The second section is for the next schema document. You should see the Document name change to your schema's document name. 

The next screen has two sections: Read URI and Write URI. Typically, when the form loads, Live Forms customers read form data from their database to initialize the form and send the updated XML document to the same database upon form submission. Enter the same URI in the Read URI and the Write URI fields, as shown in the image, with the appropriate SQL statement to run if you are reading from and writing to the same database using the database connector. It is possible to read the form initialization data from one database and then update a different database. Enter different URIs in the Read URI and the Write URI fields if this is your situation.

  • Enter the database connector Url to your query in the wizard's URL input. If the database connector is running in the same host and port as the Live Forms form server, then you can omit http://<host>:<port>/ from the URL. Use templates to create dynamic URLs. See this example below.

You also must specify which of the four SQL statements to run—you do this by choosing the appropriate values in the Document URI Read Method and Document URI Write Method dropdowns according to the table below. (You may notice in the Forms Designer that the Document URI Read Method drop down box includes a POST option, but it is not shown below because it is not used by the database connector.)

SQL Statement TypeDocument URI Read MethodDocument URI Write Method
CreateLeave blankPOST
RetrieveGET (or leave blank if you are not retrieving data)Leave blank if your form is read-only
UpdateLeave BlankPUT
DeleteLeave BlankDELETE

You’ll see one set of Document URI properties for each schema in your form. Type the Document URI next to the schema name—make sure not to type it next to the Default schema. To specify which of the four SQL statements to run, choose the appropriate values in the Read Method and Write Method dropdowns, based on the information below. 

  • Read Method - Choose GET if your form will be initialized with data from your database; leave the dropdown blank if it won’t. (Don’t set the Read Method to POST; this is used for integrating forms with different back ends.) 
  • Write Method - If your form is read-only, leave this blank. Otherwise, use the chart above chose either PUT or POST. PUT maps to the update method while POST maps to create.

Note that you may choose only one Write Method in the Forms Designer.

If a form is configured to post data using a manually set document URI and it does not reach it's intended destination successfully, Live Forms notifies the tenant admin of the failure via an email. If a flow does not reach the web application successfully, the flow administrator(s) - if configured -  receive the email instead of the tenant admin.

See  the chapter on connecting to your database for all the details.

Additional Email Wizard

When the form is submitted, Live Forms can send an additional email message with optional XML document(s) , an image of the filled form, attachments and Pixel Perfect PDFs (referred to as Generated Forms), 

Slide the toggle to the right to turn on the Additional Email wizard.

The email can be sent to multiple comma separated email addresses. The "To:" email address is required. All other properties are optional.

  • Enter destination email addresses in the To: Reply to: Cc;, Bcc: fields. The email can be sent to multiple addresses separated by a comma or a semicolon. The "To:" email address is required. All other email fields are optional.

    The tenant admin can configure the from email address on the tenant admin's Edit Tenant page. If you want an email to show a different From:address than what is configured on the Edit Tenant page, enter that address in the From: field. You can enter a static address or use templates to make the the address dynamic. The From address replaces the default no-reply@… , an address configured on the Edit Tenant screen or any settings in web.xml or frevvo.xml config files for In-house customers.

    You can even use the standard internet address convention, for example: From: frevvo Client Services <services@frevvo.com>, so that your emails appear in people's inboxes looking like this:

  • Customize the email body and Subject text in the Message field. You can use HTML and templates.
  • Send the data as a PDF attachment or other image type using the Send Snapshot dropdown. The image type options are PDF, PNG or JPG.  Select the blank option from the dropdown to exclude this attachment in the submission.
  • Attach an XML data document using the Data checkbox. This checkbox is checked by default. Uncheck it to exclude the XML data document in the email.
  • Files uploaded to your form/flow are included if the Attachments checkbox is checked. This checkbox is checked by default. Uncheck it to exclude attachments in the submission.
  • If you have Pixel Perfect mapped PDFs (ex: W-4, I-9 etc…) associated with your forms/flows, choose  the action you want to take from the Send Gen PDF Forms control:

    • Check All to send all the Pixel Perfect PDFs. This is the default value.
    • Check None to send none of the PDFs.
    • Check Select to display a list of all the PDFs associated with your form/flow. Click the ones you want to be part of the submission.  

For example, consider a Vacation Request Approval workflow. When the workflow is complete, we want to send a PDF to the internal HR system (using the document action) but in addition, we want to notify the employee requesting the vacation by email. Use the Additional Email wizard for this scenario. The email to the employee will contain whatever documents are selected on the Additional Email wizard screen.

To use the wizard, click the Doc Action icon in the toolbar at the top of the form and select the Additional Email Tab. See  Email Integration for further details on configuring the content of the email.

How to set up Multiple Document Actions

It is important to remember that doc action wizards are single select by design. The Additional Email wizard can be used to send an email if you are configuring more than one doc action on a form/flow. 

Let's say you have a workflow where you want to
 

  1. Save a copy of the form to Google Drive
  2. Email a copy of flow pdf to the IT department

Set up the Save to Google wizard. Then use the Additional Email tab to configure the email to the IT department.

Using Templates in Form/Doc/Error Actions

The values/entries in all doc action/doc URI wizards can be customized with data entered in the form/flow using templates. The values set in the following Form Action wizards can be customized with data from the form:

  • Display a message
  • Forward users to a web page
  • Post data and forward users to a web page

For instance, in the display message, you may wish to display a customized message with the user's name. You can use templates in the display message to do this.

  • Make sure you have two controls in the form called FirstName and LastName.
  • Click on Form Action
  • Click on Display a Message.
  • In the Message area of the wizard, type: Thank You {FirstName} {LastName} for submitting my form.
  • As a shortcut, you can also select the appropriate control from the drop down by clicking the  down arrow on the right side of the field.
  • Click Finish.

Use the form by clicking on the Test button. Enter something into the First Name and Last Name controls. When you click submit, Live Forms will display the above message with {FirstName} and {LastName} replaced by the values entered by you.

Templates work the same way when used in URLs for forwarding to a web page or Post data. When referring to repeat controls you must use a special template syntax. See templates for repeat control for details.

There are built-in templates you can use:

  • {_frevvo_root_cause_msg} - Add this to the Error Action Display Message to display the actual error that occurred.

Templates work the same way as documented above when used in Doc and Error Action Wizards.

 

 

 

 

 

 

 

 

 

  • No labels