Feb 07, 2020 06:25 AM
I am currently helping move my hockey club from a mixture of nothing, google sheets and pen and paper into something to manage our 8 or so mens teams. I have created a base:
We are trying to figure out how we can count up the votes.
Because everyone in the team can vote and multiple people can therefore get “3-votes” we attached the player record into the 3 vote field. What we want to do now is essentially figure out:
Does that make sense?
Feb 09, 2020 03:34 AM
Im trying to understand your question. Where are those votes coming from for example? It seems to be a lookup field. What do you mean by “most 3 votes”? Does that mean the number of fixtures where he got 3 votes?
Feb 09, 2020 09:40 PM
Correct. I could be going about this all wrong. But essentially we are using a voting form which adds a name into the fixture table, in the corresponding votes field. So the votes are attached to the fixture.
That way, we have a field here, with many names in it. We want to count the names, figure out who had the most 3 votes, then assign them a REAL 3 votes.
Does that make sense?
Feb 09, 2020 11:21 PM
Yes it makes sense. The tricky part here is that you want to count those votes per game, am I correct?
Where is the Form feeding its results? In the last table marked “Votes” I assume?
In this table, you will find the name of the game, and 3 fields showing the 3 Votes, 2 Votes, 1 Vote, correct? If you are on the Pro Plan, a Pivot Table block from this table will show you what you need.
If you are on the free plan, you will need to do it in a different way and it might get a bit too complicated. You will need to set this table as a Pivot Table, i.e.: there will be a Field for each Fixture while the Records will be the Players names (to be linked to the Players Table). The form will then have options for all the Fixtures (in the same page) then you will choose the Players Name in the start and cast your vote for each game. You can change the form every few weeks to include or not include the game you want. After you are done doing that, you make a Rollup field in the Players Table to count the votes (take care that since the Player is linked to the form list then it will create new fields in the said table)
Hope this is of help
Feb 10, 2020 12:36 AM
We are on the pro, but ensure if this will be forever with this being a NFP, depending on how many logins we need for it.
We have done it this way, as it seems one of the best ways to allow us to run forms to essentially write to the fixture record each week. We have 4 forms:
The forms mean each player doesnt need access to the DB and we can keep everything on the fixture record that is about the fixture. I think I am doing this right.
We are using filters and views to mean that avaialbility is for the upcoming week only, the votes for the past game, within 5 days and the team managers sheet is only for the past game, within 3 days.
Thanks for your help!