• Hello -Thank you in advance for helping me out -love the plugin! I am trying to set up the database so that a coach can sign up a team and add players. Basically, I would like the coach to be able to add the team at first with some basic info at first (using the signup shortcode), then when the coach gets the email to go into the record, they can add individual players to the team they set up. Once the coach has added players, he can view his entire team and edit an individual if needed. Is there a way to do this so that the coach can only access his team? There will be other teams registering as well so it would be important not to display all records to anyone, just having the coach have access to his team.

    I looked through your other support threads and did not find an answer. It is kind of similar to the person that was trying to create different groups, except mine would need to be private/only accessed by the coach that setup the team.

    Thank you so much for your help!!!

    https://ww.wp.xz.cn/plugins/participants-database/

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

    (@xnau)

    The plugin is not well suited to applications where you have a hierarchical arrangement of records…such as a team that contains players. There isn’t any way to relate one record to another, and although something like this could be approximated using custom form elements (for instance, a field that is a list of players) that would certainly require a skilled coder to accomplish. Likewise the restriction that a particular coach would only be able to edit player records in their team would be pretty tricky to implement since the plugin isn’t designed for this kind of use.

    Thread Starter CoryGymn

    (@corygymn)

    Ah I see. Thank you very much for the quick and thorough response! Still a fantastic plugin! Thanks!!

    Appreciate this is a while back but I have achieved this to some extent.

    Using post->post_name in a field called ‘event’ I first use field groups to get the team signed up by the ‘team manager’ and send him the confirmation email with a link to another field group for team members with its own event code on a page that is not accessible to the public. So only he has this link.

    When entering the team members the ‘team manager’ has to enter the private_id listed in the confirmation email for the Team ie the ‘team_code’.

    There is no validation for this of course (no doubt could be done) so needs monitoring. It is probably possible to use an SQL addon to relate the table entries to itself (a pigs ear join) using the private_id to the team_id but as it is a one-off situation I just download by CSV using each event_code into Excel spreadsheet and use vlookup() to join them and tweak the data if there are errors ;).

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Team Creation’ is closed to new replies.