Results as google sheet data.

[On Track And Snow]

Hi!

Would it be somehow possible to get data automatically from running competition directly into google sheets/drive, or is it right now manual? 

Idea is to use results from the data sheet as the input on the live broadcast graphics (results table, last finishers), would be awesome if in somekind of superb announcer view(Broadcasting view) it would be possible to edit the design of result table, to crop and display the results live. And option to choose the competitor and time (splits, laps etc) to show one line under the competitor currently live on broadcast screen.

Maybe it's little out of this program league. And should look somewhere else or towards personally developed timing system (like done for FIS or IBU competitions.) We are currently just a 2 man team (timer and me as broadcaster) for smaller competitions and would be awesome to make the timing software more broadcasting friendly. 

Best regards!

Jarmo

[Vesa Suomalainen]

You can use the JSON API to get programmatic access to the live results data.

Instructions: https://www.webscorer.com/blog/post/how-to-access-race-data-via-json-api

[Bubilo Chiban]

  Webscorer has an option where it shows all the results from its website in a JSON format. With that, any programmer with very little experience can use the data to build whatever they want — from Excel spreadsheets to online web pages.
I personally use it to display my results on my own website www.bubilo.com.ar, and also to send WhatsApp messages to runners as soon as the race finishes.
Vesa will surely explain this feature better.  

[Tim Mockford]

Hi,

I do this. You can create a google apps sheet (my was done by trial and error and googling and copying) which imports the data. Then it's up to you with how to deal with it from then on. Ive attached my custom functions app sheet as reference. It puts all the results into a sheet called Raw Results and pulls details from cells in the sheet Setup. Code should be ok to follow. Hope it helps.

Long term I want to write a python application to take care of text messaging and award coloured medals at sportives, but not there yet.

Many thanks

Tim