8. Fields

8. Fields

The Fields list displays all fields that have been added to the system through the administration screens.


When a field is edited the details of the field are displayed.


Item

Details

Field name

The short unique name of the field used in lists and reporting

Data type 

The type of the field

Description

A description of the field for reference purposes

Does this field contain Personally Identifiable Information
When checked data in the field will automatically be anonymised when the record is no longer needed
Should this field be anonymised when data is no longer needed
When checked allows a field to have its data anonymised even though it may not contain Personally Identifiable Information, when the record is no longer needed


Save the field


Cancel changes and return to the list

Field visibility

In multi-organisation systems fields can be set to only be visible to certain organisations.

By default fields are visible to all organisations if the Visible to these organisations field is blank.
If one or more organisations are specified then it is only visible them. The other organisations will not be able to see the field on any forms or add it to any lists.





    • Related Articles

    • Appendix I - Special/calculated fields

      A number of special/calculated fields exist in the system that are not used in the Form Editor but can be added as columns to lists. These fields are designed to provide specific information and vary depending on the table they are connected to. ...

    • Why don't fields appear in the Filter Builder?

      Only those fields that are displayed as columns in the List appear in the Filter Builder. If you wish to use a field in the Filter Builder but not display it, then it can be marked as Invisible.

    • How do you sort on multiple fields in a list?

      Clicking on the column header will sort a list ascending or descending on that specific field. If you wish to add a secondary sort on another field hold the Shift key while clicking on the column header of the second field. Alternatively right click ...

    • Release v1.17.3 30/04/2021

      Fixes Back office Form Editor Fixed an issue where Min/Max values for number, decimal and money fields were not being correctly saved in the Form Editor.

    • Release v1.17.2 27/04/2021

      Fixes Back office Form Editor Corrected an issue where fields were not keeping their set location when being re-ordered in a People sub form.