I have a use case whereby we need to validate the text value a user inputs on a custom object, (Object A). The object is associated with the Companies object. I’d like to be able to check that the value being inputted unique based on all other Object A records also associated with the same Company record.
For example:
Company ACME has 3 associated Object A records, each with a text value that is unique to one another:
Record 1 - ‘Banana’
Record 2 - ‘Apple’
Record 3 - ‘Orange’
A user adds another associated Record and tries to input the value ‘Apple’, at this point the validation on input should fire to inform the user that another associated Record already exists with this value.