Workbooks offers a licenced module to allow for the management of Events. Whilst a customisable portal is available as part of the module, if you prefer, you can continue to use your own web forms on your website, and still benefit from the full suite of features such as integrations with GoToWebinar or ON24 and a wealth of marketing automation capabilities via GatorMail.

By using our stand-alone script, you have the ability to capture custom questions on a form during signup and/or map the data to any of the following record types in Workbooks:

• People
• Organisations
• Mailing List Members (Event Attendees)
• Events
• Event Products
• Event Tickets
• Orders & Order Line Items
• Invoices

You can use any method you like to push the data to Workbooks, however, the submission must create an Online Activity and store the data submitted in the Form Submissions Data field. The data must be stored in JSON format. There are 3 methods that we would recommend to achieve this:

• Use a GatorMail Smart Form embedded into a Public Landing Page or webpage or within your site
• Use Workbooks Web2Lead HTML embedded into a page on your website
• Use a custom form on your website, with an HTTP POST request to the Workbooks API endpoint "crm/web_leads"

The above methods all automatically create the Online Activity in the correct format for this process. This example covers how to configure a GatorMail Smart Form.

Step 1: Create a Gator SmartForm Template

Within GatorMail, configure a new Smart Form as per the instructions here. We'd recommend that you configure a template Smart Form that can be copied for each Event that you wish to run. This means that you will only need to add the Workbooks Event Id to GatorMail, rather than starting from scratch each time.

As part of the initial configuration, setup a new Contact Attribute for EventId as the Text data type from Audience > Contact Fields.

Within the Smart Form configuration, add the EventId to the form, then configure the options of that field so that "Is Hidden" = TRUE.

Configure the Smart Form's other options to suit your needs. Save it with a sensible name so you can find it later - we'd recommend prepending the text "TEMPLATE" to your name. Any templates created, can then be stored within a specific folder in GatorMail.

Step 2: Create Workbooks Configuration

Workbooks can be configured with relative ease using our Script Library plugins, alongside some manual configuration. Complete the steps below.

• Raise a Case with Workbooks Support to enable synchronisation of the Form Data Submission field
  • The functionality to synchronise the form submission data to Online Activities is switched off by default. When raising a case with the team, provide the name of your Gator Instance you wish to enable the functionality for and also the setting name to have switched on. The setting is called "Integration Smart Form Submission Data Required" and "Smart form JSON integration".

• From Reports > Create Report from a Template Report. Use the Template called "TEMPLATE - Online Activities created via Form Submissions".
  • Save the Report with a sensible name - it will be needed later.

• From Configuration > Automation > Plugins, install two Plugins:
  • Event Management
    • NOTE: You are only required to complete the installation to Step 4 if using your own forms. This schedules the creation of necessary Custom Fields within Events. Once you have completed this step, you can close the Plugin without completing the remaining steps.
  • Form Submission to Event Attendees
    • All steps must be completed fully.

• Now that we've installed the Plugins, and created Custom Fields (NOTE: you may have to wait a few minutes for the field to become available before you can complete this step):
  • Add additional criteria to the Report
    • Processed = FALSE: This ensures that only new Form Submissions are processed since the last time the script ran.
    • Tweak the Report Criteria called "Action" to include the name of your Smart Form from GatorMail.  NOTE: Use contains, instead of equals here, as GatorMail prepends a hardcoded value to all Smart Form submissions.

Step 3: Setup Form Field Mappings

Within Workbooks, mappings can be created to specify where the data submitted from your Gator Smart Form will be stored in Workbooks. By default, there are 3 required Field mappings that should be created. From the Event Registration Field Mappings record type (created by installing the Plugin in Step 2 and available in the start menu), create new records as follows for each field mapping:

Additional field mappings can be created as required following the same process as above. The fields that can be set on each mapping are explained in the below table:

Step 4: Setup Event-specific Smart Form

Now that we have configured a template Smart Form, and setup Workbooks - the functionality can be used to configure an Event specific form in just a few clicks. 

Firstly, create an Event record in Workbooks. From the Information button on the record you created, copy the Id.

In GatorMail, setup a new Smart Form. Choose the Form that was created in Step 1, in the Copy Existing option:

Under the Default Values tab of the EventId field, set the value to the Workbooks Event Id:

Click Save & Close on the field, and then on the form. The Smart Form can then be added to a Public Landing Page, or embedded into your website.

Step 5: Submitting a Form

When a form is submitted, an Online Activity is created. The record will be related to a Person if they exist in your database already, or a new Lead will be created if no match was found.

NOTE: It can take up to 30 minutes for an Online Activity to sync to Workbooks from GatorMail.

The Online Activity will be processed automatically, resulting in several records either being created or updated as per the table below: