• Payment Plugins Poll

    We need your feedback on the need for updated payment plugins. Please go here and give us your feedback.

  • Joomla 5.1

    For running J!5.1 you must install Fabrik 4.1
    See also Announcements

  • Subscription and download (Fabrik 4.1 for J!4.2+ and J!5.1) are working now

    See Announcement
    Please post subscription questions and issues here

    We have resolved the issue with the J! updater and this will be fixed in the next release.

Ideas round a database/Fabrik problem

FilMar

Member
Hello I'm looking for some ideas, pointers to solve my problem.

For a sportclub I need to form each matchweek some teams. Now I'm using an excel sheet for that
Here a simplyfied view: on the left a list of players with a number and name, above the list of weeks
and then in each week-column the letter for the team the player will be member of (where x and R have special meanings)

View attachment 17381

I search a way to put the thing in Fabrik as I have already a table with the players and a table for the weeks (with some extra data) and so on.
Database wise I do need an extra table that holds the playerNr, the week and the Team. but how do I put everything together (in Fabrik) so that it is easy to use.
I looked for the pivot plugin but that only does counts/sums, I can't use that to show the teams in a table form like the excel-sheet.
Ideally I have also a function to copy a week to another week as starting point as most of the times the teams rest the same...

Any idea's or pointers are welcome,

Filip
 
Back
Top