Race Results Rank by Class and Special Recognition

Need help Database
1

I have a race results database to collect finish time of racers in minutes and then calculate the finish time with any time penalties (see column 08). I can easily get a repeating group to list all of the race results sorted by finish time (to get overall finish results) but I am struggling with getting the 04 Class Finish Position to dynamically update. Basically I want a backend workflow or a temporary repeating group to go in and check for each instance of a 02 Class Entered and put the order in which it appears into the column 04 Class Finish Position.

BubblePositionRankExample
BubblePositionRankExample1484×281 25.4 KB

I have been able to make a temporary repeating group that narrows down the boat numbers by class and rank them and I have also been able to generate a custom state list that ranks the boats, but I have been unsuccessful in passing those results back to the correct column in the database.

Any suggestions welcome!

2

could just do a search within the rows in the repeating group

yes - it uses WU and is not ideal but it is simple

otherwise you’d need a unique data for the repeating group that you’d need to update in the backend and then display in the repeating group. this could be triggered from when another data changes it’s data - create/update the aggregate record.

if you need to view the data regularly or export it then you’d need to do the aggregate record method. if the data is viewed infrequently you could cheat and use the search within repeating group method.

the search in repeating group method does a search for each row so every time the row is displayed so it is not the most efficient but it is one way to do it.