Required Field only if another field has a value
I have a non-required field (capacity) and another field (measurement_units). I want (measurement_units) to be required only if (capacity) has a value.
I have been trying to use validate by calculation on (measurement_units) with something like:
If ( not IsEmpty ( Storage_Capacity ) and not IsEmpty (Storage_Capacity_Units); 1 ; 0 )
I know this should be super simple but I can't quite get it working.
Found a similar solution by PhilModJunk on another post...
(( not IsEmpty ( Storage_Capacity )) and not IsEmpty ( Storage_Capacity_Units) ) or IsEmpty (Storage_Capacity)