Sorting collection lists by image?

I have a membership website where users update their profiles. A chunk of the users don’t add in their profile photos and that’s the main thing you see on the directory page. We get a lot of signups at events where they don’t have a photo to upload and we have a pretty low rate of going back to update things. So we have a grey placeholder image.

I can filter by images, but I don’t want to filter out a whole grouping of folks. It’s part of their membership.

I’d like to sort by image, but I don’t see a way to sort by image. Does anyone know of a workaround or solution?

I’m using airtable as the database, so I’ve considered adding a new column that checks if the profile column has a photo. If it does then it marks a binary 1,0 and then I can sort off that. But I was hoping to do it without that step.

Here is my public share link: [LINK][1]

Hey, try out this way from finsweet: Sort items in a Webflow CMS dynamic Collection List
i’ve used it many times and it worked well.

Thanks @Philip6 - I’ll check it out. I’m using Jetboost right now that also has some dynamic sorting, so between the two I might be able to get it to do what I want.

I wanted to close out this thread so folks know what I did. I ended up not going the finsweet route. My site is for a non-profit and we just didn’t have the funds to test out if it would work or not.

I ended up adding another field in airtable that pushed to webflow that was a basic binary has photo (1 or 2/Yes or no). It is auto populated based on if it sees a link to the photo in a different column.

Then in Webflow I sorted first by if they have a photo, then by company name. It’s alphabetical, not random, BUT it showcases those with a profile photo above those who don’t have one.