You need to sign in to do that
Don't have an account?
Nathan Hobbs
Create a summary field on an Object that counts the number of references for an applicant.
I'm trying to Create a summary field on an Object that counts the number of references for an applicant. I created an object for candidates but I don't think it is a "master" do i have to create a summary lookup relationship for this to become a master object so that I can create a summary field??
The two objects should be in Master-Detail relationship if you want to create a Roll-Up summary field on the Master Object. in your case the two objects seems to be Candidate and References.
Create Candidates relationship field on the Child Object as a Master-Detail relationship field.
And then create a Roll-Up field on the Master object which will summarize the No of References field on the Child object.
Please let me know if it helps you and solves your problem.
Let me know if you need more assistance.
Thanks,
Jainam Contractor,
Salesforce Consultant,
Varasi LLC
www.varasi.com
All Answers
You need to create a master-detail relationship to create the roll-up summary field.
Thank you
The two objects should be in Master-Detail relationship if you want to create a Roll-Up summary field on the Master Object. in your case the two objects seems to be Candidate and References.
Create Candidates relationship field on the Child Object as a Master-Detail relationship field.
And then create a Roll-Up field on the Master object which will summarize the No of References field on the Child object.
Please let me know if it helps you and solves your problem.
Let me know if you need more assistance.
Thanks,
Jainam Contractor,
Salesforce Consultant,
Varasi LLC
www.varasi.com
I appreciat the feedback. This unfortunately did not get it done. I am trying to apply for a job and only have a base understanding of this. I've managed to set up a custom object and add several custom fields, record types, layouts etc per the sketchy instructions. The object is Candidate Test and the "test" for the candidate,ie ME, is to be able to navigate this test scenario where I am setting up the object "Candidate Test" which has fields like a number field which allows 1-4 number of references. The next instruction is to Create a summary field that counts the number of references, name this "Total References". Next Create a new section on the contact Layour named "Candidate Summary" and add the "total references" to this section. It doesn't say anything about creating a separate object etc to make the summary field. I know this probably does need to happen I believe that is the test is to show that you know that this has to happen to accomplish that. When I make the new object called " Child Object" I then go to create the roll up field on teh Master object and it doesn't give me the Field to Aggregate in the drop down for the SUM function. I obviously did something wrong with the field on the new child object right?
THE 2 OBJECTS ARE LINKED RIGHT????
You are correct... 2 objects are linked. But you want to count the total no of references. So in that case instead of SUM, you should summarize by COUNT. In that case, it would calculate the no of references object associated with the Candidate Test. Can you please try and let me know if it helps.
Thanks,
Jainam Contractor