In the tournament organizers dashboard I would like to add a button in each match that indicates the winner.
The idea is that in match 1, when indicating the winner, I indicate the names in row 17 cell 6 (Winner O1), the winner of match 2 in row 18 cell 6 (Winner O2)
But I think that with that action I cannot achieve what I want.
I mean for example,
Is it possible to put an action from line 1 so that a piece of data from that line is placed in row 17 cell 5?
Within an already created row. That is, it would be like telling Glide that the winner of match 1 (row 1 cell 5) should be indicated directly in row 17 cell 5 (where the rest of the cells: 1, 2, 3, 4, 6… already have the information). The winner of match 2 in row 18 cell 5. The winner of match 3 in row 19 cell 5…
I don’t mind creating an action per row, I just want to know if that possibility exists.
If you want to reference the winner of match 1 in rows/matches that come after, you’d want to use computed columns to achieve this I think. I’d imagine you’d need a helper column to indicate which match winners should also be displayed/connected to following matches. Then build a single relation on that helper & look up to display the previous winners. Are you trying to create a bracket view?
I think you can set up a “next match” column for each row.
Say match 1’s winner will play in match 17, then your “next match” column will contain the value 17.
It’s not fully clear to me so I’m making a guess here, these are double matches and each of your match would consume 2 rows, each row containing the name of each pair in the Pareja column.
Then, if you have the “next match” setup correctly, you can:
Add a query in that same table, filter by “Partido” is “This row > Next match” and “Pareja” is empty.
Add a single value column, select First > Whole row from the Query above.
When you select a winner from Match 1, do an extra set column action to the single whole row, setting the name of that winner to the Pareja column.
This will work 2 times due to the “Pareja” is empty filter in the query, and effectively set 2 winners up to the next match’s 2 rows.
I wish I could help more. I agree with @ThinhDinh 's suggestion to progress the match along the row by adding a winner’s column for the matches.
I believe that since you have simultaneous results from other matches, the logic gets a little hairy…
At the moment, all I can think of is adding multiple actions that populates the winners in various rows.
For instance, for the first round, at the end of the match in line one, a winner button can set the name of the winner to the winner column, as well as add a row to a winners table (to feed a choice component). Then for the 2nd round of matches, you can have a choice component to select from the list of winners and write the selection to the relevant row.
Not sure how easy it will be on the back-end with your current data structure. I’d probably want separate tables for the different rounds to minimize the chance of accidentally overwriting important information.
