Once you have created Fields for a Table, there are some additional settings that you can choose to use to help customize your Project.
Some of these settings apply to multiple Field Types and some are only applicable for a specific Field Type.
Field Settings can be configured in either the View Editor or the Explorer. Then click the Field that you would like to amend to open the left hand settings panel for the Field.
You can specify that a Field must contain unique values. For example, a registration number field on a vehicles Table would be set as Is Unique.
If you set an existing Field to be unique, Gridfox will check that there are no existing duplicate values in the system. You may have to update your data before you can set a Field as unique.
You can set a Field to be required for a Table. This will validate that when a Record is created, by either direct Record creation, via Form submission or through importing Records via a spreadsheet, that the Field is populated.
If you set an existing Field to be required, Gridfox will not check that existing Records contain a value. When your users edit an existing Record after a field has been set as Is Required then they will not be able to save changes to the Record without a value in the required Field.
If the Field has been used on a Form, it will automatically be set to required on the Form also.
Setting Default User Values
You can configure a User Field to default to the currently logged in user when a new Record is created.
Tick the checkbox for Default to currently signed in user.
All new Records that are created will have this Field set to the User that created the Record. The User can change the value in this Field before saving the Record.
Setting Default Date Values
You can configure date fields to have a default value of today when a record is created.
Tick the checkbox for Default to today’s date.
All new Records that are created will have this Field set to the current date. The User can change the value in this Field before saving the Record.