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 KZread.
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 KZread Channel: / sanjayguptatechschool
Follow on Twitter: / techsanjaygupta
Udemy Courses: www.udemy.com/user/sanjay-gup...
KZread 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
Пікірлер: 100
Thank you so much for making detailed videos.
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
Thanks for all your motivation and support you give us @sanjay sir.
Great questions asked in the chat, guys! Sanjay, thanks for the lesson.
You’re doing a good job man…God bless you ..
Thank you so much @sanjay sir!! providing wonderful bootcamp.I'm Started to Learn Salesforce through your videos..
Hello Namaste sir i started watching your videos Many thanks 🙏🙏🙏watching videos without skipping ads👍
Great Going sir
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!
I wish you good health! you are the best master! God bless your home!🏠🏠🏠
@SanjayGuptaTechSchool
Жыл бұрын
Thank you 🙏
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)
Thank you very much sir
Great as always, THX
Day 5 Done successfully. same result got . whatever u did. TQ so much . helping a lot in getting learning.
Thanks sir
Thank you for finding time to do this sir. Really appreciated.
@SanjayGuptaTechSchool
Жыл бұрын
Glad it was helpful!
Great Sir gee
Thanks a lot,
just wrapped up this session .It was great. Did live hands on along with you
@SanjayGuptaTechSchool
11 ай бұрын
Great job!
Thank you for the effort. Much appreciated!
@user-vm8fy9vp9q
5 ай бұрын
why i am unable to make a rollup summary field on look up field
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
getting confident while doing
Super Thanks
God bless you sir!!!
@SanjayGuptaTechSchool
Жыл бұрын
Thank you 🙏
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?
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
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
Hello sir, How to reset all things after bootcamp 100 Days because practice more other things and also in developer edition there memory.
@ 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?
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
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?
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.
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
Star Thanks Sir
sir, How we can merge two account records if their name is the same and the data is also the same?
Apply lookup filter on student lookup field? Explain pls.....
When i trying to create master detail they are still showing error how to recreate please explain me sanjay sir
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
What is the formula use for average entrance score?
What is the use of lookup and master lookup
Sir,Could u please mention about the lookup filter under the section?when to use ?
@SanjayGuptaTechSchool
Жыл бұрын
Sure will explain today
Why when we open new student record in related list class name is autopopulated to salesforce admin.
Can i Assign student as master and class as a child, can i create two more junction object?
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
6 ай бұрын
You might have created rollup summary fields so you need to delete them first, then only you can convert laster-detail to lookup
where is this document available?
@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.
I am getting error while converting lookup on student into master-detail.
Timeline:- 9:19 -> Lookup Relationship 28:07 -> Master-Detail Relationship 41:08 -> Rollup Summary Field
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.
40 rollup fields we can create if i am wrong please correct me
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
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
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
22 күн бұрын
brother ..rollup summary always create on parent object (here that is class).
Can we create roller summary only on master-detail relationship???
@SanjayGuptaTechSchool
10 ай бұрын
Yes
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
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👍
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
8 ай бұрын
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.
can roll up summary use in look up relationship?
@SanjayGuptaTechSchool
6 ай бұрын
No
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.
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 ?
sir from where we can udo our deleted records
@SanjayGuptaTechSchool
6 ай бұрын
Recycle bin
Can we create Roll-up summary on junction object
@SanjayGuptaTechSchool
Жыл бұрын
Yes if relationships are master detail
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
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 🥰
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!
Your cold is very irritating😔
Thank you so much sir