The first iTWO cx release for 2022 introduces further enhancements for our platform, headlined by newly refined dashboards for users to get excited about. These new dashboards have been informed by client feedback, making it easier than ever for users to display data the way they want.

We have also improved our modern forms designer and added a new user field that supports a wide variety of handy calculations.

All these features and more are explored below.

Modern Form Designer

We continue to add new features to the modern form designer as we get close to transitioning forms from the old forms editor to the new one.

Features added in this release include

Updated Addressbook

Support for additional user fields

• GPS
• Budget Link
• Bidder List
• Signature

Support for importing data from the clipboard into the list control

Control notifications on a form (Interface update)

Updated User Interface for Document List and Attachment List User Fields

Standard iTWO cx Styles to format your forms quicker

Calculation User Field

In this release, we are introducing a new type of user field that will allow you to perform simple calculations based on the user fields on a list control. We are calling it the calculation user field. We believe it will help you supercharge your forms.

Configuration of the Calculation User Field

To get started, add a calculation user field to your form.

For the calculation user fields, we have a special tab called calculations.

Go to the calculations tab.

On this tab select the list control that you wish to run your calculations on.

Pick the field you wish to run calculations on

Select the criteria applicable to the user field type you have selected

Select the display style you wish to show the result of this calculation.

Supported Calculations for Different User Fields

Below is a table detailing

• the user fields supported
• the applicable criteria for each user field type
• the applicable Display as types for each criterion

Number / Currency User Fields

Select / Radio / Checkbox / Cascading

Example

Widget - Average of user field 

We have also introduced a new option for count widgets where you are able to report on the average of a calculation user field across multiple forms.

In the Display as option pick average of user field

Then pick from the available calculation user fields.

In this example, we have 3 forms with the Checked Percentage user field populated.

As the configuration is to show the average of these 3 forms for the Checked Y User field

The calculation will be (80 + 80 + 40) / 3 = 66.67 %

Widget - % of Total Forms

With this percentage of total forms option for a count widget, you can calculate as a percentage the number of forms out of your total number of forms,  based on your widget criteria

In the Display as pick - % of total forms

Then provide your criteria in the query builder

In the example below, we are looking for the total number of closed forms as a percentage of the total number of forms.

As there is only 1 closed-form out of 3 total forms our calculation is (1/3) x 100% = 33.33 %

Creating Polygons on a Dashboard

In this release, we are introducing the ability for users to create shaded shapes on our map view which can then be linked to one or more forms. This feature will greatly benefit the Quality and Defects processes as you will be able to visually create areas for your inspections as well as your defect walkthroughs.

What are Polygons?

A polygon is a shaded/coloured area on the map that can be linked to a form.

• To create a polygon on a map you must first add a GPS user field to the form type you wish to represent on the map.
• To do this go to the user field config area of the form you wish to edit
• Add a GPS field
• Select the mode of Polygon
• Pick the colour that you wish to use for the polygon that you create and you are set.

To start creating polygons you must go to your dashboard, and then add a count widget with the polygon form types you wish to associate with that widget.

To ensure the map view is loaded when clicking on this widget you can customise the default view for this widget to be the map view

Creating Polygons

To create a polygon, go to the map view on a dashboard, then click on the add polygon button.

Then click on the map to draw your polygon point by point and then double click at the end to complete drawing the polygon

Linking a form to a Polygon

Once a polygon is drawn you can click on the create form button to create a new form and link the form to the polygon

On the screen that appears for you to create a new form, you will see all the form types that have a GPS user field configured with the Polygon mode. 

Pick a form type from this list, fill in the details and submit the form.

The polygon will be created with a link to the form.

View a form linked to a Polygon

To view the form linked to the polygon click on the pill in the centre of the polygon, then click on the view button

Edit a Polygon

To edit a polygon click on the edit icon on the on hover screen

This will turn the points of the polygon into its editable state. You can then drag around the points to reshape/resize the polygon as required. And then simply click anywhere on the screen to save the changes.

Creating another form to link to an existing polygon

To create and link another form against an existing polygon click on the hover tool and then click on the + icon.

Associating existing forms to a polygon

To link exiting forms of the same type already linked to a polygon, click on the link icon on the hover screen.

This will load up the associate screen, pre-filtered to the form type already linked to the polygon. In this example, it is prefiltered to the Services form type.

From here you can do a keyword search to find the forms you wish to link. 

Select the relevant forms and then click done.

Deleting a Polygons

To delete a polygon click on the delete icon on the hover screen and follow the prompts.

Note that deleting the polygon will not delete the forms you created against the polygon.

Filtering the Map by Polygons

You can filter your map view by the polygon form types you've configured against your widget.

To filter your map view click on the status filter

Filter by polygon form type and its status. Then click done to update the map.

Graph Widget Improvements

We have upgraded our graph widgets with a number of new configurable options. Details below.

Sorting graph charts

For graph widgets related to user fields, you can sort the chart using these options

• Ascending (by result count)
• Descending (by result count)
• A-Z (with this option the chart will be sorted using the value name)
• Z-A (with this option the chart will be sorted using the value name)

When you pick a sorting option (ascending, descending) you can pick whether you wish to sort the chart by 

• total number of records
• open records
• closed records

Cumulative graphs

Graphs that are represented over a time period can now be shown as a cumulative chart.

These charts can also be shown as a line or bar chart

Display data by code, descriptions or both

You can configure how the data in the charts are displayed. You can choose to display the data with

• Code
• Description
• Both

Display more than 10 items on a graph

Graph widgets can now be configured as a full-width widget

And they display more than 10 options in the chart

Chart type

Bar Chart or Line Chart

You can also display various charts as either a bar chart or a line chart.

Bar charts can also be configured as

• Bar Chart stacked
• Bar Chart next to each other

In a stacked bar chart the open and closed forms will display in a single bar which is stacked

In a bar chart where the data is next to each other the open and closed forms will be displayed as 2 bars.

Action Button Workflow Improvements

We are always working on improving our workflows to offer our users the best possible experience when using our forms to map out your processes. In this release, we are adding a number of key changes to improve action buttons.

Change Info user

You can now configure an action button to update the info user of a form. 

You can update the info using

• Contact user field
• Mapping user field
• Or a specific user

Change due date

Similar to the above you can also configure the action button to update the due date of a form and move it forward by however many days as desired

Bulk Apply Action Buttons

With this release, you can now bulk apply an action button to multiple forms using a

• A Saved Search
• Dashboards

Bulk Apply Action buttons using a saved search

To apply an action button in bulk via a saved search you first need to add the tickbox column to the saved search

Then select the forms you wish to apply the bulk action button to