Table and Field Properties

the configuration of tables, fields, relationships and renderers have specific properties that can be set to control behaviours, appearance, etc tables properties the following properties can can be configured against the table itself this is done from the key/value section on the properties tab for the table definition property example comments i18n name table work name the i18nkey of the localised name of the table note this generated automatically on table creation, along with the default localised value, and normally not needing to be altered default displayvalue name the field that is used to represent as the displayed value when this table when referenced elsewhere (such as from a reference field on another table) default requiredfield true a boolean value (default false if not present) of whether this field is always required to be provided for this table audited true a boolean value (default false if not present) of whether the various write/write operations on the records of this table are audited dropdown displayfields number 6,shortdescription 6 used for what fields are displayed in drop down lists in the ui when references to this table are being selected the format is \<fieldname> \<relative size>, \<fieldname> \<relative size>, the relative sizes should add up to 12 e g with two fields and 6 and 6, each field will occupy half the layout similarly, 3 and 9 would be one quarter and three quarters examples table dropdown displayfields user name 4,email 8 if you are using this on a large table, it is recommended you use the searchfields property as well to allow you to still show the field in the dropdown, but to only use certain fields as part of the search / query dropdown selectiondisplayfields name typically the same as the single valued default displayvalue property, but can be used when multiple fields are required dropdown searchfields (new in later 1 8 releases) number,shortdescrpition comma separated list of fields to search if this has been added, this will be used to search the table instead of display fields allowing you to have separate fields to search on and show on the dropdown workflow\ action journal (new in 1 9) clientjournal used to determine where the approval message / status is given upon a user approving / rejecting an approval lookup field key if set, will allow lookup by this value as well as by id this field should be marked as unique note you may see some other properties in tables, which are valid, but have been replaced by a field on the table configuration field and relationship properties the following properties can can be configured against the fields and relationships on an table this is done from the key/value section on the properties tab for the field definition and the relationship settings for the relationship definition true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type renderer properties renderer properties are field/relationship properties specific to a specific view, rather than generally for the field/relationship they are accessed via the the form configuration form (via "configure layout" under the tool icon in the upper right of a form), then the small "cog wheel" above a field on the form the following properties can be configured against the fields and relationships renderers this is done from the key/value section on the renderer section field renderer properties property example for (field type/layout element type) comments dependent table field targettable condition used for fields such as conditions, that are dependent on the table they associated with basic toolbar false html html fields by default have limited controls on editing, so as not to crowd the screens where they are commonly used this makes them practical for fields such as client journals, etc however, some fields require more sophisticated editing, as well as toggle for html editing setting this property to false enables the full control inline editor false html html fields can have in line controls when you click into the field this will mean when you click into the field, it will provide certain options this is typically how our journal fields work out the box enablecreatebutton true related list this determines whether or not the “new” button will show up for related lists note that this does not overwrite permissions that are user may have to the field or target table however starting in version 1 10, you can also use this for custom related lists enablequickentrybutton true related list this determines whether or not the “add/remove” button will show up for related lists note that this does not overwrite permissions that are user may have to the field or target table however enablepreview false reference this determines whether or not the eye/preview button will appear for reference fields by default this is true for all reference fields accounting currency r decimal this prefix’s an account field with a type of currency this is for use with the accounting renderer accounting currency font size 14px decimal the size of the prefix this is for use with the accounting renderer accounting currency name rand decimal the name of the currency name this is for use with the accounting renderer expanded false collapsible panel used for collapsible panel layout element if set to false, the collapsible panel will be collapsed by default and true for the opposite note that if this renderer property isn’t added to the layout element, the collapsible panel will be expanded by default columnlist number,shortdescription,workflowstatus related list this allows you define the specific fields a related list can show, if it needs to be different to other views of that list sortorder shortdescription related list this allows you define the specific sort order a related list can show, if it needs to be different to other views of that list if you want to order it in descending order you can do the field with \ desc, such as shortdescription\ desc table list renderer properties property example comments accounting currency r used to prefix a field with a currency symbol relative time units “days, hours” to use this functionality, you need to be on version 1 10 or later which units to display in the field relative time unit display “long” to use this functionality, you need to be on version 1 10 or later should the units be short or long relative time format display “date”, “relative”, ”both” to use this functionality, you need to be on version 1 10 or later should the date be displayed as well as the relative time relative time format future key relative time future remaining to use this functionality, you need to be on version 1 10 or later i18key for future relative times relative time format past key relative time past overdue to use this functionality, you need to be on version 1 10 or later i18nkey for past relative times catalog question rendered properties property example comments reversed true set to true so the label of the catalog question will appear to the right of the question use case will be having a checkbox question with the label to the right of the checkbox