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). |