Once you have created Fields for a Table, there are some additional settings that you can choose to use to help customise your Project.
Some of these settings apply to multiple Field Types and some are only applicable for a specific Field Type.
You can set 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 or through uploading 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.
You can configure a user field to default to the currently logged in user when a record is created.
Open up field configuration for a user field.
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 to other users in the project
You can configure date fields to have a default value of today when a record is created.
Open up field configuration for a date field.
Tick the checkbox for Default to today’s date.