Contacts view customized with grid (One-to-Many relationship)

My contacts represent patients. I built a custom object for the patient journey, which contains the unique ID for a doctor as well as patient. For the patient, I have a series of dates with various events that happened to the patient (diagnosed, received an injection, etc.). How can I embed a grid-like view using one of the middle tabs in the Contacts interface? For MS Access users, this would be a subform within the main form. HubSpot wants to seemingly create a form but it is not for user entry. I want the MS Excel look - just a simple grid of rows with the event date and description on each row.

Hi @camubaa,

Could you explain in a bit more detail which associated object’s record you want to display on the contact – the patient journey or the series of dates?

In any case, when you add a middle card, you can see your options for associated records / objects by searching for “associa”: Customize records

I’m not sure what exactly you mean by grid – if you’re looking for a calendar like view, that would currently (natively) only be possible through the “Allbound Timeline” element. That would however require that you document your dates as inbound and outbound activities on the contact record, not as associated records.

If your desired visualization is not listed in the record layout options, then you would have to create a card for yourself, requiring development:

Best regards!

The definition of a patient journey is a chronological order as to the list of events that occurred to a patient. On Jan 2, Patient A received a diagnosis, 2 weeks later - a biopsy, few days later - a pill. Simply relate it to your own life when you have visited the doctor. The attached picture is about as simple as I can explain it.

@camubaa I understand what you’re saying.

What I’m seeing in your screenshot is rows for records, columns for properties, sorted chronologically.

That exactly what this element is offering:


@camubaa have you followed the instructions from my previous reply?

The association table seems very close if not exactly matching what you’re describing.

If that is for some reason not sufficient:


If your desired visualization is not listed in the record layout options, then you would have to create a card for yourself, requiring development:

https://developers.hubspot.com/docs/apps/developer-platform/add-features/ui-extensibility/app-cards/…

https://developers.hubspot.com/docs/apps/developer-platform/add-features/ui-extensibility/ui-compone…

Sorry for thd delay. I was able to figure it out although HubSpot doesn’t make it look pretty. HubSpot via Google Chrome vs iPad are two completely different interfaces, so I’m unable to see the rest of the fields on the iPad. We’ll try to make it work for now - it’s clear though that HubSpot is not the best CRM tool for the life sciences industry.

Hi @camubaa and thanks for the update!
Can you share more about what an ideal grid view would look like for your team?
Your feedback about the interface differences and life sciences needs is really helpful, feel free to add any specifics.
I’ll share your feedback internally.
Thanks and have a great day!
Bérangère

A grid is simply a table, think MS Excel. In its most simplest form, I wish to see these fields: PatientID, Sequence, Encounter Date, Encounter Description. Sequence begins with 1 and increments by 1. Encounter Date is simply that, and Encounter Description details what happened to the patient (ie. received an injection). The underlying custom object entitled PTJ has the contact’s (doctor) NPI to perform the join.

At the end of the day, when I click into a contact (doctor), the middle tab is entitled Patient Journey, and the grid is displayed there. It seems simple in theory but not with HubSpot.

@camubaa have you followed the instructions from my previous reply?

The association table seems very close if not exactly matching what you’re describing.

Hi @camubaa

What you’re trying to build is doable, but only within the limits of how HubSpot displays associated records today. When you add a middle card to the contact layout, the association table is the closest native option. It shows each PTJ record as a row and each property (sequence, encounter date, description, patient ID) as a column, sorted the way you choose. HubSpot outlines how to add those associated object tables to the record layout here (Customize records )

If the association table still feels “too HubSpot” and not enough like the flat Excel grid you want, that’s where UI extensibility comes in. You can build a custom card that renders exactly the table in your screenshot with your own sorting and columns. HubSpot provides the developer references for those cards here (Accounts Dashboard | HubSpot )

Before you consider that route, one quick question. Does the encounter data come from an external clinical system? If so, keeping those PTJ records in sync with contacts and doctors can get tricky. Stacksync keeps those associated objects aligned in real time so the grid you show inside HubSpot always reflects the actual timeline. Hope this helps.