Changes

Visibility Condition

55 bytes added, 14:01, 2 June 2011
no edit summary
* To make a Contact field visible only to the contact and to System Administrators (''[[roleid]]'' 12345):
@me.userid@=@userid@ || ',or instr(" @me.rolelist@",' REGEXP ',"12345,'")>=0
* To make the field visible for a user with [[roleid]] 9999
',instr(" @me.rolelist@,' REGEXP '",",9999,'")>=0:''REGEXP instr checks to see of the 2nd term (,9999,) can be found within the first term (@me.rolelist@) and returns true (1) if the numeric character position at which it is found and false (0) . It returns a value of -1 if it’s the search term is not found.
*To make the field hidden for a user with roleid 9999
'instr(" ,@me.rolelist@,' REGEXP '",",9999,' = ")<0:''In this case REGXP ''instr'' will return true false (-1) if the role is not found, and since 1 does not equal 0 it that will hide only display the field for users with that don't have [[roleid]] 9999
*To make the field visible for a user whose parent company has company category 1234
0
edits