This article gives an overview about designing Cognito forms templates suitable for  import into your Influence database. It is designed to cover the way to 'Tag' forms suitable for import into Influence and is not designed to be a complete Guide to the Cognito Forms software. For that please refer to Cognito's own documentation.

Contents (Click an item to Jump to that section)

TABLE OF CONTENTS

• Overview
• Videos
  • VIDEO:   Getting Started                        [Created by Cognito]
  • VIDEO:  How to Share a Template         [Created by Cognito]
  • VIDEO:  How to Copy Fields                  [Created by Cognito]
  • VIDEO:  How to Import a Form Submission into Influence
  • VIDEO:  How to Capture Attributes on  Your Form
  • VIDEO:  How to Add a New Calculation Field to your Form  (This Video has been removed - May be replaced with an updated version in future.)
  • VIDEO:  How to Change the Submission Settings for your Form
• Example Templates
• SETUP
• TYPES OF DATA
• Importing the Resource Form to your Cognito account
• Making a Copy of a Form to use as your Application Form
• Form Design Guidelines
  • Calculation Fields
  • Data Fields
• Copying Fields
• Fields you may wish to Edit in the Resource Form
  • ROLE CODES
  • Forename and Surname
  • Proof of ID & Security
    • VIDEO:   There is a video showing how to capture attributes on your Application form  available HERE
  • Documents (CV, Compliance Items, Candidate Docs)
  • Work History
  • Compliance Items
  • References
  • Policy Management
• Adding a New Field to Your Application Form (That isn't part of the demo Resource Form)
  • VIDEO:   Video showing how to Add a New Calculation field to your Application form  available HERE
• Form Submission - Recipients and Subject

Overview

This article is intended to help users to design a suitable form within their CoGnito forms account to allow the submission of candidate applications. These applications can then be automatically loaded into the Influence database.

If you have not signed up to Cognito forms, do so using the Link Below.

Link ->       SIGNUP TO COGNITO FORMS

ALSO:
In order to work with Cognito forms, your Influence database must be version 1.00.20.155 (or later). We recommend that you update to the very latest release/version as features are added or refined on a continuous basis. Please contact us to arrange an update. 

For information specific to designing a form to update the details of an existing candidate you may wish to refer to this article as well.
COGNITO FORMS - UPDATE CANDIDATES - Click to open article

Videos

Below is a list of videos which are referenced in this article. You can click on any of the links to view the relevant video.

VIDEO:   Getting Started                        [Created by Cognito]

VIDEO:  How to Share a Template         [Created by Cognito]

VIDEO:  How to Copy Fields                  

VIDEO:  How to Import a Form Submission into Influence

VIDEO:  How to Capture Attributes on  Your Form

VIDEO:  How to Add a New Calculation Field to your Form  (This Video has been removed - May be replaced with an updated version in future.)

VIDEO:  How to Change the Submission Settings for your Form

Example Templates

Below are links to example Template Forms. We suggest that you import these into your own Cognito account, then adapt these to suit.

Before you start designing your own form, we recommend that you import these examples into your Cognito account and use this as a starting point. (Click the "Importing the Resource Form into Cognito" below for instructions on how to do this.)

SETUP

In order to use the Web Form submission system you will need a licence, and will also need some parameters to be set within your Influence database. These parameters are described below.

*FORMS, Text(1) : When setting this you should set this to contain the 'leading' characters of the notification emails you will received.

Example:  FORMS, Text(1) = Candidate Registration
Any email where the subject starts with Candidate Registration, which has been received from [email protected] (FORMS, Path(1)) will be treated as a Web Form Application when dragged/dropped into the sy

In the example above, both the emails will be imported as a FORM.

Back to Top

TYPES OF DATA

Within your Influence database the Candidate Web Form Tool imports the submitted forms and uses the completed data and any attached documents to do some or all of the following:-

Back to Top

Importing the Resource Form to your Cognito account

We have created a Resource Form which contains examples of all the types of information that can be captured and imported using a form and can be used as a staring point for creating your own Application Form.  Unwanted fields or sections can easily be deleted from the form.

If you wish to add additional fields to the form, then the existing items can be used as guidance to help with the creation of similar fields.

VIDEO:  You may wish to watch the video from Cognito Forms which explains about sharing and importing Templates.  How to Share a Template

Essentially the process is:

i) Click on the link to the resource form which you will be sent.
ii) When prompted choose [Select] then click [SAVE] to save the template into your account.

Back to Top

Making a Copy of a Form to use as your Application Form

Having imported the Resource Form into your Cognito account, you can create a COPY very easily.  You may wish to watch the video from Cognito Forms will show you how to create a COPY of a Form/Template.  How to Copy a Template Form

Essentially the process is:

Find an existing form and hover the cursor over the form name.
Choose 'Copy' from the sub-menu that appears.

Having created your own copy of the Form, you can then start to edit your version to match your own system and add the fields and documents you wish to capture and adjust amend the roles or skills which exist within your own Influence database.

Back to Top

Form Design Guidelines

Below are some useful guidelines about how to design your form. We recommend that you start with our Resource Form template. Having imported the template into your CoGnito account we suggest you make a copy of the form and call this Application Form, and then begin to edit the copy. Certain fields will need to be edited to match the entries and codes within your Influence database.

Each item you wish to import from your Application Form is made up of two elements:-
A Calculation field  Used to tell the system where to store the data within your Influence database.

A Data field used to capture the actual data entered into the form.

There are several types of Data field which can be chosen when building your Form.

Calculation Fields

Within your Cognito Form Calculation fields are used as the method to indicate to influence what data the following field contains. Whenever you are designing or editing a form a Calculation Type field marked as [Internal] needs to precede every field that you wish to be imported into your database. It must be a Calculation field with the Type set as Text.

In the example above you can see a calculation field containing the calculation
="[[CAND_PHONE]]"
These calculation fields should be set to Show For Roles and has the role Internal

Data Fields

Within your Cognito Form you can select any of the available data field types to capture the information on your Application Form which you wish to import into your database.

It is simply a case of choosing the right type of Data field to capture the information you need.

In the example above you can see a Data field labelled Mobile. It is a  Phone type field within Cognito forms and allows applicants to enter telephone numbers.

Back to Top

Copying Fields

Having made a copy of the Resource Form to use as your Application form, you may wish to copy or repeat fields within the form. Copying a field is very simple.
Essentially the steps are:
i) Select the field you wish to copy, and choose COPY from the toolbar.
ii) Click on the [ +    ] in the form where you wish to add your field, and choose PASTE

VIDEO:  There is a video showing how to copy fields on your Application form  available HERE

Back to Top

Fields you may wish to Edit in the Resource Form

The Resource Form provides a good starting point for making your own Application Form. However some of the Data fields within the form will need to be amended to match your particular Influence database and these are described below.

ROLE CODES

The Resource form contains a section relating to ROLE CODES. These use a Choice field to provide the selection of roles for the applicant.

Calculation Field(s)
="[[CAND_POSITION]]" for the Current Position
="[[CAND_JOB_CODE_X]]" for each of the 10 'Sought' Roles  (replace X with 1-10)

Data Field
This needs to be a Choice Type field. When setting the choices they need to match the Description of the Roles within your Influence Database. (See below)

Extra choices can be added by Clicking the + and unwanted choices removed with the bin.

You can watch a video here for an example of setting the ROLE CODES.

Back to Top

Forename, Surname and 'AKA'

The Personal Details section of the Resource Form contains various fields such as Title, Forename, Surname, Aka etc. These are uploaded into the Influence database when the application is imported.

Calculation Field(s)
="[[CAND_FORENAME]]" for the Candidate Forename
="[[CAND_SURNAME]]"  for the Candidate Surname

="[[CMC_CONT_USR_ALPHA_2]]" for the Candidate 'Aka' field (available from release 1.00.23.307). 

Data Field
The field type for these is a TextBox - The Forename/Surname text boxes have been specially configured to split the name correctly, etc.

Back to Top

Date of Birth

This allows applicants to upload their date of birth.  This uses a Choice field to provide the selection of roles for the applicant.

Calculation Field(s)
="[[CAND_DOB]]"    for the Candidate Date of Birth

Data Field

The field type for these is a Date field. The field can be made mandatory (if required) by selecting the "Require This field" = Always option.

Back to Top

Personal Details
This section allows applicants to upload their address, phone, mobile and email address. These use a variety of data fields on the form.

Calculation Field(s)
="[[CAND_ADDR]]" the Candidate address details
="[[CAND_PHONE]]" the Candidate phone number
="[[CAND_MOBILE]]" the Candidate mobile number
="[[CAND_EMAIL]]"    the Candidate email address

Data Field(s)
These use a variety of field types;

Address => Address type field
Telephone/Mobile => Phone type field
Email => Email type field

(See below for example of the [Personal Details] section of the Resource Form.)

Back to Top

Payroll Details
This section lets applicants upload details related to their Nationality, NI Number, Bank Account, etc. This uses Textbox data fields on the form.

Calculation Field(s)
="[[CAND_NAT_INS]]" the Candidate NI Number
="[[CTD_BANK_AC_NO]]"    the Candidate bank account No.  (* see below)
="[[CAND_PRO_REF]]"    A Professional ID No. for the candidate (as seen on the Personal page of their record in Influence)

*  You will notice that this calculation field starts differently, and begins "CTD" - This is because the information from this field writes into the Company Trade Details file in Influence rather than the Candidate File.

Data Field(s)
These all use the Textbox field type; for the Bank Sort Code field we suggest using a textbox with a custom input mask, set to ##-##-## to force the correct input.

Back to Top

Proof of ID & Security

This section of the Resource Form is linked to Compliance Items and allows applicants to upload documents, dates and reference numbers. Because each Influence database has their compliance setup differently, you will need to Amend and edit the Calculation fields and possible the Data fields to match your database.

Calculation Field(s)
="[[CMPL_????_QUAL_REF]]" Reference No. for this compliance item
="[[CMPL_????_QUAL_DATE]]" Start date for this compliance item
="[[CMPL_????_EXPIRY_DATE]]"    Expiry date for this compliance item

In all cases the ???? should be replaced with the Compliance Code taken from your Influence database (Maintenance > Setup > Compliance Setup)

Data Field(s)
Reference No's use the Textbox field type;
Start Date/Expiry Date use the Date type fields

Back to Top

Photo

It is possible to allow the user to upload a picture of themselves. This will be stored and displayed on the [Personal] tab of their record within your Influence database.

Calculation Field(s)
="[[DOC_CAND_PHOTO]]"    used to indicate a document/file containing the photo

Data Field
You must use a Document Upload field.
When using this type of field on your Cognito form it is possible to restrict the file types which are allowed. In this case you should restrict the types to *.jpg, *.bmp, *.jpeg or *.tif  (Other types of images will not be processed or imported into your Influence database)

When completing the application form users will be told if they try to upload a dis-allowed file type. (See above)

Back to Top

Attributes (Skills)

As part of the application form it is possible to allow users to select and upload attributes (skills) which match to those stored within your Influence database. As part of the application they can select a level or N/A (not applicable)

In this case the Calculation field will need to be edited to match the Attributes which exist in your Influence database.

Calculation Field(s)
="[[CAND_*ATTRIBS_????,CAND_*ATTRIBS_????]]"   

In this case, the calculation field can contain lots of tags for each Attribute you wish to capture. The ???? should be replaced with the Short Code for the Attribute.

You can see the Short codes in your Influence database from Maintenance > Setup > Attribute Maintenance (See Below)  

Data Field(s)
You should use a Rating Scale type field within your Application Form to capture the Attributes which applicants may posses. If you wish to capture the Weight of the attribute then setup the Rating Scale field to use a Scale of 1 to 5.

 If you simply wish to capture a Tick for the attribute then setup the Rating Scale field to use a Custom Scale with ratings of Yes/No  (See below)

Example of a Weighting (Wt) In Influence (See below)

VIDEO:   There is a video showing how to capture attributes on your Application form  available HERE

Back to Top

Documents (CV, Compliance Items, Candidate Docs)

It is possible to capture documents within the Application Form. These documents can be things such as the applicant CV, Compliance documents or general documents which can be seen on the [Docs] tab of the candidate record in your Influence database.

Calculation Field(s)
="[[DOC_CAND_CV]]" used to indicate a document/file with the applicant CV
="[[DOC_CAND]]" used to indicate a general document/file to store on [Docs] Tab
="[[DOC_CMPL_????]]"   used to indicate a document/file linked to a compliance item.

The ???? should be replaced with the relevant code for the compliance item.

Data Field(s)
You must use a  File Upload field.
When using this field type you can specify the file_types allowed (e.g *.doc, *.docx, *.pdf) and also the maximum number of files allowed.

Back to Top

Work History

Work History and Previous employment can be captured as part of the on-line Application form. On the Resource Form these fields are inside a Repeating Section which means that applicants can submit these items multiple times to cater for each position they have held historically.

You can find out more about Repeating Sections by consulting the Cognito Forms documentation.

Calculation Field(s)
="[[HIST_EMPLOYER]]" used to record the previous employer name
="[[HIST_START_DATE]]" used to record the previous employment Start Date
="[[HIST_END_DATE]]" used to record the previous employment End Date
="[[HIST_DESC]]" used to record a (brief) description of the previous employment.
="[[HIST_ROLE]]" used to record the ROLE CODE for this employment.
="[[HIST_EXP_CODE]]"   used to record the 'Type' of this employment.

Data Field(s)
You should use a combination of
Textbox fields to Record Employer/Description.
Date type fields to start/end dates.
Choice fields for Role Codes

Back to Top

Compliance Items

The Compliance items seen on the [Compliance] tab of the candidate record can be captured as part of your FORM.

As well as uploading documents you can ask applicants to record the Expiry date, reference number and 'Stage' for Compliance items.

="[[DOC_CMPL_????]]"   used to indicate a document/file linked to a compliance item.

="[[CMPL_????_QUAL_DATE]]"    The start/issue date for the item.
="[[CMPL_????_EXPIRY_DATE]]" The expiry date of the item.
="[[CMPL_????_QUAL_REF]]" The Reference No. of the item.
="[[CMPL_????_STAGE]]"   used to capture the 'Stage' for the item. * 
="[[CMPL_????_STAGE_DATE]]"   The date that this 'Stage' occurred.

The ???? should be replaced with the relevant code for the compliance item, e.g. DBS, DRIV, RTW, etc.

* The STAGE field should be followed by a "Choice Box" in Cognito containing choice which match the description of the stages in Influence in order to capture the data.

Back to Top

References

Usefully it is possible to obtain and import referee details and references as part of the Application form. Once again this is part of a Repeating Section.

You can find out more about Repeating Sections by consulting the Cognito Forms documentation.

Calculation Field(s)
="[[REF_FORENAME]]" used to record the Referee Forename
="[[REF_SURNAME]]" used to record the Referee Surname
="[[REF_ROLE_DESC]]" Used to record ????????
="[[REF_PHONE]]" used for the Referee phone number
="[[REF_EMAIL]]"   used for the Referee email address

="[[CAND_REF_REL"&ItemNumber&"]]" this captures the Relationship with the Referee as seen on the [Personal] tab of the candidate record in Influence.
="[[CAND_REF_TYPE"&ItemNumber&"]]" this captures the Reference Type  as seen on the [Personal] tab of the candidate record in Influence.

(IF not using a repeated section, the reference relationship/type calculation fields will be as follows: 

="[[CAND_REF_REL1]]" and ="[[CAND_REF_TYPE1]]" for reference 1. 

Reference 2 should include ="[[CAND_REF_REL2]]" and ="[[CAND_REF_TYPE2]]" etc... )

In both instances the &ItemNumber& is necessary so that it knows which referee to apply these to, based on the repeating section.  (See below for example)

Data Field(s)
You should use a combination of;
Textbox fields to Record Employer/Description
Phone Number fields to store the Referee phone/mobile
Email fields to capture the Referee email address
Choice type fields to capture the Referee Relationship/Type - In these cases the Choices as seen the the left should match the Selections in your Influence database (See below)

Back to Top

Policy Management

If you are using the Policy Manager within Influence, it is possible to get applicants indicate that they have subscribed to items such as your Privacy policy etc., and bring those responses into your Influence database. 

Calculation Field(s)
="[[PM_????]]"    used to record if the applicant has subscribed to the policy (or not)

In this case ???? needs to be replaced with the POLICY code from your Influence database, and must be a published policy.

Within your database you can find these codes from Maintenance > Tools > Policy Manager, then filter for only Published policies.

Data Field(s)
You should use a Yes/No field to record the response

(An example is shown below)

Back to Top

Adding a New Field to Your Application Form (That isn't part of the demo Resource Form)

Almost any field which exists as part of the candidate record (and associated Company Trade Details file) in your Influence database can be captured as part of your Application Form. Whilst our Resource Form gives examples of many of the most common, any field can be captured if you know the field name within Influence.

VIDEO:   Video showing how to Add a New Calculation field to your Application form  available HERE

Finding the field name and adding it to your Form can be done as below:

i) Login to your Influence database with the UserID "ADM" and navigate to Maintenance > Database Management > Table Maintenance.

ii) Expand the tables list and find the relevant table (usually Candidates or Company Trade Details) and double-click to see a list of fields.

iii) Scroll down to the relevant field and make a note of the field name.

In the example above the field Nearest Station has the field name NR_STAT

Next, open your Application Form within Cognito Forms and proceed to add the calculation field and the relevant Data field.

iv) Within your Form scroll to the section where you wish to add the new field and click the [   +   ] to add a new field. Choose the field type as Calculation

v) Set the calculation as ="[[CAND_XXXXXX]]" where XXXXXX should be replaced with the field name you noted earlier.
i.e. ="[[CAND_NR_STAT]]

Remember to Show this Field For Roles  and to set the role as Internal.

vi) Finally, to capture the actual data, click the [  +  ] and add a Data field of the relevant type. (In this case we will use a Textbox type field to capture the nearest station.)

VIDEO:   There is a video showing how to Add a New Calculation field to your Application form  available HERE

Back to Top

Form Submission - Recipients and Subject

Step 1

Go to the bottom of the form and click Workflow. Make sure to turn ON the option for Workflow Link Sharing

Step 2

Click the Submit  button at the bottom of the Form.
Find the Send Emails  option and click on the email

Once the [Email for Submit Action] opens, you will need to make the following checks/changes.

Under the Include section tick all the options.  (Entry Details / Org & Form Name / Blank fields). Same for the Attach section. (Uploaded Files / Documents )

Finally click SAVE to store the setup for your [Submit] email.

For more information about submission settings within Cognito, see the Cognito online documentation.

VIDEO:  There is a video of the process available showing how to amend the submission settings HERE

Important

When editing the Submission Email  settings you should leave the hyperlink  part of the message. It is this that is used by Influence populate the [Social Net 2] field with a link to open the original entry details for this applicant.

See below: 

i.e. In the example below, the field is only populated because the Notification email from Cognito contained the relevant hyperlink.

Back to Top

Attachments (26)

sVaTPVSfSWH4....png
62.6 KB

Fe6y0he77oxj....png
64.5 KB

lgfBZ7zlfbsX....png
20.2 KB

3fJf8xhrTNL8....png
9.42 KB

YbunJx41XtsQ....png
33.8 KB

2keU6cZe7jol....png
45.1 KB

522yq9EqAkbz....png
66.3 KB

5oNoQzi55Ji8....png
78 KB

h78SzWsmErbL....png
39.8 KB

wKE3djyEpOmu....png
58.6 KB

7tMYix5BANPX....png
21 KB

ADliCBKqdY5o....png
38.7 KB

HughMaL8V8tG....png
50.4 KB

dHFpIDtEsVqw....png
23.6 KB

8WreNFf2cSJN....png
6.65 KB

pPlbDXavqNGO....png
40.9 KB

zyHKhqjpyjZh....png
57.6 KB

6pvworwHfurW....png
103 KB

T3BY4noCQYH7....png
67.7 KB

PpWYT1VDO2A0....png
83.2 KB

RZjZOmcxkrN0....png
35.8 KB

9gceTBLKq0we....png
22.2 KB

1ijlrY3Ha4zL....png
17.4 KB

mmPP5VdWTbKX....png
32.1 KB

RpMvTKxMJyIt....png
60.9 KB

HNTR9WdkIBmM....png
75.7 KB