GRIDFOX
Field Types
When creating a new Field for a Table, you must choose a Field Type from one of the options in the grid below. The Field Type determines what sort of information can be stored in the Field.
Each Field Type has different options available, such as whether it can be set as a Reference Field, as a Required Field, or that they must contain unique values. Some Fields have additional settings available, such as the ability to set default values.
| Type | Description | Field Settings | Reference | Required | Unique |
|---|---|---|---|---|---|
| Text | Store text based information such as names and telephone numbers | None | Yes | Yes | Yes |
| Text Area | Store larger text based information such as address | None | Yes | Yes | Yes |
| Rich Text | Store rich text information such as notes and comments | None | Yes | Yes | Yes |
| Number | Store numeric values | None | Yes | Yes | Yes |
| Money | Store monetary values in GBP, EUR or USD | None | Yes | Yes | Yes |
| Percentage | Store percentage values | None | Yes | Yes | Yes |
| Date | Store dates | Optionally select to default to today’s date on new Records | Yes | Yes | Yes |
| Date Time | Store dates with times | None | Yes | Yes | Yes |
| Checkbox | Store a true or false value | None | No | Yes | No |
| List | Choose from a set of values in a dropdown | Specify your custom list & optionally select a default list value for new Records | No | Yes | No |
| List (Multi-Select) | Choose multiple options from a set of values in a dropdown | Specify your custom list & optionally select default list values for new Records | No | Yes | No |
| Auto Counter | An auto-incrementing counter (1, 2, 3…) used to give unique IDs | None | Yes | No | Yes |
| File | Store files that a user uploads | Number of files that can be uploaded | No | Yes | No |
| Image | Store images (jpg, jpeg, jif, jfif, png, svg, webp, gif, bmp, avif) | None | No | Yes | No |
| Icon | Store images to be displayed on records, such as company logos (jpeg, png, svg, webp, gif, bmp) | None | No | Yes | No |
| Formula | Calculated values based on the values in other Fields | Specify the formula | No | No | No |
| URL | Store links to webpages | None | Yes | Yes | Yes |
| User | Reference to an existing Gridfox User | Optionally select to default to current user on new Records | No | Yes | No |