AnsweredAssumed Answered

Sorting repeating field - adapted Music Library template

Question asked by cdubbya on Jul 29, 2009
Latest reply on Jul 30, 2009 by cdubbya

Title

Sorting repeating field - adapted Music Library template

Post

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 

However, 

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)  

 

 

 

Outcomes