Changes

Jump to: navigation, search

Template / Type Formula

1,578 bytes removed, 13:43, 8 October 2013
Using Object Syntax
Object syntax can be used in template formulas to loop through the level below and to assign a value or values based on some defined criteria.
The An example of the syntax for this is defined shown below::<font size="3">'''@levelxlevel1.fieldAname@="@levelxlevel1.[#(?object=activity::criteria=fieldBeventtype=value3123) ~standardfieldnameeventtype~ $customfieldname$ #]@""'''</font> '''Where:''':* ''levelx'' is the level where the returned value(s) will be stored. As such it can be '''level1''', '''level2''' or '''level3'''. :* ''fieldA'' is the name of the field where the returned value(s) will be stored. :* ''standardfieldname'' is the name of a standard field (between tildes ~):* ''customfieldname'' is the name of a custom field (between dollar signs $) '''Notes:''' :* You can refer to [[Custom Fields]] in the list using the Custom Field ID instead of the field name, still between dollar signs ('''$12345$'''):* '''level-1''' can only be used as an object when referenced from a contact record. Also '''level-1''' will only list the level 1s that the contact has been added to in the contacts section.:* You can include text as well as variables within the [#...#] syntax.:* When using this syntax for [[Web Page View]]s, [[Custom Field Type: Read Only – System Variables|Read Only – System Variables]] etc. you will usually want to include HTML table formatting within the '''[#...#]''' syntax (see examples below). For [[MS Word Merge]] custom fields the table defined on the MS Word Template document, with the columns delimited by pipes (|) within the '''[#...#]'''.:* '''~Index~''' can be used to number the lines (1, 2, 3...) '''Note:''' ~index~ does not work for all lists. For example, it cannot be used when listing contacts associated with a Level 1.::* ''~Index~'' (upper case 'I') start numbering at 1, ''~index~'' (lower case 'i') starts numbering at 0.:* ~eventid~ will display the id of the level 2.
==UTA Provider syntax==
Smartstaff, administrator
4,478
edits

Navigation menu