1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
Dismiss Notice
Hey Guest, we are running a Photoshop competition with a 32" monitor as the first prize - See here for details.

Smart Google Forms

Discussion in 'HTML, Graphics & Programming' started by DireEmblem, Sep 22, 2018.

  1. DireEmblem


    Joined: Aug 25, 2008

    Posts: 681

    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?
  2. AHarvey


    Joined: Mar 6, 2008

    Posts: 9,253

    Location: Stoke area

    I've not used forms for anything other than basic data collection but you may be able to look at the API for it and find something that works.