Smartstaff
1,385
edits
Changes
→Examples
===Examples===
* At Level 2: if the field called ''locationpreference'' says "Home" put the value in the ''homeaddress'' field into '''Location'''. Otherwise put the value from the ''worksaddress'' field into '''Location'''.
@level3.consultant@=if('@level3.contact.rolelist@' like '%12345%','@level3.contact.fullname@','@level2.owner.fullname@');
* At Level 2, populate the Level 2 ''Funding Group'' based on a level 1 ''Funding Area'':
@level2.FundingGroup@=CASE WHEN "@level1.FundingArea@" in ("Water", "Recycling","Environment") THEN "Water"
WHEN "@level1.FundingArea@" in ("Active Health", "Arts & Culture","Education") THEN "Well-Being"
WHEN "@level1.FundingArea@" in ("Women Empowerment") THEN "Women"
ELSE "" END<end>
==Using Object Syntax==
