Uniqueness based within another column choice

%3CLINGO-SUB%20id%3D%22lingo-sub-2184322%22%20slang%3D%22en-US%22%3EUniqueness%20based%20within%20another%20column%20choice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2184322%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20have%20a%20unique%20problem%2C%3C%2FP%3E%3CP%3EColumn%20A%3C%2FP%3E%3CP%3ENumber%20column%20which%20needs%20a%20unique%204%20digit%20number.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20B%3C%2FP%3E%3CP%3EChoice%20column%20with%20multiple%20choices.%20X%2C%20Y%2C%20Z%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%204%20X%2C%203%20Y%20and%202%20Z.%20items%20in%20the%20library%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eall%20the%20X%20items%20need%20column%20A%20values%20to%20be%20unique%20to%20other%20X%20items%3C%2FP%3E%3CP%3Eall%20the%20Y%20items%20need%20to%20be%20unique%20to%20each%20other%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20i%20need%20a%20simple%20validation%20to%20check%20column%20A%20uniqueness%20with%20other%20similar%20column%20B%20values.%20and%20return%20invalid%20if%20not%20the%20case.%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20correct%20in%20thinking%20this%20is%20possible%2C%20I've%20not%20tried%20validation%20before%20and%20not%20aware%20of%20the%20code%20required.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2184322%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Evalidation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hi, have a unique problem,

Column A

Number column which needs a unique 4 digit number. 

 

Column B

Choice column with multiple choices. X, Y, Z

 

There are 4 X, 3 Y and 2 Z. items in the library

 

all the X items need column A values to be unique to other X items

all the Y items need to be unique to each other

 

I guess i need a simple validation to check column A uniqueness with other similar column B values. and return invalid if not the case. 

Am I correct in thinking this is possible, I've not tried validation before and not aware of the code required. 

0 Replies