Sorting a collection list based on number of multi-reference items

Design help CMS
1

I am trying to create a “top 50” collection list based on how many people recommended an item. I have a multi-reference called “recommended by” and the values are the profiles of people in a CMS collection.

How do I sort the “Top 50” collection based on the number of “recommended by”?

Screen Shot 2021-05-31 at 11.54.20 AM
Screen Shot 2021-05-31 at 11.54.20 AM980×526 327 KB

Here is my public share link: https://bitcoiner-books.webflow.io/top-50

https://preview.webflow.com/preview/bitcoiner-books?utm_medium=preview_link&utm_source=designer&utm_content=bitcoiner-books&preview=e36692f4fd95cf8460b8e385555ccd90&pageId=60b1797a57e59be8cf3a66b6&workflow=preview

2

If your data was in Airtable, you could add a formula field, e.g., COUNTA(RecommendedBy).

Then, using a tool like PowerImporter to sync Airtable to Webflow, you could map that count field to a numeric field in Webflow. Then you could sort on that numeric field.

3

Thanks a lot for the reply, Marc. Will check out that, but prefer a solution integrated in Webflow.

4

Ever find a solution for this? Im looking to do something similar without using 3rd party integrations if at all possible.

5

You can do this with a jQuery sort, and element count.