Have never had a need for this before, but how would you get a calculated field in a table? Have a simple table of race results.
Name Race1 Race2 Race3 Race4 Total
Joe B. 15 10 13 11 = total points minus worst result
Can anybody help or point me in the right direction? Thanks!!
where do you get this race-points from?
Will be typed in by the client. They can of course also be asked to calculated them separately and then insert the result, but currently they use a GoogleDocs spreadsheet so I wanted to preserve the functionality if possible.
So they are typing data into a Google Docs spread sheet? Can the spreadsheet do the calculation for them? Not trying to be a smart ass, I’ve just never had the occasion to set up a google doc spreadsheet - I’ve extracted data from them a couple times.
If this was being entered into a form the obvious answer would be either a little javascript (which could display the calculated result on the entry page) or a bit of php code after the upload.
Not being a smartass either ;-) but I am assuming so. Their current one doesn’t actually have this field and only lists the race results but they were asking for this on the website. I am trying to just use a simple table for them to fill in. You know what, they’ll just have to get their result from the spreadsheet and transfer it into the site manually! Am unfortunately neither a JavaScript nor PHP whizz, so they will have to meet me half-way. This is just for one racing class. For other classes, they use an external software to make all the calculations and that spits out a html file I can link to.
Thanks though for your reply. Knew it wasn’t anything straightforward...
