Grouped field validation

Question

We need to know if there is a way to validate multiple fields as one and not a separate validation for each field.
For example: I have the fields Serial and Brand, I want to allow duplicate serials only if the Brand is different. And not allow if the Serial and the Brand are duplicates.

tokcum · Answer

Dear Marcelo,

as far as I know this can not be defined. You can define an attribute as unique but this always refers to all objects with the same object type. I searched for a quite similar requirement in the past without luck. My requirement back then was not related to Brands but to Lifecycle Status.

A workaround could be to define different object types for each brand under the same parent object type and leveraging the inheritance feature for the attributes. Yes, not very beautiful and probably with some "side effects" but worth a try if you do not have dozens of brands. If you have some brands with only a few objects you could even think about a brand called "Other <Name of Parent Object Type>".

Kind regards,

Tobias

tokcum · Answer

Dear Fahad, could you be a little more specific? How could I script such a validation? Thanks, Tobias.

Fahad Siddiqui_ihrjma · Answer

@Marcelo Montaño Sánchez  this can be done through scripting.