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.
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.
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?
@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
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.