When talking about their mobile data capture processes, one of the top challenges our clients mention is optimising data quality or “getting it right first time”. Errors and omissions at point of capture can have huge knock on effects: additional administration, re-working, re-visits and even missed invoices. These result in increased costs, slower service and reduced profits. Paper forms have no way of controlling the data captured and many form applications only offer basic controls. Recognising that data quality is a key driver for our clients, we included a powerful scripting tool within Formworks to give complete flexibility over data validation and form dynamics.

Here are 6 powerful mobile form controls enabled by scripting:

1. Data checks
For example, if a job number has a particular format or if a number or date has to be between a certain range.
2. Setting mandatory or required fields
End users are restricted from submitting forms where they haven’t filled in the required information, eliminating the problem of missing data.
3. Implementing conditional logic 
For example revealing or hiding further questions or directing the user to specific data fields or pages depending on previous answers given. Hiding and revealing sections and pages improves form navigation and makes life easier for the user. Some clients use this function to dynamically change their data capture forms depending on the type of inspection or survey type.
4. Automatically populating fields
For example, auto-populating the time and date that a form is opened or a signature completed. This type of automation reduces the time a user spends filling in a form and improves accuracy.
5. Including calculations
Examples include automatically totalling audit scores based on data collected, totalling order values or even calculating the results of wall fixing pull out tests. These reduce human error and save time doing manual calculations.
6. Searching and retrieving information from local databases or web service look-ups
By linking forms to pricing and product lists stored in local or external databases, users can provide accurate quotes and access product information in real time.

What is the biggest outcome of implementing scripting within mobile forms?

Implementing these controls on mobile forms improves data quality, enabling users to get it right first time. They also speed up data capture by streamlining the process, only showing data fields relevant to the task at hand and automating calculations. In a recent split test by one of our clients, they measured Formworks digital forms against their paper data capture process. The results were undeniable: digital forms vs paper That’s the power of scripting! We work closely with our clients, helping them optimise their forms with appropriate controls and provide all the scripting training and support they need. If you’re interested in a demo or a complimentary trial, sign up here.