Associate
- Joined
- 25 Aug 2008
- Posts
- 947
Hi there,
So I have a google form, where a user has to pick 5/100 horses that are racing at the weekend. These picks then go into a list, and entries earn points based on finishing result/ small bet based on odds in the selection pool.
What I would like to do is make it a bit smarter - I would like to price in each horse, and only allow the selection of 5 horses through if they total the correct range of net prices.
How would I go about this - having the goggle form tally up the prices for the horses selected, and only allow the form to be submitted once 5 picks have been made, in the correct total range?
I.e I dont want someone to pick the top 5 favorite horses, nor do I want them to pick complete outsiders in every single race. The idea is to have a sensible pick that has the best average result over a season.
Any ideas?
So I have a google form, where a user has to pick 5/100 horses that are racing at the weekend. These picks then go into a list, and entries earn points based on finishing result/ small bet based on odds in the selection pool.
What I would like to do is make it a bit smarter - I would like to price in each horse, and only allow the selection of 5 horses through if they total the correct range of net prices.
How would I go about this - having the goggle form tally up the prices for the horses selected, and only allow the form to be submitted once 5 picks have been made, in the correct total range?
I.e I dont want someone to pick the top 5 favorite horses, nor do I want them to pick complete outsiders in every single race. The idea is to have a sensible pick that has the best average result over a season.
Any ideas?