Device Language & Numeric Fields

Device Language & Numeric Fields

Depending on your region or device language set, the Numeric Field will capture decimal values separated by a point (.) or a comma (,).

If the numeric field’s value is needed in calculations, you must ensure the separator is a point (.). This can be achieved by either setting the device’s language to one that uses a point to separate numeric decimal values or by replacing the comma with a point using a formula function in the form.

Replacing a character with another in a form can be achieved using one of the following formula functions.

FunctionExample
SUBSTITUTE({{val}}, 'old_text' , 'new_text')Substitute new_text for old_text into the given value.

e.g., if a field has a value of ‘3,6’, then:

SUBSTITUTE({{myfield}}, ',', '.')

replaces a comma with a point.
REPLACE({{val}}, 'old_text' , 'new_text')Replace the text matched with the text specified in the replacement string.

e.g. REPLACE({{input}}, ',', '.')

This function is generally used to replace Regular Expressions, but it can achieve the same result as SUBSTITUTE().

    • Related Articles

    • Controlling Required Fields

      The standard Required and Read Only option on the Form designer lets you define fields that are always required or read only respectively. However sometimes you need to make a field required or read only based on the answer(s) to a previous field. ...

    • RFID Scanning with Zebra Device

      We have long facilitated barcode scanning with external scanners from Zebra. More recently, we have expanded our capabilities to include RFID scanning by integrating support for Zebra devices. Currently, our ability to support RFID scans with Zebra ...

    • Showing and Hiding Fields (Visibility)

      There are many situations where you may want to show/hide fields (or even whole pages) based on the answer to a previous question. For example, say we have a Choices field that asks "Do you see any hazards?", with the options of Yes or No. Now if the ...

    • Conditionally Required Fields (Required Condition)

      The standard Required and Read Only option on the Form designer lets you define fields that are always required or read-only respectively. However, sometimes you need to make a field required or read only based on the answer(s) to a previous field. ...

    • Multi-Language Options

      ur platform offers multi-language options in the app, when designing forms, and on the web portal. The app offers a set of default languages to choose from, which are the static text displayed when you log in to the app. The same applies to a form’s ...