Personalising Content Aggregator

I’ll try to explain it but I’ve recorded a video of the challenge I’m facing here: https://www.loom.com/share/389a2451cbab42f69a1c2f223183ef67

I’m trying to create a one stop shop for all things personal finance.

One of those things is giving people content that they’re interested in. Right now, I have 3 main sheets: the main (where other personalised things will go), the content sheet (where all content lies) and the subscription page (where a new row gets added once they subscribe to certain videos).

What I’d like to do is on the home page, show them the x newest videos based off what they’ve subscribed to (content), however all I’ve been able to do is create a multiple relation list to the subscription page.

I tried to create a multiple relation list on the content sheet, but then I found out that I can’t actually match emails to a relation list.

Is there any way I can work around this?

Thanks in advance!

Hi Moneymagnet,

Welcome to the Glide forums!

I think your solution will require multiple logic implementations: Logic on the Data editor, and logic on the Google sheets.

To start I would suggest you read this documentation:

User Profiles

https://docs.glideapps.com/all/reference/privacy-and-per-user-data/user-profiles

“Next, you could set visibility conditions on some of your components using this column. This way, you could hide ‘premium’ content in your app to free users and unlock it for paying customers.”

How will you be publishing the newest content? By manually adding it to your sheets or through an automated method/service?

Cheers!

Thank you!

The solution for those interested is using a lookup on the main page to pull the actual channel names into the main page. Then use a relations to connect the channel to the videos :slight_smile:

RE content - I’m using RSS feeds via zapier.

1 Like

Happy that you have your solution!

Share your app with us when it’s ready :slight_smile:

Cheers!