Prevent creation of sharepoint list record if criteria is met?

Copper Contributor

I know you can do column data verification for certain data types. But I have a scenario where I want to prevent the creation of a record if certain criteria is met for the record as whole.

 

example: making a change control share point list. In this example the developer cannot be the same as the tester. If someone accidentally sets the same person for both fields and tries to save the record, it should stop them. How do you do that?

2 Replies

@Steveeast 

You could go List Settings->Validation Settings and enter a Formula like this

 

=[developer]<>[tester]

 


(given the two fields are called developer and tester). 

SvenSieverding_0-1719383708113.png

 

 

SvenSieverding_0-1719383810011.png

 


But this only works, if both columns are simple columns like "text" or "choice", not for "person" fields

Best Regards,
Sven

@Steveeast,

 

What is the column/data type of your Developer and Tester columns?


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.