+- +-

+-Newcomers Start Here

+-Harlequins/Rugby Links


Author Topic: Team picker  (Read 3522 times)

0 Members and 0 Guests are viewing this topic.

never sleep

  • Lions Captain
  • ******
  • Posts: 1141
Team picker
« on: Monday 11-Nov-2019, 14:54* »
During my copious free time last week, I created a "Team picker".

And here it is -

You can go into the team picker from Monday morning and start picking your team for the next game.

The results can be viewed after you make your selection, but are best viewed on this link:

My aim is to create a summary every week before the teams are officially released (e.g. on Friday at 11:30am).

For anybody interested, this is how it works:
The form is a Google form that captures the responses and saves them in a Google Sheet which I have shared.
The Google Sheet has various tabs.  One of the tabs is all of the selections.  The "Current" tab shows selections since Monday morning.
The Sheet "just works".  I do not need to do anything to update the results.  I will need to make alterations to the Form though as the squad changes (e.g. I will remove Joe Marchant when he goes to the Blues).
There are charts on the Forwards and Backs pages which analyse the results.  I will be creating a "Backs 2" page in the near future.
For the people who value their privacy, there is no private information stored anywhere.  There is an option to enter a Nickname.  If you are happy to do so, then you can enter the same name as you use on this board.  From a GDPR perspective, this is essentially anonymous data.  All data collected is public.
For support purposes, all issues with the above system will be dealt with as follows:
Priority 1 - resolved within 1 hour; Priority 2 - resolved within 2 hours; Priority 3 - resolved within 1 day; Priority 4 - Best endeavours.  All issues with this system will be categorised as Priority 4.

And lastly, many thanks to InsertQuinsPunHere who has introduced me to the amazing "=query()" function.  Without this, the dashboards would need constant refreshing.
Also, thanks to the people who provided feedback on Friday.  Please continue to do so and I will endeavour to continue making this better. 
« Last Edit: Sunday 13-Sep-2020, 21:31* by Admin »

Share on Facebook Share on Twitter

Like Like x 1 Winner Winner x 1 View List


  • Administrator
  • Gold Member
  • *
  • Posts: 274
Re: Team picker
« Reply #1 on: Sunday 13-Sep-2020, 21:33* »
Removed all old posts regarding this.



Welcome, Guest.
Please login or register.
Forgot your password?

+-Site Statistics

Total Members: 809
Latest: Bail0018
New This Month: 5
New This Week: 0
New Today: 0
Total Posts: 51407
Total Topics: 2975
Most Online Today: 122
Most Online Ever: 705
(Monday 02-Dec-2019, 13:56*)
Users Online
Members: 22
Guests: 81
Total: 103