Members "saving" a shortlist of items to refer back to

Ask the community
,
1

So the main point of my site is it’s a database of ski resorts
Each ski resort is an item in a collection
I want members to be able to “save” the ones they like into a shortlist that they can then access from their profile / a custom member page.

However, I want this to refer to the ski resort dynamic page, not just copy all the info over to a new item, cause i’m constantly updating and adding stuff to them.

If members had a collection I would assume I could add reference of some kind, but I don’t know where to start.

The mechanic I’m thinking of is that there’s a button on the items repeater page like “add to list”
then i just add a members repeater page that they show up on in the members area

2

Hey @founder53806!

There are a couple of ways to approach this, but this is the way I would likely do it.

Have 2 data databases, 1 for “Ski Resorts”, one for “Shortlist”.

When someone clicks on the “Ski Resorts” item and saves it, then it would insert an item into the “Shortlist” database. The shortlist item would likely have 2 fields at a minimum. One referencing the member, and one referencing the Ski Resort item.

That way, the Shortlist database has all of the shortlist items, and each item has the member that made the shortlist item, and the item that was shortlisted.

You can then filter according to the user and show all their items.

There are other approaches that may be better structured, like using the member database, with a multi-reference to the Ski Resort.

Each member would then have 1 row in the members database (default Wix database), then the Ski resort would have a reference to the members.

That way, you can see on each ski resort, which members have shortlisted it, and from the member view, you can see all the Ski resorts that they’ve selected.

Thinking about it, the second approach is likely better, and would work more easily.

I hope that gives you some ideas to play around with. Sounds like an interesting project :slight_smile:

1 Like