Fields

Fields define the individual pieces of information that can be stored on each Record Type. These fields can include links to other records, as well as all the usual text, dates, numbers and many other types that you would expect. They are the conceptual equivalent of adding a field to a database table.

See Branding for a discussion of how to configure Fields as part of consistent branding of a module of functionality.

A Field is defined by adding a Field record, which contains the following fields:

Read/Write Fields

The following Fields can be Read and Written To. These Fields can be used to load data from Blueprints etc.
They can also be included referred to in Calculations or in Templates.

Field *requiredTitleTypeDetails
RecordTypeName *Record Typerecordtype 
FieldName *Internal Field NametextThe internal name of the Field. This may not contain spaces. It becomes the name by which the field may be referred to in Calculations.
Maximum length – 80 characters
FieldType *TypetextThe type of value that the field will hold. Select link to have the field hold a reference to another record. See Field Types for further details.
Maximum length – 15 characters
Permitted values: text, number, percent, currency, date, datetime, duration, logical, link, ragpercent, html, email, icon, calc, template
FieldTitleTitletextThe title of the field as visible in PYXI. This will appear as the title next to the field on records and as column header in Lists.
Maximum length – 80 characters
DisplayDecimalPlacesNumber of Decimal Places to DisplaynumberFor any numeric field type, the number of decimal places of accuracy to display. Note that this makes no difference to the accuracy with which numeric values are stored.
LinkedRecordTypeNameLinked RecordTyperecordtypeThe Record Type that this field holds. In other words, this field may hold a reference to a record of the record type specified.
Maximum length – 30 characters
LinkedRecordListFieldNameLinked Record List Field NametextIf this field is a link to another record (not a Category value), then that record’s display will show a list of these records with that record’s value in this field.
Specify the title of the list that shows on the lookup record. If left blank, then the title will be the plural name of this Record Type:recordtypes. You will normally want to be more specific with a title particularly if you have multiple references to records of this type on the lookup record (e.g. Assets and Assets in Transfer on a Person record).
Maximum length – 30 characters
LinkedRecordListDisplayFieldsLinked Record List Display FieldstextWhen showing lists of these records on the linked record, use this list of fields as the columns in the record list. If this is left blank, then only a link to each record will be displayed.
Maximum length – 250 characters
LinkedRecordListColourLinked Record List ColourcolourOptional HTML colour of the box in which the list of these records is shown on the lookup record.
TemplateScriptTemplate ScripttemplatescriptThis template script will be evaluated if the FieldType is set to template. This is similar in concept to a Calculated field, but instead of evaluating a calculation, the template script is evaluated and the resulting output is presented as this field’s value as Html. Note that when a template field is displayed in a DisplaySet, its Title is not shown – this is deliberate, allowing you complete flexibility about what to display, typically in a dedicated DisplaySet.
Typically you might use a template field to provide a custom menu/instructions/introduction to a ‘module’ of additional functionality, complete with links to one or more Pages relevant to that module.
FieldLengthLengthnumberFor text fields, leave this blank to get a multi-line text field, otherwise specify a maximum length and you will get a one-line field that restricts input to a maximum of this length.
CalculationCalculationCalculationEnter a Calculation to make this a Calculated Field rather than an input field.
DefaultValueCalcDefault Value CalcCalculationOptional Calculation which will be evaluated to provide a default value on new records. Typically this is used to populate fixed values or those that vary by date. The calculation is not specific to an existing record and cannot refer to any other values of the new record being created.
ListOfValuesList of ValuestextFor text or numeric fields, optionally enter a list of permitted values separated by commas – this will result in these options being offered as a drop-down list of when editing the field. Use with caution – in many cases, using a link to a Category is a better option, as Categories provide easier filtering and analytics capabilities.
SetNameSet NametextEnter the Display Set heading under which this field should be displayed on the record’s main display screen, and (for non-calculated fields) the section of the data entry form that contains the field.
Note that you can create a hidden field by leaving this blank. See Field Order and Grouping for further details.
Maximum length – 30 characters
SetColourSet ColourcolourOptionally specify an HTML colour (colour name or hex string) that will be used as the colour of the Display Set heading etc. See Field Order and Grouping for further details.
DescriptionDescriptiontextThis optional description will appear below field on add/edit forms. Use this to provide specific guidance to your users on use of this field.
DisplayAfterDisplayAftertextOptionally specify the name of the field after which this one should be displayed in the Display Set specified. Alternatively, enter top to have this field display as the first field in the Display Set. If not specified, fields will be displayed in the order that they were created. See Field Order and Grouping for further details.
Maximum length – 80 characters
isAlwaysShowAlways Show?logicalSet this to ensure that this Field is shown on records even if it has no value. By default, fields with no value (including zeroes and logical fields that are false), are not shown to avoid ‘clutter’. However, for some Fields, it may make sense (and avoid confusion) to show them even if they are empty / zero / false.
ShowCalcShow CalcCalculationOptional Calculation that determines whether the field should be shown on the record.
isPersonalContains Personal Data?logicalIf a field contains Personal Data in the context of GDPR compliance, set this flag to ensure that appropriate warnings are given about the use of data in this field.
isUserEditableIs Editable by Users?logicalIf a field is set as user editable, then it will normally be made available for editing i.e. will be shown on Add and Edit forms. If this is turned off (the default for fields linked to a Category), then the assumption is that the field’s value is modified only by scripts e.g. as part of a Step or Rule and/or by drag/drop on a ColumnView controlled by Steps.
isKeyLookupFieldKey Lookup Field?logicalYou can set this field so that it holds a key lookup, typically an account number from another system to which you wish to link your data records. If you set this option, then when data is loaded, the field will be checked for any existing records that have the same value. The practical upshot of this is that you can then load files of data from the linked system, with the account number in this field, and ensure that your existing record in PYXI gets updated. See Record Uniqueness for more details.
ViewGroupView GroupGroup 
EditGroupEdit GroupGroup 

Read-Only Fields

The following Fields can be Read only. They can be referred to in Calculations or in Templates.

FieldTitleType
CountofValuesNumber of Records with Valuesnumber
CreatedCreateddatetime
CreatedByCreated ByPerson
UpdatedUpdateddatetime
UpdatedByUpdated ByPerson