When creating a new Field for a Table, Gridfox allows you to specify a Type from one of the options in the grid below.
This grid also shows which fields can be set as a Reference Field, as a Required Field, or that they must contain unique values. For more information about these options see the Field Settings documentation.
Type | Description | Field Settings | Reference | Required | Unique |
---|---|---|---|---|---|
Text | Store text based information such as name 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 ongoing notes and comments | None | Yes | Yes | Yes |
Number | Store numbers than you can perform functions on such as +, -, SUM | None | Yes | Yes | Yes |
Money | Store financial values in GBP, EUR or USD | None | Yes | Yes | Yes |
Percentage | Stores percentage values | None | Yes | Yes | Yes |
Date | Store dates | Optionally select to default to today’s date | Yes | Yes | Yes |
Date Time | Stores dates & times | None | Yes | Yes | Yes |
Checkbox | Stores a true or false value | None | No | Yes | No |
List | Choose between a custom list of values in a dropdown | Specify your custom list & optionally select a default list value 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 | Stores files that a user uploads | Number of files that can be uploaded | No | Yes | No |
Image | Stores images (jpeg, png, svg, webp, gif, bmp) | None | No | Yes | No |
Icon | Stores images to be displayed on records, such as company logos (jpeg, png, svg, webp, gif, bmp) | None | No | Yes | No |
Formula | Create dynamic fields based on the values of others | Specify the field 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 | No | Yes | No |