HubSpot Data Model / Filter on associated objects / Activation with lists or workflows
Tuesday - last edited Tuesday
I hope you are all doing well and thanks to read my post! 🤗
I work for an actor of the nursery and I'm going to tell you my issue:
I need to have a contact database that contains parents and children. The parent has the main email address (that's who I want to talk to) but the child has the main information (what type of program is being followed, how old is he or she...).
With a custom object: Create a child custom object and Use contacts as parents.
Problem: I can't create lists or workflows based on children which select the associated parents.
Without custom object: One contact = one child.
Problem: I am going to have children who have the same email address several times (because a parent can have several children). But I don't want to send several times an email to the same person
Without custom object: One contact = one parent and I use custom properties to insert information about the child
Problem: I duplicate as many columns as there are children, lack of readability.
Do you have convictions about my different hypotheses, do you have good ideas if you use a similar model in production?
Thank you in advance for your answers, see you soon.