Constraint conditional on positive value in another entry in same record - is that possible?
Our app holds student attainment data. A teacher is supposed to stop the test (which has eight components) when a student scores zero. Thus after a zero there must be no positive values entered within the same record. Is there a way to set a constraint to achieve this (no positive value after a zero, otherwise an error is generated)?
We looked at your guidance on RegEx (https://backendless.com/feature-54-validating-data-object-properties-with-regular-expressions/) but it doesn't seem to fit the case.