need date in idea object when votetotal is 100 points

Question

trigger update_date_trigger on Idea(before insert, before update) {
    for (Idea p: Trigger.new) {
        if (p.VoteTotal == 100 && p.Date__c != null) {
            p.Date__c = date.Today();
        }
    }
}

in this I didn't get my date when votetotal reach 100.

Answer 1

I believe the problem is that Idea triggers aren't executed when an idea is voted on, probably because the field is a roll up summary. Technically votes are part of a separate object called Vote, which doesn't support triggers.

You will probably have to implement this feature by scheduling a class to periodically poll the system for Ideas that meet your criterion and update the Date field accordingly.

Answer 2

Try removing condition p.Date__c != null in

if (p.VoteTotal == 100 && p.Date__c != null) {
            p.Date__c = date.Today();
        }