Visibility Condition

From SmartWiki
Revision as of 15:12, 22 May 2009 by Cameron (talk | contribs)

Jump to: navigation, search

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 1. To make the field visible after 06 February 2009.

  now()>'2009-02-06' 

2. To make the field visible for a role # 9999

  ',@me.rolelist@,' REGEXP ',9999,' =1

3. To make the field hidden for a role # 9999

  ',@me.rolelist@,' REGEXP ',9999,' = 0

4. More Examples,

  '@Destination City@'='Toronto' 
  '@Type@'!='Contract'

Note: remember to include the @fieldname@ in single quotes.

For example, if you used the following Visibility Condition:

  • now()>'2009-02-06'

The field will only be visible after 06 February 2009.


These conditional statements can also refer to other fields:

  • '@Date initiated@' >'2009-01-31'

The field will only be visible if the date in the field named Date Initiated is after 2009-01-31


  • '@Destination City@'='Toronto'

The field will only be visible if the entry in the Destination City field is Toronto


  • '@status@' in ('Draft','Open')

The field will only be visible when the status is Draft or Open


Note: remember to include the @fieldname@ in single quotes.


Access to Custom Fields can also be controlled using Role Field Permissions and Status Field Permissions