Smartstaff
1,385
edits
Changes
→Examples
@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==
