A list of field types, the purposes and options of each
There are various types of fields and field options which this section will cover.
Adding a field
- Expand the Build Tables menu in the lefthand sidebar
- Select the table to add a field to
- Click on the pencil icon in the toolbar, if necessary, to edit the table
- Click the fields tab at the bottom of the screen
- From the controls at the bottom of the list of existing fields:
- Type in a field name, optional description, choose a type and press the Create Field button
- Optionally, drag and drop the field to a desired location relevant to other fields
Field level help
Any description added to the field will be used as inline help. URLs can be included and will be turned into clickable links. See help for more information.
Editing a field
Field name and description (help text) can be altered at any time by clicking them. Fields can be moved on screen by dragging. Options can be altered by clicking the edit options link for each field.
However, once set, the field type can’t be changed. A number field can’t be converted to a text field for example. In particular, a decimal number can’t be converted to a whole number field and vice versa, as integers and floating point numbers are different data types.
There is a process available for changing field types, please see changing field types if you need to do that.
Removing a field
In the fields tab, click the remove button to the right of a field.
If the field is used in any other locations in your application, such as a view, you’ll be alerted to the fact. You’ll need to first remove the field from those locations before being able to remove it.
Customise the behaviour and display of fields
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.