I have users upload multiple photos and I am looking for a way for the user to choose what order the photos are displayed in.
I currently have a field in the Photo object named Photo Order, with a dropdown numbered from 1 to 20. Then a list that displays the photos in photo order.
It sort of works but users can select the same number for a different photo. If they upload 5 photos and used the Photo Order #1 for all of them, then it's a lucky dip which order they will be displayed in.
Any ideas on a better way of achieving this?