I am working on an inbox system to receive replies from people who a mass email is sent out to.
The recipients complete a survey with a message field at the end.
I want it to sort by:
- Yes/No field (whether they’re interested or not)
- Yes/No field (unread)
- Time/date (newest at the top)
Is there a way to do this? I basically want all the ones that are “Yes” to field one to be at the top, then within that group of “yes” forms, I want the unread ones (“yes” to field two) at the top of that, and then within those unread ones (and the other categories) I want it sorted by date with the newest at the top.