Changes

Template / Type Formula

245 bytes added, 17:22, 6 October 2016
Examples
===Examples===
 
@level1.Notice Text@=CASE '@level1.status@' WHEN 'Status 1' THEN 'Submission Cutoff is March 5th.' WHEN 'Status 2'
 
THEN 'Thank for your submission' WHEN 'Status 3' THEN 'Congratulations' ELSE 'I have no comment' END;
* 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==
Smartstaff
1,385
edits