Example "Hide If" Expressions


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

HeaderExpressionResult
Sample Diameter[Type] <>'U'Only show diameter if the type is U
Sample Basein ([Type] ,'U', 'P')Hide the base depth if the sample type is U or P
Sample Diameterisnull([Type])Hide sample diameter if there is no Type defined
Sample Diameternot 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).