Time Addition and Column Sorting

  • Hello,

    I am currently using the SportsPress plugin to add historical data to a Sim Racing League that I run, with the hopes of using it in future Seasons. I've been able to work through most of the issues I'm encountering but I haven't been able to get through these few.

    Box Score and Results Sort/Ordering:

    When Setting up an Event, I'm unable to sort the results by Outcome (or any column for that matter). The default seems to always be alphabetically by Team/Player. Is there a setting I'm missing here? It seems that the Box Score is ordered the same way by default (but it can be sorted by clicking the column header), but my priority would be to fix the Results order. Furthermore, is there a way to sort on two values for Tables? (If primary values are tied, then sort on next value)

    Entering Race Time and Having it Carry Over:

    Currently I have a Player Performance Value called Race Time, that is set to Category All, Format: Time. Is there a way to add decimals so that it displays exact race time? When Entered, the value strips the decimal points upon updating.

    Next I have a Result Field that is called "Round Race Time" with an equation equal to Race Time (The Player Performance Value). If I let it Auto Populate, somehow the value gets converted from Time format to a number. If I input it directly, it stays as entered.

    So for example, a Race Time equal to 2:04.123 gets converted upon update to 2:04 (without decimal). Then when the Result is calculated, 2:04 gets converted to 124.000 for the event result. (number of seconds).

    League Table/Player Stat Totals:

    Finally, For this League, the total amount of time across races is a tie breaker metric. I have a Table Column and a Player Statistic that is set to "Round Race Time" with the assumption that if I have multiple events with the value recorded, it would simply add the values, like it does for Points. However this somehow coverts a time such as 02:03.671 to 2.000 (which is not even the amount of seconds - but minutes instead). In the case of the 124.000, that gets added properly, but again it is just number of seconds, and not in time format.

    Is there any thing that can be done to fix this? Let me know if I should break this up into separate entries.

    Thanks!

    Kevin

    The page I need help with: [log in to see the link]

  • You must be logged in to reply to this topic.