Under review

Validation dependent on value in another column

Louise S 6 years ago in Geobank Mobile updated by Derek Vincent (Moderator (AUS)) 6 years ago 1

I'd like to create a validation that requires a value in one column if there is a certain value selected in another column.

Specifically, if STD is selected in the Sample Category column then I want the QAQC column to require a value.

Under review

This is possible using composite rules - simplest is to first create the two sub-rules as …A and ..B - e.g:

'1A - Sample Category is STD’ (equality rule) and

‘1B - QAQC column not blank’ (required rule)

Then create the IF –THEN composite rule a ‘1 - Validate that all Standards have a QAQC code’

Naming them in this way, keeps then together and in sequence in the list of rules