+- +-

+-Newcomers Start Here

+-Harlequins/Rugby Links


Author Topic: Team picker  (Read 6027 times)

0 Members and 0 Guests are viewing this topic.

never sleep

  • Lions Captain
  • ******
  • Posts: 1387
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 »
Like Like x 1 Winner Winner x 1 View List


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

never sleep

  • Lions Captain
  • ******
  • Posts: 1387
Re: Team picker
« Reply #2 on: Thursday 26-Nov-2020, 14:57* »
I have started adding an option to choose for positions 16, 17 and 18.
You are now prompted to choose a "main" and "bench" option for the front row.

The "Results" link is still "work-in-progress".
Like Like x 1 View List


  • Lions Captain
  • ******
  • Posts: 1845
Re: Team picker
« Reply #3 on: Sunday 07-Mar-2021, 16:23* »
Nonsense pen. They stopped pushing.
Informative Informative x 1 View List



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

+-Site Statistics

Total Members: 902
Latest: Big Chief Little Chief
New This Month: 27
New This Week: 19
New Today: 4
Total Posts: 69698
Total Topics: 3776
Most Online Today: 448
Most Online Ever: 2671
(Tuesday 11-May-2021, 21:20*)
Users Online
Members: 56
Guests: 220
Total: 276