You need to sign in to do that
Don't have an account?
imrohit
Need help in validation rule
I have one object which has one field of checkbox type now my requirement is that at a time only one record in the object can have checkbox value as true so suppose If I save a record with checkbox value as true and then I create another record and trying to save record with checkbox as true so in this case validation rule should throw error.
thanks in advance
Are you saying that in the Object, that field should only be true for one record from the entire Data of that Object. I hope this must be a configuration object and not transactional otherwise the data in that object will grow.
Anyway based on what information you provided and what I understood you can achieve that using the trigger.
I have never done trigger like this before. I truely believe some information is missing. I have used dummy names you can replace them or change them as per your need.
Hi Abdul
Thank you, You gave your valuable time for my problem, Yes you are right that It can be easily done by trigger but I was thinking that Is it possible to solve the problem using the validation rule. I just want to know that Is it possible in validation rule that you can check the values of the fields of the existing records while creating the new record