The Number Field presents the User with a number input field not limited by decimal places, ideal for use in formulas.
Configuring a new Number Field
To create a new Number Field, you must first be in the 'Fields' section of AppStudio, here you will be able to click the 'Add Field' button in at least one of the highlighted locations below.
This will open the following page where you can scroll down and select the the Number Field tile or search for it in the top right bar:
Once selected you will be presented with the configuration options below:
- Label: Visible in the App above the entry box it makes clear to the user what data is being displayed in the Field.
- Identifier: This should reflect the label. The identifier is a system ID for referencing a Field. This ID must be unique per Field and must contain only letters and numbers starting with a letter. It must also be a minimum of three characters.
- Type: The sort of Field that is being configured - With some types this can be edited in the future providing the data type is cross-compatible.
- Required: Does this Field have to have data in it before the Record can be created? If this is set and it's left blank a Validation Error will occur preventing the Record from creating / updating.
- Read Only: Makes the data in the Field non-editable (Read Only) - This shouldn't be used for Fields that require manual data entry as this makes such impossible!
- Min Value: If desired specify the lowest value that can be entered into the Field.
- Max Value: If desired specify the highest value that can be entered into the Field.
- Auto-Number: This is usually used in conjunction with a Record referencing system, or expression, and will assign each new Record a number, starting from 0, or if specified the 'Next Auto Number'. For examples of how Auto-Number can be used see here.
- Display Formatted: This shows the version of the Field that has the Format String applied (only if defined).
- Formatting: Used to apply Format Strings to the data in the Field, it allows you to alter the composition of the data. For example you could use one to turn 50 into £50.00 - This will only be applied if the option is toggled on.
- Note: Format Strings when applied make a Field Read Only, so should only be used where Field data is generated by expressions.
- Expressions: These are logic statements that are capable of determining the value for a Field and can perform an extremely wide range of tasks. For more information see here.
- Include in Free Text Quick Filter: Makes the Field searchable from within a Report in order to filter down Records. It will return all Records that contain the Search Text in Fields that have this property checked.
- Exclude This Field From Templated Record Copies?: If toggled, the data in this Field will be excluded from future copies of Records, whenever 'Template Copy' is selected for the copy.
*You must click 'Save' to commit the configuration to the system.*