Notion relations

At a glance

The community member posted a question about how to display the host's information (name and photo) and a link to the host's dynamic page on the event's dynamic page, using a relation property between the event and person databases. The comments suggest that the issue is related to the Notion API, and a community member recommends using Rollups to solve the problem. Another community member confirms that Rollups are the solution, but some additional troubleshooting is required to get the Rollup to work correctly.

Useful resources

DDaniel Kozma

Hi, thank you for the notion integration tutorial, loved it, super helpful!
One thing I couldn't figure out:
Let's say I have a database of events and a database of people. Every event has person attached to it (eg. the host of the event) using a relation property. On the dynamic page of the event, I want to make a card for the host with their name and photo, and a button that links to the dynamic page of the host person. Can you help me figure out how to do this? When I get to the relation property in the expression edition I can't seem to go any further.

23 comments

BBogdan

There is either no relation or it is an object. Please inspect notion data variable

DDaniel Kozma

I realised the related database wasn't shared with the integration. Now I can access to id of the related item, but nothing more. Do you maybe have an idea where to look further?

Attachment

BBogdan

I'm not familiar with notion databases. @John Siciliano maybe you know?

OOleg Isonen

@Daniel Kozma your problem is with notion api, not webstudio, probably a better place to ask these questions is in some notion api related forum or something they probably have

JJohn Siciliano

Rollups will probably do that trick https://www.notion.so/help/relations-and-rollups

DDaniel Kozma

@John Siciliano that's it!!! thank you so much 🙇‍♂️

SSruly

Hey how were you able to get this to work? My rollup comes in showing an empty array even though there is data in it

JJohn Siciliano

I may be able to help if i see a screenshot of the relevant part of notion and a builder link

JJohn Siciliano

maybe dm if api keys

SSruly

Thank you so much! So I am connecting to the Notion db, because without the filter I getting the attached response, but then when I apply the following filter:
{
"filter": {
"property": "Rollup",
"rollup": {
"any": {
"rich_text": {
"contains": "text a"
}
}
}
}
}
I get no response.
The notion table looks like the attached image.

Attachment