Number Fields

The Number field type category includes the five field types pictured below. These field types are primarily used for generating automatic values as well as basic and complex calculations.

This article will define each of the five Number Field types.

Number

Number fields store basic number values, such as quantities, grades, or scores.

Sample number field:

Creating a Number Field

To add a new Number Field to your data table, click on the Fields menu item and then on the Number field type category. Select the Number Field field type from the drop-down list.

When creating a Number Field, there are several settings you can customize such as those highlighted in the image below.

1. Name- this is where you can name your Number Field. For instance, "Quantity" or "Grade".
   
   
2. Description- this is where you can provide a brief description of your Number Field for your own reference. 
   
   
3. Decimal Places- this is where you can define how many digits you wish to appear after the decimal within your number values. Decimal Places can be configured to show up to 10 digits.
   
   
   
   If None or 0 is selected, your number values will display as whole digits. By default the decimal place setting for basic number values is set to None which means that basic number values are displayed as whole digits. 
   
   

   Note: If the decimal place is set to default, basic number values will always store and display as whole digits, even for those basic number values submitted on forms with digits following the decimal point.
   If you wish for your app to store and display basic number values with the digits following the decimal point, you must change the decimal places setting to 1 or higher.

   
   The amount of digits you select to appear after the decimal place affects how your number values will be rounded and stored in your application. For instance, say you change the decimal place setting to display 1 digit after the decimal and the following number value is submitted within a form:
   
   
   
   With your decimal place configuration of 1 digit, the number value of "1.15" will appear and be stored as rounded to the nearest 1 decimal place:
   
   
   
   If you were to update your decimal place setting to display 2 digits after the decimal, the number value of "1.15" submitted on the form will remain the same and will not be rounded when stored and displayed within your application: 
   
   
   
   
4. Thousands Delimiter- this is where you can define which character you wish to use as a thousands delimiter to separate groups of thousands when viewing your number values. This setting does not affect how the values appear in forms. At default, the thousands delimiter is set to None, meaning your number values will display with no thousands delimiter at default and will display as such:
   
   
   
   If you wish to change your thousands delimiter setting and choose a delimiter character, you can choose either a comma, period, or space character to separate groups of thousands within your number values. 
   
   This is how your number values will display if you change your thousands delimiter setting to Comma:
   
   
   
   This is how your number values will display if you change your thousands delimiter setting to Period:
   
   
   
   This is how your number values will display if you change your thousands delimiter setting to Space:
   
   
   
   
5. Unique- this is where you can define whether each number value must be unique. 
   
   
6. Placeholder- this is where you can enter placeholder text to automatically populate within this field's box on a form when the form loads. Placeholders can be useful for providing instructions, such as "Please enter quantity here." When a user begins to type within the field box, the placeholder text will disappear and be overwritten. 
   
   
7. Default Form Value- this is where you can enter a default number value that will automatically populate within this field's box on a form when the form loads. For the Number field, only digits can be set for this value.

Currency

Currency Fields are designed to store monetary values.

Sample Currency Field:

Creating a Currency Field

To add a new Currency Field to your data table, click on the Fields menu item and then on the Number field type category. Select the Currency Field field type from the drop-down list.

1. Name- this is where you can name your Currency Field. For instance, "Cost" or "Retail Price".
   
   
2. Description- this is where you can optionally provide a brief description of this Currency Field for your own reference.
   
   
3. Currency Type- this is where you can define the type of currency you need to store, such as "$- USD" or "€- EURO". By default the currency type is set to "$- USD".
   
   

   You can change the currency type by clicking on the currency type drop-down arrow and selecting a new currency type. Currently, you can choose from the following list of currency types:

   • AED - United Arab Emirates Dirham - د.إ
   • AUD - Australian Dollar - $
   • BGN - Bulgarian Lev - Лв
   • CAD - Canadian Dollar - $
   • CHF - Swiss Franc - Fr.
   • EUR - Euro - €
   • GBP - Pound Sterling - £
   • GHS - Ghanaian Cedi - GH₵
   • GTQ - Guatemalan Quetzal - Q
   • HRK - Croatian Kuna - kn
   • IDR - Indonesian Rupiah - Rp
   • ILS - Israeli New Shekel - ₪
   • INR - Indian Rupee - ₹
   • JPY - Japanese Yen - ¥
   • MUR - Mauritian Rupee - ₨
   • NZD - New Zealand Dollar - $
   • PGK - Papua New Guinean Kina - K
   • RSD - Serbian Dinar - дин
   • SAR - Saudi Riyal - ر.س
   • TRY - Turkish Lira - ₺
   • USD - US Dollar - $
   • ZAR - South African Rand - R
   To add a currency type that is missing from the list, please select the "Custom" option and enter your own currency symbol.
   
   
4. Format- this is where you can define the location of the currency symbol as it will display within your Currency Field values. By default the currency symbol format is set to Prefix, meaning the currency symbol will be displayed before the currency value as illustrated in the image below.
   
   
   
   You can change the format of your currency symbol location to either None (will not show currency symbol) or Suffix (currency symbol will appear after the currency value).
   
   
5. Thousands Delimiter- this is where you can define which character you wish to use as a thousands delimiter to separate groups of thousands when viewing your currency values. By default the thousands delimiter setting for Currency Fields is set to None, meaning your currency values will display with no thousands delimiter at default and will display as such:
   
   
   
   If you wish to change your thousands delimiter setting and choose a delimiter character, you can choose either a comma, period, or space character to separate groups of thousands within your currency values. 
   
   For instance, this is how your currency values will display if you change your thousands delimiter setting to Comma:
   
   
   
   
6. Decimal Places- this is where you can define how many digits you wish to appear after the decimal within your currency values. By default the currency decimal place setting is set to 2. This means that by default there will be 2 digits displayed after the decimal within your currency values. 
   
   Note: The decimal place setting will affect how your currency values will appear and be stored within your application as rounded values.
   
   For instance, if the decimal place setting remains at the default setting of 2 and a currency value is entered as "99.999", the resulting currency value will appear and be stored as as a rounded value of "$100":
   
   
   
   Alternatively, if the decimal place setting remains at the default setting of 2 and a currency value is entered as "99.99", the resulting currency value will remain as it was entered and will not be rounded:
   
   
   
   If the decimal place setting is changed to 0 and a currency value of "99.99" is entered, the currency value will appear and be stored as a rounded number with no decimal:
   
   
   
   
7. Placeholder- this is where you can enter placeholder text to automatically populate within this field's box on a form when the form loads. Placeholders can be useful for providing instructions, such as "Please enter currency here." When a user begins to type within the field box, the placeholder text will disappear and be overwritten. 
   
   
8. Default Form Value- this is where you can enter a default currency value that will automatically populate within this field's box on a form when the form loads. You may only use digits to create the default form value for a Currency Field. 

Auto Increment

As of 01/15/2024 - the Auto Increment field has been removed from the Fields menu and replaced with a system default auto ID field. Please see the link below for more information:

Important changes made to the Auto Increment fields

Rating

The Rating Field enables users to rate your field using custom icons. 

For instance, if you have an Applicant Tracking System application, you can create a Rating Field for interviewers/HR to rate applicants. 

To create a new Rating Field, click on the Fields menu item and then on the Number field type category. Select the Rating Field field type from the drop-down list..

1. Name- this is where you can name your rating field. For instance, "Applicant Rating" or "Service Rating".
   
   
2. Description- this is where you can optionally provide a brief description of this field for your own reference.
   
   
3. Number of Stars- this is where you can select the number of stars (or other selected icon) to display as your rating scale. By default the Number of Stars is set to 5, meaning five stars will display on the rating scale by default. 
   
   
   
   
   
   If you would like to change the number of stars to display as your rating scale, you can choose from other common rating scale options including 3, 4, and 10.
   
   For instance, if you would like to prompt customers to rate your services on a scale of 1-10, you would select the number 10 as the number of stars to display as your rating scale.
   
   
   
   
4. Enable Reset- this is where you choose whether or not you would like to enable users to clear their rating selections within a form. By default the Enable Reset setting is set to Yes, meaning rating fields on a form will automatically include a button that when clicked will clear the rating selection.
   
   
   
   To remove this clear button, you must change the Enable Reset setting to "No".
   
   
5. Default Icon- By default, Rating Fields use the filled star (⭐) icon to rate fields. If you wish to change the rating icon, you can select an alternative icon from the list or click on the Custom button to select a custom icon.
   
   
    
6. Icon Colors- This is where you can select the icon color that will display with rating selections. If no color is selected, the default Black color will be used to display rating selections. 
   
   
   
   
7. Add New Color Rule- Click the Add New Color Rule button to create rules to display specific icons and colors based on the rating value selected. 
   
   

 

Slider fields enable you to select a numeric value using a slider between two number ranges. You can choose any minimum and maximum values for both ends of your slider range. 

You can use a Slider Field for a variety of reasons, such as to prompt users to select a rating out of custom min/max numeric values, to prompt users to select a progress/status value out of custom min/max numeric values, or to prompt users to select a numeric value for any purpose such as selecting a quantity, grade, or score.

For instance, you can prompt HR to rate applicants during an interview providing custom-defined minimum and maximum rating values. 

 

As another example, you can use the Slider Field to prompt employees to assign a progress value to the tasks they are working on with custom-defined min/max values. 



When you create your components within the Page Builder, you can customize how the Slider Field results will display within components after they are submitted via a form. For instance, when adding the slider field to a table component, you can customize how the results will display with custom colors and format styles as illustrated in the GIF below.

 

Additionally, within the table component settings you can click on the Add New Color Rule button to create rules to display specifi colors when specific conditions are met. For instance, you can create a rule to display the progress bar in Green when the task progress is updated to a numeric value of 100.

Click here to learn more about customizing slider field display options within table components. 

 

To create a new Slider Field, click on the Number category on the Add Field menu and select the Slider field type.

When creating a new Slider Field, there are several settings you can customize such as those highlighted in the image below.

1. Name- this is where you can name your Slider Field. For instance, "Progress Bar" or "Rating Slider".
   
   
2. Description- this is where you can optionally provide a brief description of this field for your own reference.
   
   
3. Value- This is where you can define the minimum and maximum values to display on either side of your slider range. If no minimum value is set, the number zero will display by default. There is no limit to the maximum value you can set. 
   
   
4. Default Form Value- this is where you can enter a default numeric value to automatically populate within a form for your Slider Field. For instance, if you enter a Default Form Value of "2", forms will automatically load with the slider set to the numeric value of 2. 
   
   
   
   At default, the Default Form Value for Slider Fields is blank, meaning sliders will not be automatically set to a specific number when the form loads.