Questions about this article, topic, or product? Click here. 

Example Validation Expressions

The following are examples of validation equations that can be added to a header within a step in OpenGround Cloud Data Collector

isnumber([HandPenetrometer])​

Header Valid Expression Message (displayed when Valid Expression returns false)
Sample Base [DepthBase]>=[DepthTop] ‘Incorrect Depths.  Base depth must be greater than or equal to top depth’
Sample Base [DepthBase]>=0 ‘Incorrect base depth.  Value must be greater than or equal to 0’
Date Time Sampled [DateTimeSampled]>[LocationDetails.DateStart] 'Incorrect Date.  This location was started on ' + [LocationDetails.DateStart]
Hand Penetrometer isnumber([HandPenetrometer]) 'Value is not numeric.  Are you sure this is correct?'
Date Test [DateTest]<Now() 'Test date cannot be in the future!'
Depth Base not(isnull([DepthBase])) 'Warning: No depth base has been recorded'
Recommended
Related
Communities
Support and Services
Training and Learning
Social Media