Datasets

Create separate datasets, that help you track and report on custom fields in their own database i.e. datasets of cars, dogs or even working with children checks. All data is also linked to a membership application.

Note: Datasets are an optional add-on, if you can't see them on your site and want to find out more, please raise a support ticket here.

Setup Datasets

To create your new datasets go the Membership Tab > Settings in the Left Menu and click "Datasets"
Click the "Add Datasets" button

Give your Dataset a Name and click "Save Name"

Building Datasets Fields Using Form Builder

Start adding fields to your datasets using the same form builder as the Membership Form by clicking "Add Field"

ICONS MEANINGS TO EDIT, HIDE, REORDER AND DELETE FIELDS

rtaImage (99) Allows you to re-order your fields. Click on the arrow next to the field you wish to move and drag it to the place in the form you would like it to be.
rtaImage (100) The eye allows you to show and hide fields in your membership form administration area to make it easier to view. It simply hides the input or option fields.
rtaImage - 2020-08-25T110959.159 This shows that the input or option fields are currently hidden in the membership form administration area. Click the icon to open the fields out. This has no impact on the live website.
rtaImage - 2020-08-25T111014.729 This allows you to inactivate the fields. This icon means that this field is currently active on your membership form. Click on this icon to deactivate the field.
rtaImage - 2020-08-25T111030.687 This allows you to activate the fields. This icon means that this field is currently inactive on your membership form. Click on this icon to activate the field.
rtaImage - 2020-08-25T111102.560

This icon allows you to edit the field properties.

rtaImage - 2020-08-25T111116.856 This icon allows you to delete the field. NOTE: This will delete all data that has ever been stored in this field plus remove the field from current application forms.
This image appearing beside the field Label Name will show if the field is required, to edit this status click on the edit icon.

This image appearing beside the field Label Name will show if the field is currently inactive on the live site. To activate click on the red inactive square icon on the right hand side of the field (pictured above).

scrnli_26_07_2021_19-18-33

 

The Access Controls icon indicates that the field has some restrictions set for access and visibility for members. To view the settings, hover over this icon. To edit the access controls, click edit on the field and review/edit the settings accordingly.

ADDING A NEW FIELD

To add a new field click on the green “Add Field” Button located at the top left hand side of your form.

scrnli_26_07_2021_19-11-56

  • Select which Field Type you require from the dropdown box (see below for more information on field types).
  • Field Label: This is the name of your field that will appear on the form. It has a limited number of characters you can enter. You will need to add a HTML content field if you have a long description.
  • Required: Yes/No – this will determine if the field is compulsory to complete the application.
    Default/Placeholder Text: You can enter some text into this field as a placeholder until the user types in their answer.
  • Field Access: Select from the options as to when the field will be editable/accessible by members (See Restricting Field Access & Visibility for more information)
  • Field Visibility: Select from the options as to when/if the field will be visible to members. (See Restricting Field Access & Visibility for more information)

Once you have completed the form click on the “Add Field” Button at the bottom right of the screen.

The field will be instantly added and live on your membership form.

To edit, delete and re-order fields please see the icon meanings above.

RESTRICTING FIELD ACCESS & VISIBILITY

It is possible to set different restrictions on form fields, depending on what data you require from your members in the sign up and renewal process. 

When you are adding or editing your form fields, you will have the option of setting the field access and the field visibility. These settings will give members access to the fields at various stages.

The explanations of these access settings are as follows:

Field Access

  • Standard: These fields will be shown to members on signup, renewal forms and also are available to be edited at any time by the member.
  • Restricted: Members can set/edit the field at signup & renewal time only. They cannot edit this field in their members area at other times. The member can view the field at all times
  • Locked: Members can view this field at all times, but can not edit the field
  • Admin: Members never see this field. Only viewable & editable by administrators

Field Visibility

  • Standard: Visible the first time a field dataset is added as well as when a member renews

  • Signup: Only visible the first time the field dataset is added by a member

  • Renewal: Only visible on renewal forms. Does not show when first adding the dataset.

Once you have restricted the access to these fields, you will see the restricted access icon display on the field in the membership level. Full details of the restriction settings will be displayed on hover.

EXPLANATION OF FIELD TYPES


  • Checkboxes: This allows you to create a number of different options and let a member tick multiple options. If you select this type it will give you an additional section for you to add your “Field Options”. Type the option name into the input field and click “Add” it will appear in a list below. If you wish to re-order the fields, click on the  arrow located to the left of the field and drag it to where you would like it to be. To delete a field click on the rubbish bin icon on the far right of the field.
  • Date: A simple date field with calendar selector.
  • Email Address: An additional email address typically not associated with the primary member.
  • File Upload: This allows people to upload a file or an image with their membership application. Once you have added this field, you can click on the cog to select if you would like to force a re-upload at renewal.
  • HTML Content: This field type allows you to write content insert links, images etc and is typically used to link to Terms and Conditions of membership, which is located on another page.
  • Horizontal Lines : This is just a visual line that will appear on your form to break up the content.
  • Image Upload: This allows members to upload an image with their allocation.
  • Numeric Input Field: A field that can store a string of numbers.
  • Phone Number: Additional Phone Number.
  • Plain Text Memo Field: This is a field that allows users to input long text answers i.e. descriptions, comments etc.
  • Radio Buttons: This option allows you to create a number of options and ask members to select one. If you select this type it will give you an additional section for you to add your “Field Options”. Type the option name into the input field and click “Add” it will appear in a list below. If you wish to re-order the fields, click on the arrow located to the left of the field and drag it to where you would like it to be. To delete a field click on the rubbish bin icon on the far right of the field.
  • Section Headings: This will allow you to create a heading to format your membership form into easier to read sections.
  • Select Box: This type will allow you to create a dropdown list of options and allow your members to select one from the list. . If you select this type it will give you an additional section for you to add your “Field Options”. Type the option name into the input field and click “Add” it will appear in a list below. If you wish to re-order the fields, click on the arrow located to the left of the field and drag it to where you would like it to be. To delete a field click on the rubbish bin icon on the far right of the field.
  • Text Input Field: This is the basic form field which allows users to enter text information.
  • Time: A time field.
  • Yes/No Radio Buttons: An easy way to add a Yes and No button option which allows members to select one option.

Add Datasets to Membership Forms

To add the datasets to a membership form you will need to go into the selected membership level Membership > Membership Levels > List Levels and click  the Form Fields icon next to the relevant  Membership Level

Click the Add Field Button at the top of the page,

In the Field Type Dropdown at the bottom you will see a sub heading "Datasets"  and all of your datasets below.

Select the Datasets that you wish to add to the form

Give the Field a Label and also select if the field is required by all members. Setting this field will add the datasets to all membership forms, if you unselect required members will have the option to add datasets themselves.

Setting Limits on Datasets

You can now also limit the number of Dataset allowed, to set the default limit click on the edit icon next to the form field 

Screen Shot 2022-02-02 at 2.47.00 pm

You will now see additional properties which allow you to set the default dataset limit and also control the number of datasets that can be added per membership product. Enter the default limit and if required enter the number of datasets i.e. cars allowed for each product in that level (as listed below)

You can also edit and manage the Dataset Limits within the products as well by going to

Membership > Membership Levels > List Levels > Products and entering limits for each dataset

Export Field Data with Membership Information

All custom fields can be exported with membership details via the standard "Export Form Data to CSV". This export will show all demographic information, all form fields and all datasets in separate columns against a member. 

 

Advanced Reporting on Custom Datasets

Click here to read more