Use magic text with many-to-many relationship

Get Help
1

Hi everyone,

I would much appreciate your help here.

I have two collections, related many-to-many. For example, users and favourite desserts. A user can have many favourite deserts, and a dessert can be related to many users.

I can’t figure out how to use magic text to show the favourite desserts of a user. It only gives me the option to show the count of them, but not the actual desserts.

Does anyone know of a solution or workaround to this?

Thank you.

2

Hi @charleshope :wave:

Add a list and set the collection to the Desserts collection and set the filter to Logged in user > Desserts. Then rename the Title as Current Dessert > Name

Here’s a quick app I created.

Hope it helps!

Thank you

3

@Dilon

Yeap, that did the trick. Although I wished magic text had that capability of presenting the data instead of just the count.

Thank you very much! :pray:

4

Your welcome :+1: