I have a collection with a list of 12 records - one for each month of the year.
I have a second collection with 60 records. There are 5 records per month and they are linked together so when you click to enter into a month, eg January, you’re brought up with a secondary list (the 5 records from second collection).
Now, in time, I want to add new records to the second collection… so, for example, I want to add a 6th record to a month, but I want that new record to go to the bottom of the list when it opens up in the app. At the moment when I add a new record it appears at the top of the list.
Is there a way to dictate where each record appears in the second collection?
Does that make sense?! I’ve attached some photos that hopefully explain.
Oh no… I’ve come unstuck… I added a test record and when I filter oldest to newest it then moves around the other ones… Image attached (celebrations should be the top one). Guessing this is because the way I originally uploaded them all so they would appear in this order.
Sadly not… Image attached.
The order you see them here is the order I wanted them to appear in the list so I uploaded it all backwards at the start.
When I do ID low to high it would work it theory, but because I uploaded them backwards, it’s skewing it!
I think I’m going to have to reload all them aren’t I?!
Thank you SO much for your help though, I really appreciate it!
Add an additional column - make sure its number based - and call it something along the lines of “custom order”
You can then number them in the order you’d like to appear and sort by your “customer order”. Involves a bit of work involved if you want to re-arrange them but it should do the trick