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==

• ← Older edit
• Newer edit →

Lalaine Songalia

Smartstaff

1,385

edits