Smartstaff, administrator
4,478
edits
Changes
→Variables and Provider / Consumer Records
==Variables and Provider / Consumer Records==
You can sue use the syntax below to display a list of Consumers or Providers associated with a record.
:<font size="3">'''[#(?object=''objectname'';{options})~''standardfieldname''~ $''customfieldname''$#]'''</font>
'''Where:'''
'''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$''')
:* 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.
==Template formulas and Provider / Consumer Records==
