OpenGround Wiki Example "Hide If" Expressions

Example "Hide If" Expressions

The following table contains some example Hide If statements that can be used for Headers in OpenGround Data Collector

Header	Expression	Result
Sample Diameter	[Type] <>'U'	Only show diameter if the type is U
Sample Base	in ([Type] ,'U', 'P')	Hide the base depth if the sample type is U or P
Sample Diameter	isnull([Type])	Hide sample diameter if there is no Type defined
Sample Diameter	not in([Type], 'U', 'UF', 'TW','TWF','P','PF','U/38')	Show the diameter if the Type is U, UF, TW, TWF, P PF or U/38. Note the use of NOT turns the expression from a “hide if” into a “show if”
Sample Diameter	isnull([Type]) or not in([Type], 'U', 'UF', 'TW','TWF','P','PF','U/38')	Combine the last two – Show if the Type is U, UF, TW, TWF, P PF or U/38 and don’t show if there is nothing defined. Note: Make sure the isnull() condition is the first condition (known issue).

Recommended