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' |