You need to sign in to do that
Don't have an account?
SFDC Coder 8
Auto number based on picklist value
Hi All,
I have one custom as Student__c. I have one custom picklist as Status__c and values for Status__c are New,Joined. Default value for Status__c is New.
I have one more field as Total_Students__c (Number Data type).
After creating first record, if Status__c is changed to Joined then I want to auto fill Total_Students__c = 1.
After creating second record, if Status__c is changed to Joined then I want to auto fill Total_Students__c = 2.
Like this I want auto number fill for Total_Students__c when ever Status__c is changed to Joined.
Please suggest me how can I do this?
Thanks in Advance
I have one custom as Student__c. I have one custom picklist as Status__c and values for Status__c are New,Joined. Default value for Status__c is New.
I have one more field as Total_Students__c (Number Data type).
After creating first record, if Status__c is changed to Joined then I want to auto fill Total_Students__c = 1.
After creating second record, if Status__c is changed to Joined then I want to auto fill Total_Students__c = 2.
Like this I want auto number fill for Total_Students__c when ever Status__c is changed to Joined.
Please suggest me how can I do this?
Thanks in Advance
All Answers
What will happen if the status is changed from 'Joined' → 'New'/Other Status?
I suggest you create two custom objects, Master(ex. Room__c) and Child (Student__c)
then set Room__c.Total_Students__c field to Roll-Up Summary.
Good Luck!