Field Settings

    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.

    Unique Fields

    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.

    Is Unique Setting

    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.

    Required Fields

    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.

    Is Required Setting

    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.

    User Fields

    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.

    User Setting

    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.

    Date Fields

    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.

    Date Default Setting

    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.