All Collections
Sales Force Automation
Working with Online Forms
Working with Online Forms

Online Forms lets you create, edit and share web forms/surveys & is fully integrated with your Pipeliner CRM data

Updated over a week ago

This article is intended for Pipeliner Admins and Power Users with a good knowledge of working with Pipeliner features such as Mass Emails and Automatizer.

Overview

We're delighted to introduce our new Online Forms feature that lets you create, edit and share web forms/surveys. It's fully integrated with Pipeliner CRM so that you can quickly access and work with your records.

You’ll be able use this new feature to:

  • Create, edit and manage Online Forms

  • Customize the appearance of the Online Forms

  • Share or send personalized and pre-filled Forms links

  • Generate code to allow your web team to embed Online Forms into web pages

  • Protect the Online Forms on your website by using reCAPTCHA to prevent attacks from bots, abuse, etc.

  • Create or update records in CRM based the form data submitted

  • Trigger Automatizer processes from form submissions

  • Track and analyze Form responses

Use Cases

To give you some ideas of how to use this new feature in your own business, we’ve created some simple guidelines for working with the following scenarios:

  • Capture leads from the website by embedding a Form on a website

  • Get feedback from customers on services or products by sending the Online Form as a Survey

  • Update missing/target data in CRM automatically when customers submit data through Online Forms

The Online Form Manager

Access the Online Form Manager by clicking on the Tools menu and then selecting Online Forms ⤵

You’ll see a list of all Online Forms regardless of which user created the form ⤵

NOTE: by default, and depending on their User Role, users will only be able to edit Forms that they created.

Click on the “Filter” button in the top right to filter Forms by Owner, Primary Record Type or Status or click into the Search box to use a full-text search or by a Filter ⤵

Form Properties

If you click on a Form to select it, a sidebar will open that contains information about the selected Form ⤵

The Details tab shows basic information about the Form - including Name and Description - as well as simple Form Statistics.

NOTE: to see full statistics about the Form responses, click on the “Show Statistics in CRM” link.

The Responses tab chronologically displays all responses submitted by responders.

The Activity Log tab shows a log about every response that was created

Actions within the Sidebar

From within the sidebar, users can access the following actions:

Edit

Edit the selected Form if you’re the Online Form Owner or an Online Form Admin (as set in User Roles)

Properties

Add or update the Form name and/or description as well as the Online Form Owner

Get Link

Each form has a public link that can be shared with other users/customers. Make sure that the Form has been activated prior to sharing a link or the recipient will not be able to respond to the Form ⤵

There are three types of links:

  • Link - standard URL to the form, an opened form will be empty and the responder will need to fill in all the fields/questions

  • Pre-filled link - the URL will contain query params that will pre-fill the specific “answers”. This is dependent on the field/question pre-fill setting in the Form Editor.

  • Personalized link - the URL will contain query params that will pre-fill the specific “answers” based on a selected record (e.g. pre-fill the First Name, Last Name and Email Address based on a selected Contact record). This is dependent on the field/question pre-fill setting in the Editor.

Get Embed Code

The generated Embed Code allows your web developers to embed the created Form to any web page ⤵

The Form can be embedded as

  • Javascript - this is the best way to embed a Form as the Form will be a part of the page (CSS style will be inherited)

    • The embedded form can be also pre-filled with custom values in the same way as a Pre-filled link

    • To allow form submissions, your Pipeliner Admin should set up the reCaptcha setting

    • These keys can be acquired from the Google Admin Console. You’ll need to have a Google Enterprise account

    • The link to Google reCaptcha is set by Google as a static Google URL ⤵

  • Iframe - this is the simplest Embed option but has limitations ⤵

Protecting your Online Form using reCAPTCHA

This article has more detail of how to generate the keys needed to protect your Online Form when you add it to your website using Javascript.

NOTE: when you are setting up reCAPTCHA for a new domain, it can take between 5-15 minutes to propagate to your online form so please be aware of this before testing. This short lag is on the Google side so cannot be affected by your set up.

Print Responses

Creates and downloads a PDF file of all the individual responses submitted by recipients of the Form ⤵

Export

Export all responses received from recipients of the selected Form to Excel or csv ⤵

Copy

Creates a copy of the selected Form which can then be edited by the Online Form Owner or an Online Form Admin (as set in User Roles)

Delete

Delete the selected Form if you’re the Online Form Owner or an Online Form Admin (as set in User Roles)

Activate/Deactivate

Only active Forms can record responses, so when an Online Form is ready to use, the Owner needs to activate the Form (and wait for responses!). Any inactive form is still live, but it cannot store the responses and any recipients trying to submit a response will see only a static page ⤵

These actions - except Edit - can also be accessed from the toolbar buttons within the Form Manager and the “Create New” option is also available from the toolbar ⤵

Creating a new Online Form

Click on the “Create New” button to add a new Online Form ⤵

Fill in the Online Form Name and a Description. Select a Primary record type from the dropdown (choose from Account, Contact, Lead or Opportunity). By default, you’ll be the Online Form Owner but you can change that to a different User if required.

Click on “Create” to open up the Online Form Editor.

Working with the Online Form Editor

When you create a new Online Form, or Edit an existing one, the Online Form Editor will open to allow you to edit and customize the Form ⤵

Structure of an Online Form

Every Form includes the following sections:

  • Header Image

  • Header

  • Fields

  • Footer

Choosing a Header Image and Color Scheme

You can add images to the Form. Clicking on the image area “Click to edit theme settings” will open up a sidebar ⤵

Choose an image to use on your Form. The image file type needs to be one of .png, .jfif, .pjpeg, .jpeg, .pjp, .jpg, .gif. Resize your image to fit within the boundaries and then “Apply” ⤵

Click on “Preview” to see the results of your choices ⤵

Leave the tick in “Show color ribbon” to display a top border above your image in your chosen color.

Leave the tick in “Show question numbers” to display incremental numbers for each field added or uncheck it to remove the numbers.

Click on “Color Schemes” to choose one of the pre-defined color schemes to use for the border and background.

Rather than use pre-defined style, you can click on “Customise Style” to choose your own colors for the Submit button, backgrounds, fonts, borders etc ⤵

Adding a Header

Click into the “Header” section to add a Form Title and Description as well as decide if the Header should be visible or not (this might be useful when the form is embedded) ⤵

You can use Rich Text formatting as well as add Personalization markers to insert data from selected Pipeliner records into your Form ⤵

Using Fields on your Form

Depending on which “Primary Record Type” was selected when the Form was created, in the left hand panel, you will see a few pre-created Fields that can be added to your Form.

Each field represents a “question” or data value that can be filled in by a recipient of the Form when you send a link or embed the form on a website.

In addition to the pre-created fields, you can create additional custom fields of the following types:

  • Float (number with decimal places), Integer (whole number)

  • Date, Date & Time

  • Dropdown, Multi-select, Radio (these fields have a validated list of options)

  • Rating (a new type of field only available on Online Forms)

  • Single Line text (max 256 characters), Long text

  • Email, Phone

  • Checkbox

All fields are shared between Forms and can be used only once per Form. You can drag & drop a field from the left hand panel onto your Form ⤵

Click on the three dots icon to Edit a field, Copy it or Delete it ⤵

Add a new field using the “Create New Field” button. If you choose to add a field of type Dropdown, Radio or Multi-select checkbox, as well as the Field Name, you’ll need to specify the values that a recipient of the Form will be able to use when filling in and submitting the Form.

The first option is to choose “Custom values” and then type in the options that should be available for recipients to choose from ⤵

The alternative option is to “tie” the values of your new field to a field that already exists in Pipeliner. This is a great way to ensure that any responses received map directly to a valid option. Choose “Existing Field Values” and then choose the field to map the values from ⤵

Here’s the mapped field from the Accounts Fields tab in Pipeliner showing the values that will be available on the Form for the responder to pick from ⤵

If your new field is any other Type, you’ll just need to enter a Field Name and choose the Type from the list ⤵

We’ve also added a new field type “Rating” for you to use on Online Forms to capture feedback scores ⤵

Form Field Settings

Once you’ve dragged and dropped a field onto your Form, you can then update the Properties. A field can be:

  • Reordered by dragging & dropping vertically

  • Made “Invisible”

  • Set as “Required”

  • Made “Read-only”

  • Pre-filled with data

  • Removed from the Form

  • Copied to create another new field ⤵

Click on an individual field to open up the sidebar ⤵

The General tab

Enter a Title and Description for the field. This can be different on each Online Form. You can use Rich Text formatting and insert Personalization Markers into both the Title and Description.

Scrolling down, you’ll be able to select an image to display for each field as well as make the field Visible (on by default), Required or Read-only

The Values Tab

Click on the Values tab to customize text, placeholders and ranges of the current field. The values are dependent on the field type ⤵

NOTE: Date and Date/Time fields have no Values tab.

The Pre-fill Tab

You can “Enable pre-fill” for each field. This allows you to share the Form link with some answers already populated or filled with default values to help your recipients complete the Form quickly ⤵

Choose between the 2 options to determine how the values will be pre-filled:

  • Custom pre-fill value - choose a fixed custom value that will be used for pre-filling

  • Pre-fill value by field - select a field from which the value will be prefilled. You’d use this option when you want to personalize the Form and pre-fill it with values that relate to your chosen record. Note that you can only select compatible matching fields - e.g. if your Form field is a date, you’ll only be able to select from date fields on your record type.

Footer

Click on the Footer to change the text of the Submit button ⤵

Online Form Settings

Click on the Settings button to select options to determine the behaviour of the Form ⤵

On Form Submit Tab

The On Form Submit tab determines what happens when the Form is submitted by the recipient.

Update Record Form

If your Form submission contains a value - Contact’s email address, for example - that can uniquely identify a record already in Pipeliner, you can choose to update that Pipeliner record with additional information or to overwrite existing information. Click on the “Update Record Form” button to set up mappings from your Form fields to fields in Pipeliner ⤵

Click into each field that you want to update with information submitted on the Form response ⤵

NOTE: if the primary purpose of your Form is to update records in Pipeliner, you’ll want to include a field on your Form that is pre-filled from a record (and probably read-only or even made invisible so the data cannot be amended) and this will help ensure that a matching record is found when the Form response is submitted.

Create Record Form

If a record in Pipeliner that matches to the submitted Form response cannot be found, you can enable the “Create Record” option. You'd definitely want to leave this option enabled if you don't know who may fill in your form - if you're planning to embed it on your website, for example ⤵

Click on “Create Record Form” to map fields from your Form response to a new record in Pipeliner ⤵

NOTE: the Create/Update form is always the same entity type as the form’s Primary record type.

Attach response to record as pdf

Enable this option to save the response as a pdf that will then be attached to the Documents tab of the Created or Updated record.

Response Options

Select from the following response options:

Limit to 1 response - if this is enabled, when the responder submits the Form more than once, they will be prompted to replace a previous response

Check for existing responses - if enabled, the responder will be prompted to replace an existing response OR create a new response when they submit a Form more than once whereas if this option is unchecked, all responses submitted by a user will be saved as new.

Send email notification to

Switch this on to send a notification by email when a response is submitted. You can send the response to:

  • The Owner of the Form

  • The Owner of the Pipeliner record (as long as one can be identified)

  • A specific user or users (select from the list) ⤵

When the submission was successful

When the submission was successful, choose between:

Show thank you message to display a Thank You page to the responder with your custom message as entered into the Title and Message fields below, noting that you can use Rich Text and personalization options.

Redirect to an external website by entering a custom URL.

Record Identity

The options on this tab allow you to choose how a Form response will be matched to a record in Pipeliner ⤵

There are two options that can be used to identify a record and link it with a submitted response:

Identify by Record ID - when a personalized Form link is sent to a recipient, it will contain the underlying record ID which means that the record can be precisely identified and matched to the response.

Identification by Field on the Record - enable this option and pick a field from your Form that will be used to find an existing record ⤵

NOTE: if multiple matching records are found, the Form response will update the one that has the latest Modified Date.

When a matching record is not identified, and the option to “Create New record” is not enabled - a Form response will be created but it will not be linked to any existing record. The responder will be “Unknown”.

Online Form Preview

Click on the Preview tab at any time to see the impact of your selections on how the Form will display to the recipients ⤵

If your Form is personalized, choose a record to preview how the Personalization markers will be displayed ⤵

You can swap between the Desktop and Mobile previews ⤵

Saving and Activating your Form

Once you’ve finished setting up your Form, click on “Save” to save your changes but keep it inactive so you can continue working on it or “Save & Activate” to publish your changes to the web so that responses to the Form can be submitted ⤵

You can also Get Link, Get Embedded Code or Customise Theme by clicking on the three dots icon ⤵

If someone tries to respond to a Form that is not activated, they will receive the following message ⤵

Sending Online Forms via Pipeliner Email

Once your Online Form is activated, you can send the link via a Pipeliner email. Online Forms sent via Pipeliner Emails are tracked in the Online Form Summary under the Sent and Sent Unique statistics.

Click on an email address to start a Standard email (or select a group of records to send a Mass Email). Click on the Online Forms icon to access all Online Forms that are compatible with the type of record that you’re sending the Email from (i.e. if you start your email from a Contact, you’ll see Online Forms where Contact is the Primary Record type) ⤵

Choose the Form you want to send, to insert a link into your email ⤵

How Online Form Responses are logged in Pipeliner

Submitted responses are created as a Feed item named “Online Form”. Every response submitted is linked to (related to ) a Primary record and, possibly, secondary records (similarly to Emails) depending on the matching values.

The Primary record linked to the Online Form response is named “Responded By” and you can use this field for filtering or reporting.

Subject to your User Role, you’ll be able to see “Online Form” responses (and Filter them in the Feed View tab options) from the main Feeds menu. Online Form responses are sorted by Response Date in Feeds ⤵

You’ll also be able to see them from the Feeds tab of the record they are linked to (if a matching record was identified) ⤵

NOTE: if a matching record was not found, the responder will be shown as “Unknown”. “Unknown” responses are visible to all users from the main Feeds menu.

NOTE: if a user is the Owner of the Online Form or has been granted the permission to manage online forms in their User Role, such a user will always see all responses submitted for that Form even if the user doesn’t have access to see the linked records.

Click on a response to open it ⤵

The fields (questions) from the Form are shown on the left side the Questions with the responses on the right side Clicking on the three dots allows the response to be deleted (subject to the rights detailed below) or Forwarded. When a response is forwarded, a PDF of the response is generated and attached to the Email.

Deleting Online Form Responses

Only the Owner of the Online Form or a user with permission to manage online forms can delete the Online Form responses.

NOTE: deleting an Online Form does not also delete previous responses submitted from that Form.

Online Form Summary

The Online Form Summary gives an analysis of the performance of the Online form. It allows bulk operations via data drill down and also filtering data based on response values ⤵

You can access the Online Form Summary from Feeds by clicking “Show Form Summary” ⤵

or directly from Online Form Manager by selecting a Form and clicking the “Show Statistics in CRM” link ⤵

You can also open the Form and click on the “Results” button ⤵

The Summary Tab

The Summary tab shows a breakdown of totals and also lists of specific responders/records. ⤵

Totals

Sent is the number of Pipeliner emails that have been sent which include this specific Online Form link.

Sent Unique totals the number of Pipeliner emails that have been sent which include this specific Online Form but deduplicated by record e.g. if the same Form was sent to an individual Contact twice, this total would count it once.

Responses is the total number of records who responded.

Response rate is the percentage of Sent Unique/Responses to understand the response rate when sendng Online forms via Email.

Tabs

In the Responded tab, the List View displays the records which responded to the Form.

The Sent tab is a list of records who were sent this Form via a Pipeliner email.

Sent And Not Responded tab is a list of records who were sent this Form via a Pipeliner email and where no response has been received.

Unknown Respondents is a list of responses that could not be matched to a record.

NOTE: if the same responder submits more than 1 response to the same Form, it is calculated as 1 response. Remember you can manage multiple responses in your Form Settings.

Selecting records from any list view allows you to "Export" or "Print Responses" or to “Open” to drill down into the data which then gives access to additional bulk operations. ⤵

If you Export, the resulting file will contain the Online Form field names as columns. If a field on the Form was not filled in by any respondent it will not be included in the output.

Choosing Print Responses will print the responses to a pdf file.

The Responses Tab

Use the Responses tab to view and filter responses.

Select one of the Form fields to review all responses to that particular question in the List View. You have the same options - including drill down - as in the Summary tab ⤵

Click on the Filter button to select any of the Form fields to use in filter criteria to only display the responses that you are most interested in ⤵

Reporting and Filtering on Online Forms

Online forms can be used in reporting in combination with main entities which are Accounts, Contacts, Leads and Opportunities.

Standard and Pivot Table Reports

Starting from an Accounts, Contacts, Leads or Opportunities report, you can choose to add Online Forms to your main entity data.

Create your report - for example, based on Contacts ⤵

Once your report is created, you can add Latest Online Form Response fields to your report ⤵

You can then change from Last Online Form Response to All Online Form Responses

Click on the gear icon and choose “All Online Form Responses”, also checking “Show only rows with related record(s)” to eliminate records with no Online Form Responses from your Report ⤵

Charts

Responses can be used in all different types of Charts ⤵

Filters

All Online Form fields are supported in Filters. Online Form filters are available for Accounts, Contacts, Leads and Opportunities ⤵

Automatizer and Online Forms

We’ve added support for Online Form as a trigger for Automatizer processes when Online Forms responses are submitted ⤵

NOTE: when you choose the primary record type, this will filter the Online Form(s) that you can choose from and will also determine all dependent actions - such as personalisation - that can be used in the process.

NOTE: an Online Form can be submitted without a linked record - i.e. responder is “Unknown”. You need to remember this when setting up your process as if you make conditions dependent on record fields or actions with personalization markers using the specific record type, the process might not run successfully.

Conditions

Online Form fields can be used in setting up your Conditions.

TOP TIP: in order to prevent problems that may be caused by “Unknown” responders, you should generally include “Responded by is not empty” as one of your filter criteria in your Condition ⤵

Actions

The standard options for Actions is available ⤵

You can access Online Form Personalization markers in the actions that you create ⤵

The following Online Form personalization markers are supported:

  • Triggered Online Form - “meta info” about the current form

  • Triggered Online Form Response - all questions and their values (answers from the submitted form)

  • Triggered Online Forms Question Title - all questions and their titles from the submitted Form. The field name can be different from the Title, especially if the field is used on more than one Form. You’d use these when you want to use the questions and answers in the actions

  • Triggered Online Form Owner - the Owner of the Form

  • Triggered {entity}... - Online Form Primary linked record

  • Other default System markers are also available

Sending an Online Form via the Send Email Action

You can access Online Forms set up for your chosen Trigger Entity as well as the Online Forms Manager from within an Email when using the Send Email Action ⤵

Managing access rights to Online Forms

Your Pipeliner Admins control which individuals are able to create and edit Online Forms based on User Roles. Access the Admin Module using the App Switcher icon in the top left corner of Pipeliner and select “Administration”.

Next click on Units, Users and Roles and then the Roles tab. Choose the Role to edit and then navigate to the Tools tab. In Tools select your preferred options for Online Forms for the selected User Role ⤵

If you switch off access completely, all users based on that role:

  • will have no access to online form manager

  • will see responses linked to records they can watch

  • will see all responses that are not linked to a specific record (i.e. are “Unknown”)

If you leave Online Forms enabled, you can then also choose from:

  • Allow management of Online Forms and Online Form Responses” - OFF

    • Users will have access to Online Form Manager

      • User can see all Online Forms

      • User can create and edit only their own Online Forms

    • Users will see responses linked to any records they are allowed to view and responses created by their own Forms

    • User is able to delete responses created by their own Forms

    • User will see all responses that are not linked to a specific record (i.e. are “Unknown”)

  • Allow management of Online Forms and Online Form Responses” - ON

    • Users will have access to Online Form Manager

      • User can see all Online Forms

      • User can create Forms and edit all Online Forms

    • Users will see responses linked to any records they are allowed to view and responses created by all Online Forms

    • User is able to delete responses created by all Online Forms

    • User will see all responses that are not linked to a specific record (i.e. are “Unknown”)

In addition to your licensed users, Subscription Administrators (who are not also Users) will have access to open the Online Forms Manager via the Automation Hub but will not be able to:

  • Export or Print Responses

  • Show Statistics in CRM

  • Select a record for a personalized link

  • Select a record in preview

  • Select a record in Create/Update forms relation fields/lookups

Requesting Activation of Online Forms from the Automation Hub

Online Forms is automatically enabled for customers on our Unlimited Tier. It is available as a paid-for add-on for customers on other tiers.

Did this answer your question?