Add a Non-Database Field
Last updated 31/01/2022
How to Add a Field Not Attached to the Database
The following documentation will explain how to add a field to your form that is not connected to the database. The value/s in these fields will not be stored in the database as they are not attached to a field in the database. Fields that aren't connected to the database can be beneficial for tasks such as gathering data for calculations and only storing the calculated value in the database, rather than the data needed to calculate the answer.
Steps
Select Forms in the menu.
Click the Add Item button in the list app bar.
Type a title in the Title field.
Click the lookup icon in the Table field and select the required table.
Click the Pages tab.
- Click the Add Pages button.
Type a caption in the Caption field.
Click the Fields tab.
- Click the Add Fields button.
To have a field not attached to a table field in the database, you do not make a selection in the Field field. The Field field is to select a field from the table in the database to store the data.
Type a caption in the Caption field.
Click the lookup icon in the Display Type field and select the required display type.
Click the Save button in the form app bar.
Click the Add Fields button and continue to add the rest of your fields to the form.
On completion of the final field entry, click all three Save buttons in the stacked form app bars.
A non-database field cannot be included in the list. You will need to add more fields to your form and include at least one of the fields in the list.
How This Will Look in Your End-User Application
The field will appear to be a normal field, but the value will be erased once the value has been input and the form has been saved. The information typed into the field will not be saved in the database.