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 (jpeg, png, svg, webp, gif, bmp) 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
Did you find this page useful?
Your feedback helps us improve our support.
Send
Thanks for your feedback 👏
Navigation