YEAH! This is perfect at least for the issues of getting everything on one line and displaying the correct scores for each round checking if the score in that round should come from Team 1 or Team 2.
Now I'm trying to add a calculating total field. I already have this site set up to do calculations using custom code I found in another support thread, so it should work. But the problem is to get the correct scores to use for each round, I'd have to duplicate all your code using many conditionals.
Here's the code I'm using on the results view to display the totals there that are applying to match scores::
<div style="width: 75px; display: inline-block; text-align: right; border: 1px solid #ffffff; padding: 7px; margin-left: 5px;">[wpv-calculate][types field="team-1-score-mens-doubles"][/types]+[types field="team-1-score-womens-doubles"][/types]+[types field="team-1-score-mixed-doubles-1"][/types]+[types field="team-1-score-mixed-doubles-2"][/types] [/wpv-calculate]</div>
I know that's not what is needed here. I'm just showing you how that calculation is done in that view.
So here, I'd need to add all your conditionals within conditionals to first check for the round number, then if team one or team two should be used and then have the + operator between each. That should be doable.
But I was wondering if there is an easier way. Is there a way to add hidden code that would assign the correct value to new variables? For example: we could define variables with the names rbr-mens-doubles-round-1, rbr-mens-doubles-round-2, rbr-mens-doubles-round-3, rbr-mens-doubles-round-4, and rbr-mens-doubles-round-5. And then within the loop, add some code that doesn't get displayed that will pass the numerical value that actually gets displayed after all your conditionals are gone through for each round to the new variable name. Is that possible?
If that's possible, then to get the correct calculation, the code for that Total column could just be some form of:
<div style="width: 75px; display: inline-block; text-align: right; border: 1px solid #ffffff; padding: 7px; margin-left: 5px;">[wpv-calculate]rbr-mens-doubles-round-1+rbr-mens-doubles-round-2+rbr-mens-doubles-round-3+rbr-mens-doubles-round-4+rbr-mens-doubles-round-5[/wpv-calculate]</div>
without having to redo all the different conditionals. I'm sure my syntax is wrong for how to use these new variables in there though, but I'm sure you get the idea I'm trying to convey with that.
If that isn't doable, then let me go ahead and try to add this total field myself using all your conditionals to get the values again. Just let me know on this inquiry before I do that.
I've added another column to your output in this view:
hidden link
I just did a calculation on 1+1+1+1+1 just to have something to populate that total column for each team now until you let me know about the inquiry above. Adding this has produced mixed results for me on the page here:
hidden link
For some of the teams it did exactly what I was trying to do. But for others it is inexplicably showing additional columns after the total column. I'm trying to do what I can here, but I'm afraid I'm just not very good at this.
Oh wait, now I see why it did that. We currently have R4 and R5 set to display as column headers in all cases, even where there are no R4 or R5 matches. But then your conditionals setup only displays the cell where the scores go IF there is a score to add. Otherwise no cell gets added to that row. So on the header row, we automatically have 5 across, but on the teams with only 3 rounds, they only have 3 across on the scores row. So the rows get mismatched. So I think what's needed to get this right is to set up the display of the R4 and R5 cells on the header row to be conditional on if these fields are not empty. I just tried to do that myself, but I didn't get the output I was hoping for. I think that's because the table header column is displayed outside the loop, so the conditionals doing field data checks aren't working there. If I'm right on that, I'm not sure if it will be possible to do what's needed there the way I'm thinking.
Basically with this we need teams that have 5 rounds to display a table that has 5 round columns and then the total field and teams that have 3 rounds to display a table that has 3 round columns only and then the total field. The R4 and R5 table headers should only display if there are 5 rounds to show for that team. Is there any way to achieve that here? I think once that is done, my total column will line up correctly for all teams, but then I have to figure out how best to get the correct totals to appear. Ideally, the number of R columns would be determined based on how many rounds each team has. That way we won't be limited to only using 3 or 5 here. If we subsequently have a tournament where there are 7 rounds, the view would account for that possibility as well. Can that happen or is that too much? Regardless of this, I think we just need the number of cells in the header row to always match the number of cells in the score row. That way the subsequent Total column will line up in the right place.
