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!