Difference between revisions of "Visibility Condition"
From SmartWiki
| Line 3: | Line 3: | ||
'''Examples''' | '''Examples''' | ||
| − | To make the field visible after 06 February 2009. | + | * To make the field visible after 06 February 2009. |
now()>'2009-02-06' | now()>'2009-02-06' | ||
| − | To make the field visible only if the date in the field named '''Date Initiated''' is after 2009-01-31 | + | |
| + | * To make the field visible only if the date in the field named '''Date Initiated''' is after 2009-01-31 | ||
'@Date initiated@' >'2009-01-31' | '@Date initiated@' >'2009-01-31' | ||
| − | To make the field visible for a user with roleid 9999 | + | |
| + | * To make the field visible for a user with roleid 9999 | ||
',@me.rolelist@,' REGEXP ',9999,' =1 | ',@me.rolelist@,' REGEXP ',9999,' =1 | ||
| − | To make the field hidden for a user with roleid 9999 | + | |
| + | *To make the field hidden for a user with roleid 9999 | ||
',@me.rolelist@,' REGEXP ',9999,' = 0 | ',@me.rolelist@,' REGEXP ',9999,' = 0 | ||
| − | To make the field visible only when the status is Draft or Open | + | |
| + | *To make the field visible only when the status is Draft or Open | ||
* '@status@' in ('Draft','Open') | * '@status@' in ('Draft','Open') | ||
::''Note: The above Visibility Condition would only be used '''Standard Fields'''. [[Custom Fields]] have a separate [[Status Field Permissions|Status Field Permission]] section that can be used.'' | ::''Note: The above Visibility Condition would only be used '''Standard Fields'''. [[Custom Fields]] have a separate [[Status Field Permissions|Status Field Permission]] section that can be used.'' | ||
| − | More Examples, | + | *More Examples, |
| − | + | '@Destination City@'='Toronto' | |
| − | + | '@Type@'!='Contract' | |
| + | |||
'''Note:''' remember to include the @fieldname@ in single quotes. | '''Note:''' remember to include the @fieldname@ in single quotes. | ||
| + | |||
==See Also== | ==See Also== | ||
Revision as of 16:33, 1 June 2009
The Visibility Condition section of Custom Fields and Standard Fields allows you to use logical statements to determine whether a field is visible or not.
Examples
- To make the field visible after 06 February 2009.
now()>'2009-02-06'
- To make the field visible only if the date in the field named Date Initiated is after 2009-01-31
'@Date initiated@' >'2009-01-31'
- To make the field visible for a user with roleid 9999
',@me.rolelist@,' REGEXP ',9999,' =1
- To make the field hidden for a user with roleid 9999
',@me.rolelist@,' REGEXP ',9999,' = 0
- To make the field visible only when the status is Draft or Open
* '@status@' in ('Draft','Open')
- Note: The above Visibility Condition would only be used Standard Fields. Custom Fields have a separate Status Field Permission section that can be used.
- More Examples,
'@Destination City@'='Toronto' '@Type@'!='Contract'
Note: remember to include the @fieldname@ in single quotes.
See Also
Visibility of Custom Fields can also be controlled using:
For help constructing logical statements for Visibility Condition:
- Determining the statusid
- Determining the roleid
- Advanced Logic (for more examples)
