Bulding relationship between tables

  • Resolved ursberger67

    (@ursberger67)


    4 years, 4 months ago

    Hi Tobias

    I have the following question. I have to buld a sportswebsite who has 36 Teams on it. Each Team will play in theire respective leagues. For this I do have the Plugin Sportspress that does manage the games, the outcome of the games and the standings. So far so good.

    But know it gets tricky. Each team has at least 23 Players. Those 23 PLayers got statistics onn each game played. Now I have the statistic available, but I can not output it game by game as sportspress does not (yet) support that. So my work araound is, to use Tablepress for the game to game stats.

    So I did install the plugin, uploded the players and theirs stats. But now I did run in to my problem. I dont want to manually update each player game by game. I would like to have the possibility jus to link the game stats to the players stats and that those statistics show on the Players tables.

    An example. Player A plays for team A and score 1 Goal and get 2 Assists. Player B plays for team B and has 2 Gaols and one ssists.

    So I have bothe players in the game sheet and when I import the data they will get importet to the team and theirs season stats. Thne the data will be calculataed and presented on the front end.

    But thats not all I want. The data should update the games stats of the player of tat special game. and the stats should be updatet only onces and not for all players manually.

    So, is it possible to link the Player to the Team table stats and vice versa so I do only have to do it once? And if so, can I pull the results dynamicaly because I use Elementor? SO like player A has his own profile get automatcly set up as a template, that I then can reuse it to all the other players to and it would create theire own tablepress tables?

    Kind of a long question, I know. But maybe its just a hint or so I do need. BTW, Im not a coder by all means. Im just a simple deigner that has some baackground knowledge of HTML and CSS.

    Cheers
    Urs ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    I see what you mean, but unfortunately, I’ll have to disappoint you here. Something like this is not possible with TablePress. It’s not a full-grown database management system that can handle such dynamic table relationships, but can only present fixed static data.

    Regards,
    Tobias

    Thread Starter ursberger67

    (@ursberger67)

    Hi Tobias,
    thanks for the quick reply. I thougt that this may not be possible.

    Would it be possible, just to have for each single team and playxyer thire own table and then link it trough with the shortcode to the respective player or team and set the tables that way, that I can hande the shortcode in a loop or so? So when I crate the table(s) I can just write an array or so that it gives me back the proper shortcode?

    I Mean somthing like player_a = shortcode-xx, player-b = Shortcode_yy and then populat it/loop it throu ?

    Cheers
    Urs

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    retrieving the data from a common table could maybe be possible by using the TablePress Row Filter Extension from https://tablepress.org/extensions/row-filter/

    I just don’t see a way to update the data in the table in an automatic way though. You would have to update every table manually here.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Bulding relationship between tables’ is closed to new replies.