Sorting repeating field - adapted Music Library template
So, I'm using parts of the Music Library solution. Let's say:
I have 40 gizmos (substituting the Album Title for the Gizmo Title)
Each gizmo is changed or revised every week - Rev A, Rev B, Rev C, Rev D, Rev E, Rev F.
Someone will review the gizmos each week, and give each gizmo a star rating 1-5
So, I have the star rating as a repeating field for the six Revs
Not all 10 gizmos get reviewed each week. So in the fourth week, I could have a scenario like this:
Title RevA RevB RevC RevD
Gizmo1 | *** | ** | * | * |
Gizmo2 | ** | ** | | |
Gizmo3 | *** |*****| | |
I have a field, CurrentRating which uses Last(star rating) for each Gizmo. Based on the data above, in the fourth week:
Gizmo 1 would have a Current star rating of *
Gizmo 2 would have a Current star rating of **
Gizmo 3 would have a Current star rating of *****
Using the 'Record List' layout, the CurrentRating field does display the correct data, but when I click the sort field at the top, it doesn't sort correctly.
If you've worked with this starter solution, could you please help?
I guess what I'm really asking is:
The script that sorts the records for Rating goes like this:
If [Music Library::g_Sortby = 'rating1"]
Set Music Library::g_Sortby = 'rating2"]
Where do 'rating1' and rating2' come from? How can i get these to work on my CurrentRating field, which looks up Last (Repeating Field)