Changes

Jump to: navigation, search

Calculated Field

594 bytes added, 22:01, 20 January 2011
no edit summary
|%y||Year, two digits
|}
 
==Conditional Statements==
 
To show different results depending on the value you can use 2 methods:
 
===If===
'''Syntax'''
* if(''conditional statement'',''value if true'',''value if false'')
 
'''Example'''
if([11] in (9681,10134,10028,9685,9683,9901),'Submitted',[this])
 
 
===Case===
'''Syntax'''
* CASE ''value'' WHEN ''value 1'' THEN ''result 1'' WHEN ''value 2'' THEN ''result 2''END
 
'''Example'''
CASE [this] 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
 
 
==See Also==
0
edits

Navigation menu