Trying to build a team availability...

User 476017 Photo


Ambassador
375 posts

Hi
Our rugby club based in Uk runs 12 junior teams and the coaches wanted a simple way for parents enter whether their son was available for a match or not.
I thought ahh a simple form with a list of players in the team and a drop down yes/no selection box but realised after parent 1 had entered their selection on the form when parent 2 enters their selection the form does not retain parent 1 selection.
Is there a way form builder can retain data entered on the form. I could see a way to do this.
or has anyone got a simple way I can achieve this
see link
http://www.orrufc.co.uk/reds_intro.html
Dave Butler
Yorkshire
England

Old Rishworthians Rugby Union Football club http://www.orrufc.co.uk
Tuxedo Junction Yorkshire Function Band http://www.riley-tuxedojunction.co.uk
The Commons Guest House http://www.thecommons-guesthouse.co.uk
all created with Coffee Cup html editor
User 187934 Photo


Senior Advisor
20,181 posts

I guess I'm not sure what your after as I don't see a parent one or parent two option on the form.
Are you looking at generating a list of players that have already been submitted?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 476017 Photo


Ambassador
375 posts

Eric Rohloff wrote:
I guess I'm not sure what your after as I don't see a parent one or parent two option on the form.
Are you looking at generating a list of players that have already been submitted?

Hi Eric
The just displays 2 players names at present as a test normaly it would have a list of say 22 players who play regular for the reds squad.
My idea was for the parent of the player to call the page and select available yes/no and a reason if not avaiable.
I then realised this information is wiped out and restored to the default values when other parents log in to indicate if their son was available to play.
The idea was for the coaches to view the form and see if he has enough players for the game to go ahead on the day..
What I am looking for is to create say a small table/list/form with a list of players which allows parents to select whether their son is available to play or not. The coach can then see how the team is building up during the week and chase parents who have not selected their sons availability . After the game is played the coach can reset everything ready for next weeks game.
Just wondering if there is anything in the coffee cup products that can do this.
regards
dave
Dave Butler
Yorkshire
England

Old Rishworthians Rugby Union Football club http://www.orrufc.co.uk
Tuxedo Junction Yorkshire Function Band http://www.riley-tuxedojunction.co.uk
The Commons Guest House http://www.thecommons-guesthouse.co.uk
all created with Coffee Cup html editor
User 2736027 Photo


Registered User
68 posts

Dave,

I think I get what you are trying to achieve, and the answer would require a bit more thinking.

The form can be considered just a blank sheet of paper, with some questions (or selections) on it. This should be considered as "the parents input" to something else. The "something else" would be a storage mechanism, such as a database, located separately. As parents pull up your on-line form, they would make their choices as you suggest, but when they 'Submit' the form, the inputted data would be added to a database.

A coach would need access to this database, to see in a real-time basis, which parents have responded, and which players would be available. I don't believe the form has the ability to "read" the database and fill the data of those players already confirmed, or not confirmed, (but I may be wrong). Hopefully someone else could answer that for you.

Regards
User 187934 Photo


Senior Advisor
20,181 posts

You could mysql or csv to hold the data then a little php to display it on a separate page.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.