Common Options

Options common to all fields of any type

Capitalise field name

By default agileBase displays field names in Title Case. Un-ticking this option disables that, which can be useful for special cases like e.g. ‘pH’ or ‘Length (m)’, which would otherwise show as ‘PH’ and ‘Length (M)’.

Icon

Rather than displaying a field name, show an icon, chosen from https://fontawesome.com/icons. For example, to show a phone icon for a phone number field, you could enter phone, for an email field envelope or a twitter handle twitter.

Show if record in view

Allow a field to be hidden or shown based on conditions. The conditions are specified by creating a view and adding filters. That view is then selected in this field option.

If a record appears in the view, the field will be visible, otherwise it won’t display to users.

As the conditions are created in a view, this mechanism is really powerful. You can create simple or very complex critera, including all of the filter options in a view, for example basing a filter on a calculation and combining multiple filters.

So you could make a field appear only when a particular point is reached in a process, or a status is changed elsewhere in a form, or perhaps it should only be visible to people who are members of a certain role. See view filters for more information.

Two special options are available

  • show always - the default state
  • show never - useful for hiding fields used for internal purposes, e.g. which help the internal workings of a workflow

Lock when value set

If the field is blank, allow a value to be entered, however as soon as it has a value, lock to prevent further editing. The user can manually unlock, but will be prompted for a reason for doing so, which will be logged against the field as a comment.

This can be used to prevent accidental editing of important fields which should not usually be changed, for example a product’s stock code.

Unlock if record in view

If Lock when value set is ticked, unlock on certain criteria. Works the same way as Show if record in view.

Required

If ticked, force the user to supply a value. They won’t be able to navigate away from a record without doing so.

Note: although this is a strong prompt, it would still be possible for the user to close the browser window for example, leaving the field with no value. In that case a value will be prompted for again the next time the record is loaded.

Prominent

Prominently highlight the field on the screen, e.g. if it’s one that is important to fill out, without actually requiring a value to be supplied.

Set from previous referenced field

Provides a way to calculate a default option for a field. Tick this option and place a referenced field just before this field. The value of this field will be set from whatever value the referenced field outputs.

If the referenced field’s view has more than one field, the last one will be used, or if any have the same name as this field then that one will be.

To have a value set only at a certain point in a process, this option can be combined with the Show if record in view option. When the field becomes visible, the value will be set.

Unique

Disallow any duplicate values from being entered. No records in the table can have the same value as each other.

Change causes record refresh

Through the use of some field options like Show if record in view above, the screen can change based on what’s entered into a form. This option can work as a switch to refresh the configuration of the screen if it does change as someone enters new data.

For example, if there is a table to store sales opportunities, one field may be the status. If the status changes to won or lost, then you may wish to show some extra fields like ‘date won’ or ‘reason why lost’ for example. To allow this, tick the ‘change causes record refresh’ option on the status field. Then whenever the status changes, these fields will automatically appear if relevant.


Last modified June 5, 2020: TODOs (8123791)