Creating exclusive articles with Pages databases

In this bonus lesson I explain how I built this very section on opentype.space, where database records can be accessed by anyone, but only paying members will see the actual course content and everyone else is encouraged to upgrade their account to get access. 

Background: With Pages databases you can easily set custom permissions on the category level to offer content exclusively to certain member groups, like your paying members. But there is a problem: if you remove the access for guests and regular members, the exclusive articles will be completely hidden from anyone who isn’t already in the member group that has access. So the users who don’t have access do not know what they are missing and the articles cannot act as advertising for the exclusive content and the paid memberships. Even if you would manually link to those exclusive articles, users without access would only see a generic error message that wouldn’t encourage them to upgrade their account. In this Academy lesson, I am explaining how I solved this problem for this website and I provide the necessary code, so you can add this functionality to your community as well.