Day 5 | Salesforce Bootcamp 2023 | Lookup & Master-Detail Field | Rollup Summary | Junction Object

Do you want to begin your Salesforce Journey & Build your Career in Salesforce Ecosystem???
Then Study Salesforce with Sanjay Gupta at $0 (ZERO) per day!!! Yes you read it Right!
As Promised, I will be teaching Salesforce Admin & Development LIVE & FREE on Sanjay Gupta Tech School at KZbin.
DON’T MISS THIS GOLDEN OPPORTUNITY AND FOLLOW SGTS ON BELOW PLATFORMS:
Salesforce Bootcamp Session Tracker: docs.google.com/spreadsheets/...
Salesforce Bootcamp Exercise Sheet: docs.google.com/document/d/1h...
Salesforce Bootcamp FAQs Sheet:
docs.google.com/document/d/1I...
Salesforce Bootcamp Recording Playlist: • Day 0 | Know about you...
Subscribe Telegram Channel: t.me/SanjayGuptaTechSchool
Join Telegram Group (Q&A): @sanjayguptatechschools
Follow on Instagram: / sanjaygupta.techschool
Follow LinkedIn Page: / sanjay-gupta-tech-school
Subscribe KZbin Channel: / sanjayguptatechschool
Follow on Twitter: / techsanjaygupta
Udemy Courses: www.udemy.com/user/sanjay-gup...
KZbin Channel : Sanjay Gupta Tech School
Please Subscribe as only Subscribers will be able to ask Questions Live:
Channel Link: / sanjayguptatechschool
If you want to build your career as Salesforce Associate, Admin, Developer, Consultant, Business Analyst, Quality Analyst or in Sales Career, Service Careers, Marketing Careers in Salesforce Ecosystem then this is a Unique Opportunity for Everyone!!!
No matter whether you are a Student, Fresher, Non-IT Professional or IT Professional. Everyone can learn Salesforce!
This bootcamp will help you to prepare for Associate Cert, Admin Cert, PD1 Cert, App Builder Cert and BA Cert.
All you need is:
- Laptop
- Internet
- Daily 1.5 Hours (4 Days a week)
- Follow Sanjay Gupta Tech School on LinkedIn
- Trust in Sanjay Gupta
You need to forget about?
- Money
- Confusion
- Fraud
- False Promises
Timeline:
Total Weeks : 20
Total Hours : 80-100
When : Daily 1.5 hour (Monday - Thursday)
Start Date : 23 January, 2023
Time: 8.30 - 10 PM IST
#salesforce #salesforceadmin #salesforcedeveloper

[@nikky1604]

Thank you so much for making detailed videos.

[@sagarr7940]

Thanks for all your motivation and support you give us @sanjay sir.

[@chithraprakash2271]

Great explanation as always. Thanks for sharing this wonderful video. Very very helpful. Not only you are explaining the concept, you are also demonstrating it which is great

[@iS4lm4n]

You’re doing a good job man…God bless you ..

[@firushanov]

Great questions asked in the chat, guys! Sanjay, thanks for the lesson.

[@rajadesingu1725]

Thank you so much @sanjay sir!! providing wonderful bootcamp.I'm Started to Learn Salesforce through your videos..

[@atharva1]

Great Going sir

[@shekinahrichardson8161]

Omg thank you so much!!! I have just started the salesforce admin for beginners and was stuck on trying to understand the relationship between the master detail and lookup relationship. You broke it down perfectly. 😊

[@SanjayGuptaTechSchool]

Glad it was helpful!

[@afsanaanwar1719]

Hi Sanjay, Thank you very much for creating this boot camp, really appreciate your efforts and wish you all the best for your future endeavors. It would be very helpful if you can let me know why I do not have any records in my Accounts tab for the Sales app(so I can practice too)

[@srinurohit9204]

Thank you very much sir

[@WalnutCreekHomesForSale]

Great as always, THX

[@rambalasani507]

Day 5 Done successfully. same result got . whatever u did. TQ so much . helping a lot in getting learning.

[@sourabhrajput6258]

Thank you for finding time to do this sir. Really appreciated.

[@SanjayGuptaTechSchool]

Glad it was helpful!

[@bapanan]

Thanks a lot,

[@ZeenTech-ll8ls]

Great Sir gee

[@rambalasani507]

getting confident while doing

[@madhuri2227]

Super Thanks

[@liubovbezrukova2268]

I wish you good health! you are the best master! God bless your home!🏠🏠🏠

[@SanjayGuptaTechSchool]

Thank you 🙏

[@sureshp541]

Thank you for the effort. Much appreciated!

[@user-vm8fy9vp9q]

why i am unable to make a rollup summary field on look up field

[@rajkumarsahoo1857]

just wrapped up this session .It was great. Did live hands on along with you

[@SanjayGuptaTechSchool]

Great job!

[@yuvidee6768]

Thanks sir

[@sailajavv6985]

Hello Namaste sir i started watching your videos Many thanks 🙏🙏🙏watching videos without skipping ads👍

[@rinkuadhikari6646]

Hi Sir, In exercise sheet for Day 5 I am not able to understand what I have to do for last question? Apply lookup filter on Student Lookup field

[@lokeshb4337]

Hi Sanjay I have doubt in look-up relationship. Can I add existing student record in Class object? Note: Class is Parent Student is Child.

[@user-vf9kx8db5f]

@ Sanjay sir Please answer me as I'm stuck on one doubt. So when we create the master or lookup relationship with an object then can we choose which field from the master can we map the relationship to? e.g. If we want 2 lookup fields in student from class one for class name and one for class duration. is it possible? I don't see any option for that ?so is it always just mapped to record name of the master object?

[@chaithraav2473]

How to give related list to the created record? when we open the created record, related tab is displayed right, is it possible to give related lists there?

[@siddharthgautam9]

sir, How we can merge two account records if their name is the same and the data is also the same?

[@swatikhandelwal5861]

Sir, we won't be able to see the option to convert the master relationship to lookup until we completely delete all the rollup summary fields from the parent objects completely means from the deleted fields as well. Just posting this as someone asked this query during Question Answer session.

[@marepallynikhitha7977]

Yes we won't see that option to change field type until we delete the roll-up summary fields from the recycle bin as well

[@sandeepraghuvir]

Hello sir, How to reset all things after bootcamp 100 Days because practice more other things and also in developer edition there memory.

[@snehalthakkar136]

Hello Sanjay Sir, What if i have assign the custom object 'stdclass' to all the apps but i want to assign to only two custom app that we have created, how can i change it. Thanks

[@user-tk1sy2yb6g]

God bless you sir!!!

[@SanjayGuptaTechSchool]

Thank you 🙏

[@nidhirai5772]

What is the formula use for average entrance score?

[@himabindu2817]

Apply lookup filter on student lookup field? Explain pls.....

[@user-lf5um2ub5x]

hi sir, first of all thank you for giving this bootcamp I have a doubt in the exercise sheet in day 5 the question no is 12 how to create that could you plz explain

[@rosalinpanda1773]

Why when we open new student record in related list class name is autopopulated to salesforce admin.

[@deepaksiddani8442]

Hi Sir, Could you please elucidate my below query... As you said I have created 2 Record Types in the Student Object, Here in the existing records Record Type field coming as blank. It's not showing the Master Record Type value in the existing records. could you please check and let me know. Thanks in Advance

[@kuldeepsinghchauhan8699]

where is this document available?

[@fathimaurimella4578]

What is the use of lookup and master lookup

[@nowsathkhana533]

First of all I thank you. In Master detail and lookup relationship, if client ask in interview What is the real purpose. These . different these

[@yazhisaig5349]

Can i Assign student as master and class as a child, can i create two more junction object?

[@atulkarosiya1599]

When i trying to create master detail they are still showing error how to recreate please explain me sanjay sir

[@annajoseph3596]

Sir,Could u please mention about the lookup filter under the section?when to use ?

[@SanjayGuptaTechSchool]

Sure will explain today

[@sanket2469]

Sir what if there are 1000 of existing records. You might not be able to fill each record with look up value. Then how will we create MD relationship?

[@Sreenathmvvv]

40 rollup fields we can create if i am wrong please correct me

[@juanlguzman161]

@Sanjay, Sir, hope you're doing well. I'm following on your exercise but cannot see the Change Field Type option and I've already erased the Total Students Relationship, please help

[@juanlguzman161]

HI Sir, I realised that it happened as I had done, also as practise, the Highest score Relationship, I deleted it and solved the issue... Not sure if I'm going the right direction.

[@yeddulasravanthi4137]

I am getting error while converting lookup on student into master-detail.

[@shubhamdhole-gl1jn]

Star Thanks Sir

[@SheetalKotrange]

Hello Sir, I have a scenario. Can you please help me solve it? There are two objects which have master-detail relationship (in our case Class and Student Objects). Both parent and child has status field whenever all the records of child field has status "complete" (say for course completion) only then Parent status can be updated to "complete". How to achieve this? Thank you

[@SanjayGuptaTechSchool]

This can be done through either flow or trigger.

[@karthikakula6407]

HI, I am not able to change the field type from master detail to lookup relation in instructor object because when i click the edit option there is no change field type option displayed in my org. please help me with it. Thank you

[@SanjayGuptaTechSchool]

Please check whether you deleted rollup summary field from parent or not?

[@karthikakula6407]

Now I see the change field type. Thank you

[@mentalvicky5457]

hello sir i got a problem ! if i have to convert the lookup to master its easy but when came to change the master to lookup so we need to delete the existing roll up summary so i removed the student roll-up so i can change that master to lookup but now the class object in lookup relation ship i am unable create the roll up summary now .as per your given exercise sheet i am unable to create any roll-up summary on student object now.

[@prashantpatle4898]

brother ..rollup summary always create on parent object (here that is class).

[@smmrok]

Very Nice I followed your instructions but I have Clas as Master detail in student and does not give me the option to change data type - why?

[@SanjayGuptaTechSchool]

You might have created rollup summary fields so you need to delete them first, then only you can convert laster-detail to lookup

[@ezeedev5801]

Hey Sanjay, I m trying to answer this question Number 8 from Day 5 ( Convert lookup field created on Instructor Object into master-detail field.) but I get this message: ( Cannot Create Master-Detail Relationship You cannot create a new Master-Detail relationship on an existing custom object if records already exist. You must first create a Lookup relationship, populate the lookup field with data in all records, and then change the relationship type to Master-Detail.) Would anyone help solve this issue?

[@sonuchauhan-bq4wx]

first you have to delete all existing record then after u will be able to convert lookup to master

[@pankajvsolanke]

can roll up summary use in look up relationship?

[@SanjayGuptaTechSchool]

No

[@marthalavasanthakumari7860]

sir from where we can udo our deleted records

[@SanjayGuptaTechSchool]

Recycle bin

[@user-oe5ct1js3t]

In Day 5, 12. Apply Lookup Filter on Student Lookup Field, what does it mean?

[@SanjayGuptaTechSchool]

In lookup field there is an option to apply filter so use that.

[@yazhisaig5349]

while converting master detail in to lookup,why we want to delete rollup summary field? already i created rollup summary fields

[@SanjayGuptaTechSchool]

Because rollup cannot exist without MD so if you want to convert first we need to delete all rollups.

[@yazhisaig5349]

@@SanjayGuptaTechSchool sir, but i want rollup summary fields to include ,how can i include that ?

[@DDDDD43330]

There is some spécialiste debate between the link account and contact. Some people says its lookup shop other says master détail. What is the official in this matter ?

[@SanjayGuptaTechSchool]

It is a special relationship field which is designed by salesforce in different way.

[@DDDDD43330]

@@SanjayGuptaTechSchool ok but in certificate test WE havent this option "special relationship" WE have to chose between master or lookup

[@kanchangupta5012]

In this case we choose lookup coz we can create contact without account

[@17mevicky]

Can we create roller summary only on master-detail relationship???

[@SanjayGuptaTechSchool]

Yes

[@suyash3402]

If we have 5-10 objects so how we can identify which relationship to be created between these 5-10 objects and which object should be parent and which should be child

[@SanjayGuptaTechSchool]

It will be decided by the architect of the project as per the client requirements

[@suyash3402]

@@SanjayGuptaTechSchool thanks sir👍

[@priyazv5522]

When I m trying to create a roll up summary field i m not able to do that..i tried so much..but i m stuck ..wht To do sir?

[@SanjayGuptaTechSchool]

Check whether you have master detail relationship created or not.

[@priyazv5522]

@@SanjayGuptaTechSchoolI Resolved it...thank you sir once again 🥰

[@raghuramireddyyaramala-qe8gw]

Can we create Roll-up summary on junction object

[@SanjayGuptaTechSchool]

Yes if relationships are master detail

[@nandanareddy-tx5qz]

how to create average in rollup summary sir?

[@SanjayGuptaTechSchool]

Create two rollup 1. Sum 2. Count Now create a formula field and use above rollup summary fields and divide them to calculate average.

[@nandanareddy-tx5qz]

@@SanjayGuptaTechSchool tq sir

[@shaikrajiyabegum4745]

How many Contacts can be associated to single Account. How many Accounts can be associated to single Contact Note: Account and Contact are standard objects and everything is also standard?

[@_DheerajIPPILI]

When we have lookup relationship between parent and child, we can have many child records associated with parent, and here we can have only one parent record as a reference at a time for a record.

[@kunalvirdi6740]

Timeline:- 9:19 -> Lookup Relationship 28:07 -> Master-Detail Relationship 41:08 -> Rollup Summary Field

[@ramesha5243]

please don't anaswers or read the questions in the middle as the topics get confused

[@SanjayGuptaTechSchool]

Yes in few i did this but now avoiding. Thanks for true feedback!

[@ranapratap1824]

Your cold is very irritating😔

[@rahulsinghpanwar8176]

Thank you so much sir