You need to sign in to do that
Don't have an account?
lewis
checkbox validation
i have a checkbox field in a child object . I need a rule that checks this checkbox everytime a new child record is created. if there is one already it should not allow any other child object to be able to tick that checkbox ..
ex . field A is a checkbox . in object test . the parent object is train . everytime a new TEST is created in that object train, i need a rule to check if the checkbox was already ticked earlier, if yes, the user shouldnt be allowed to tick that box.
What is the relationship between that Parent and Child object? If it's Master-Detail you might be able to do this with a Rollup Summary Field that counts the number of Child records with Checkbox = TRUE and a VR that gives an error if the RS Count > 1
All Answers
Hi,
you will have to write a trigger for that, you can't control this behavior through any kind of validation rule.
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
What is the relationship between that Parent and Child object? If it's Master-Detail you might be able to do this with a Rollup Summary Field that counts the number of Child records with Checkbox = TRUE and a VR that gives an error if the RS Count > 1
thanks for the help