Field Types

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

Creating Fields

Field Settings