MENU
The DreamHouse Realty team has a master-detail relationship set up with open house as the
parent object and visitors as the child object.
What type of field should the administrator add to the open house object to track number of visitors?
32 comments · newest first
FI
Fidelia
11 months ago
Wait, can you really use Roll-up for counting?
JE
Jean
11 months ago
I thought a Cross-object formula could work too?
HO
Horace
11 months ago
Multi-select Picklist seems off for this, right?
AD
Adell
11 months ago
Agreed, that’s the best way to count visitors.
CR
Crissy
11 months ago
Definitely a Roll-up Summary field!
CE
Celestina
12 months ago
Indirect lookup sounds familiar, but I don't think it's for counting visitors. It might be something else entirely.
RO
Roosevelt
12 months ago
I practiced a similar question where we had to track related records, and I believe Roll-up Summary was the right choice there too.
DE
Dewitt
1 year ago
I'm not entirely sure, but I remember something about using formula fields for calculations. Would that apply here?
DA
Darell
1 year ago
I think we need a Roll-up Summary field to count the visitors since it's a master-detail relationship.
SH
Shakira
1 year ago
I'm a little confused on this one. The question mentions a master-detail relationship, but I'm not sure how that impacts the field type we should use. Is a Roll-up Summary the only option, or could something like a Multi-select Picklist work too? I'll need to review the field type details to make sure I understand this properly.
LA
Lauryn
1 year ago
Okay, I've got this! The key here is the master-detail relationship between open house and visitors. Since we need to track the number of visitors, a Roll-up Summary field on the open house object is definitely the way to go. That will automatically aggregate the visitor data from the child object. Easy peasy!
AN
Annita
1 year ago
Hmm, I'm not sure about this one. I'm trying to think through the different field types and how they might work in this scenario. The Roll-up Summary seems like a good possibility, but I'm also wondering if a Cross-object formula field could work too. I'll need to think it through a bit more.
AM
Amie
1 year ago
This looks like a straightforward question about tracking the number of visitors for an open house. I think the Roll-up Summary field would be the best option here since it can automatically aggregate the number of visitors from the child "visitors" object.
ME
Melinda
1 year ago
Honestly, I think the admin should just count the visitors manually. You know, with a pen and paper. That's the only way to be 100% sure you're getting the right number. Technology, am I right?
VI
Vincent
1 year ago
B) Multi-select Picklist
CA
Carmelina
1 year ago
A) Roll-up Summary.
PA
Patti
1 year ago
I believe an Indirect lookup field might be a better option to track number of visitors.
LY
Lynette
1 year ago
An Indirect lookup? What is this, a treasure hunt? I think the admin should just stick to the basics and go with the Roll-up Summary field. No need to get fancy here.
OW
Owen
1 year ago
User 3: Roll-up Summary makes sense for tracking the number of visitors. Let's keep it straightforward.
ST
Staci
1 year ago
User 2: Yeah, no need to complicate things with an Indirect lookup. Roll-up Summary is the best choice.
NA
Nada
1 year ago
User 1: I agree, keeping it simple with a Roll-up Summary field is the way to go.
AV
Avery
1 year ago
I'm not sure, but I think a Cross-object formula field could also work for this scenario.
MA
Magda
1 year ago
Hmm, I don't know. A Multi-select Picklist? Really? That doesn't sound right at all. How would that help track the number of visitors?
CH
Cherri
1 year ago
I'm not so sure about that. A Cross-object formula field might be a better choice here. That way, you can pull the visitor count from the child object without having to do a manual roll-up.
MO
Moon
1 year ago
User 2
CA
Carylon
1 year ago
User 1
KA
Kandis
1 year ago
Option A seems like the way to go. I mean, a Roll-up Summary field is designed to track the number of related records, right? Seems perfect for this use case.
MO
Moon
1 year ago
User 3: That makes sense, it would save time and effort for the administrator.
HO
Hollis
1 year ago
User 2: Definitely, it automatically calculates and displays the total count of child records.
CA
Carey
1 year ago
User 1: I agree, a Roll-up Summary field would be perfect for tracking the number of visitors.
AR
Arlean
1 year ago
I agree with Gabriele, a Roll-up Summary field makes sense to track number of visitors.
GA
Gabriele
1 year ago
I think the administrator should add a Roll-up Summary field.