Upload-Email Scorecard

With EasyScore Golf version 2.4 (and above) you can upload the completed scorecard to the cloud, and optionally email a formatted copy. You can use a cloud service like Google Sheet as a destination , or you can write you own HTTP endpoint to process the scorecard data. The upload can occur automatically when you save your round, or on demand. You can also choose whether you want to upload your partner(s) scores as well.

The optional email feature is only available with Google Sheets.

Create Google Sheet to upload scores

You will need a Google account and learn how to create a Google Sheet. This is a free service. There are plenty of references on the Internet to get you started. Follow the steps below to enable EasyScore to publish scores to your Google Sheet.

YouTube Video: Demonstration of this feature

Note: Step 1 through 4 should be done using your computer. At the time I am writing this the GoogleSheet mobile app does not allow you to create script and publish.

Step 1: Create a Google Sheet

Step 2 : Navigate to Tools->Script Editor

Illustration of step 2

Step 3: Paste in sample script to process uploaded scorecard

NOTE: Make sure you first remove the sample code that is added when you initially start the script editor for the Google Sheet. Remove this first:

function myFunction() {

}

COPY the script below and PASTE into the Code.gs using the Google Sheet editor
const UPLOAD_SHEET = "UPLOAD_FROM_APP";
function doGet(){ var sheet = SpreadsheetApp.getActiveSpreadsheet(); var courseSheet = sheet.getSheetByName("Courses"); var HTMLString = "<style> h1,p {font-family: 'Helvitica', 'Arial'}</style>" + "<h1>My EasyScore uploaded scoresheet</h1>"; HTMLOutput = HtmlService.createHtmlOutput(HTMLString); return HTMLOutput}
//Process POST command from EasyScore mobile appfunction doPost(req) { var result = {"status": "SUCCESS","sheet": UPLOAD_SHEET}; try{ // Open Google Sheet var sheet = SpreadsheetApp.getActiveSpreadsheet(); var json = JSON.parse(req.postData.contents); var courseSheet = sheet.getSheetByName(UPLOAD_SHEET); //Create new sheet if it does not already exists, append the header row if (courseSheet == null) { sheet.insertSheet(UPLOAD_SHEET); courseSheet = sheet.getSheetByName(UPLOAD_SHEET); courseSheet.appendRow(["UploadTime","UploadDeviceId","UploadedBy","Course","StartHole","Golfer","Score","Putts", "H1Par","H1Strokes","H1Putts","H1Penalty","H1Gir","H1FairwayHit","H1SandSave", "H2Par","H2Strokes","H2Putts","H2Penalty","H2Gir","H2FairwayHit","H2SandSave", "H3Par","H3Strokes","H3Putts","H3Penalty","H3Gir","H3FairwayHit","H3SandSave", "H4Par","H4Strokes","H4Putts","H4Penalty","H4Gir","H4FairwayHit","H4SandSave", "H5Par","H5Strokes","H5Putts","H5Penalty","H5Gir","H5FairwayHit","H5SandSave", "H6Par","H6Strokes","H6Putts","H6Penalty","H6Gir","H6FairwayHit","H6SandSave", "H7Par","H7Strokes","H7Putts","H7Penalty","H7Gir","H7FairwayHit","H7SandSave", "H8Par","H8Strokes","H8Putts","H8Penalty","H8Gir","H8FairwayHit","H8SandSave", "H9Par","H9Strokes","H9Putts","H9Penalty","H9Gir","H9FairwayHit","H9SandSave"]); } //Create a row per golfer for (var s = 0; s < json.segments.length; s++) { for (var g = 0; g < json.segments[s].golfers.length; g++) { var courseSheetRow = new Array(); courseSheetRow.push(new Date(json.uploadTime)); courseSheetRow.push(json.uploadDeviceId); courseSheetRow.push(json.uploadGolferName); courseSheetRow.push(json.course); courseSheetRow.push(json.segments[s].startHole); courseSheetRow.push(json.segments[s].golfers[g].name); courseSheetRow.push(json.segments[s].golfers[g].score); courseSheetRow.push(json.segments[s].golfers[g].putts); for (var h = 0; h < json.segments[s].golfers[g].holes.length; h++) { courseSheetRow.push(json.segments[s].golfers[g].holes[h].par); courseSheetRow.push(json.segments[s].golfers[g].holes[h].strokes); courseSheetRow.push(json.segments[s].golfers[g].holes[h].putts); courseSheetRow.push(json.segments[s].golfers[g].holes[h].penalty); courseSheetRow.push(json.segments[s].golfers[g].holes[h].greenInRegulation); courseSheetRow.push(json.segments[s].golfers[g].holes[h].fairwayHit); courseSheetRow.push(json.segments[s].golfers[g].holes[h].sandSave); } courseSheet.appendRow(courseSheetRow); } } //Send email if ?email=test@foo.com added to URL if (req.parameter.email != null) { try { emailHtmlScorecard(req, json); } catch(e) { // If error occurs, throw exception result = {"status": "FAILED", "message": exc}; } } } catch(exc){ // If error occurs, throw exception result = {"status": "FAILED", "message": exc}; } // Return result return ContentService .createTextOutput(JSON.stringify(result)) .setMimeType(ContentService.MimeType.JSON); }
//Send email of scorecardfunction emailHtmlScorecard(req, json) { try { var html; html = '<h2>' + json.course + '</h2>' html = html.concat('<p>' + Utilities.formatDate(new Date(json.uploadTime), "GMT", "MMMM dd, yyyy") + '</p>'); html = html.concat('<table style="border: 1px solid black;" cellspacing="0" cellpadding="12">'); html = html.concat('<tbody>'); var htmlHoleRow = '<tr style="background-color: #003300; color: white; border: 1px solid black;">'; htmlHoleRow = concatInnerTableCell(htmlHoleRow,'Hole', false); var htmlParRow = '<tr style="background-color: #215824; color: white; border: 1px solid black;">'; htmlParRow = concatInnerTableCell(htmlParRow,'Par', false); var golferScoreRow = new Array(4); var parTot = 0; var golferScoreTot = new Array(4); var golferScoreCtr = new Array(4); //Initialize golfer totals and html row for (var g = 0; g < json.segments[0].golfers.length; g++) { golferScoreRow[g] = '<tr style="border: 1px solid gray;">'; golferScoreRow[g] = concatInnerTableTotalCell(golferScoreRow[g], json.segments[0].golfers[g].name, g > 0); golferScoreTot[g] = 0; golferScoreCtr[g] = 0; } //iterate over segments, i.e. front and back for (var s = 0; s < json.segments.length; s++) { var parCtr = 0; //iterate over golfer for (var g = 0; g < json.segments[s].golfers.length; g++) { //iterate over hole for (var h = 0; h < json.segments[s].golfers[g].holes.length; h++) { //Emit par and hole row one time if (g == 0) { htmlHoleRow = concatInnerTableCell(htmlHoleRow, (json.segments[s].startHole + h), false); htmlParRow = concatInnerTableCell(htmlParRow, json.segments[s].golfers[g].holes[h].par, false); parCtr += json.segments[s].golfers[g].holes[h].par; } golferScoreRow[g] = concatInnerTableCell(golferScoreRow[g], json.segments[s].golfers[g].holes[h].strokes, g > 0); golferScoreCtr[g] += json.segments[s].golfers[g].holes[h].strokes; } //end hole iteration if (json.segments.length > 1) { golferScoreRow[g] = concatInnerTableTotalCell(golferScoreRow[g], golferScoreCtr[g], g > 0); } golferScoreTot[g]+= golferScoreCtr[g] golferScoreCtr[g] = 0; } // end golfer iteration if (json.segments.length > 1) { htmlHoleRow = concatInnerTableCell(htmlHoleRow, (s==0 ? 'OUT' : 'IN'), false); htmlParRow = concatInnerTableCell(htmlParRow, parCtr, false); } parTot+=parCtr; parCtr = 0; } //end segment iteration htmlHoleRow = htmlHoleRow.concat('<td>Total</td>'); htmlHoleRow = htmlHoleRow.concat('</tr>') htmlParRow = htmlParRow.concat('<td>' + parTot + '</td>'); htmlParRow = htmlParRow.concat('</tr>'); html = html.concat(htmlHoleRow); html = html.concat(htmlParRow) for (var g = 0; g < json.segments[0].golfers.length; g++) { golferScoreRow[g] = concatInnerTableTotalCell(golferScoreRow[g], golferScoreTot[g], g > 0); golferScoreRow[g] = golferScoreRow[g].concat('</tr>'); html = html.concat(golferScoreRow[g]); } html = html.concat('</tbody>'); html = html.concat('</table>'); html = html.concat(emailFooter()); GmailApp.sendEmail(req.parameter.email, 'Golf Scoresheet for ' + json.course, '', { htmlBody: html, name: 'EasyScore' }); } catch(e) { Logger.log('Error sending email: ' + e); throw 'Error sending email: ' + e; } }

function concatInnerTableCell(html, val, topBorder) { if (topBorder != null && topBorder) { return html.concat('<td nowrap style="border-right: 0.1px solid gray; border-top: 0.1px solid gray;">' + val + '</td>'); } else { return html.concat('<td nowrap style="border-right: 0.1px solid gray;">' + val + '</td>'); }}
function concatInnerTableTotalCell(html, val, topBorder) { if (topBorder != null && topBorder) { return html.concat('<td nowrap style="background-color: #f6fff5; border-right: 0.1px solid gray; border-top: 0.1px solid gray;"><strong>' + val + '</strong></td>'); } else { return html.concat('<td nowrap style="background-color: #f6fff5; border-right: 0.1px solid gray;"><strong>' + val + '</strong></td>'); }}
function emailFooter() { return '<p></p><em>Generated from <strong>EasyScore Interactive golf scorecard</strong></em><br/><a href="https://play.google.com/store/apps/details?id=io.ekuprel.easyscoregolf">Android download</a> | <a href="https://www.google.com/url?q=https%3A%2F%2Fapps.apple.com%2Fus%2Fapp%2Feasyscore-golf-scorecard%2Fid1457397263%3Fls%3D1&sa=D&sntz=1&usg=AFQjCNFscfiCQ2gac89RJVBGvHMKsIKTfg">IOS download</a></p>';}

Step 4: Deploy Script as Web app

Publish -> Deploy as Web app

Create new project version
Execute the app as: Your account
Who has access to the app: Anyone, even anonymous

When you publish you will copy the Current web app URL , and paste that into EasyScore Golf App with POST option

Step 5: Copy-Paste the web app URL of your Google sheet into EasyScore

You will use the URL from the Step 4 and paste into the EasyScore mobile app. It is a long URL so use copy-paste technique. It will be nearly impossible to key it in without making a mistake. Once you paste it in you can press the UPLOAD NOW button to test. Once it succeeds you sill see your current scoresheet in the Google Sheet. It creates a new tab named UPLOAD_FROM_APP

Step 6: Email scorecard after publish (optional)

If you want to also send the scorecard to an email address you can add the following URL parameter: ?email=youremail@foo.com to the URL in EasyScore. If you want to add multiple email addresses use a comma to separate e.g. ?email=abc@foobar.net,xyz@foobar.cc. This will trigger to upload script in Google Sheet to send an email with a nicely formatted scorecard (illustration below). The email will be sent from your Gmail address (e.g. {youremail}@gmail.com) associated with your Google account.

Creating your own custom endpoint

In the EasyScore app the golfer will need to navigate to the Upload section and paste in the URL of your REST endpoint. You can use your own URL parameters such as &league=123 if you wish to pass in custom data, not in the scorecard. You could also implement basic auth e.g. http://username:password@example.com .

Sample Payload

Data sent from EasyScore mobile app to your REST endpoint. Here is example of the payload that will be sent to your endpoint.

{ "uploadDeviceId": "90B0D556-2795-47A8-BD84-21D624A079E9", "version": 1, "uploadGolferName": "Eric", "uploadTime": 1587432482162, "course": "Medalist", "segments": [{ "type": "front", "startHole": 1, "golfers": [{ "name": "Eric", "score": 42, "putts": 19, "holes": [{ "hole": 1, "par": 4, "strokes": 7, "penalty": 1, "putts": 3, "sandSave": false, "greenInRegulation": false, "fairwayHit": false }, { "hole": 2, "par": 4, "strokes": 4, "penalty": 0, "putts": 2, "sandSave": false, "greenInRegulation": true, "fairwayHit": true }, { "hole": 3, "par": 4, "strokes": 5, "penalty": 0, "putts": 2, "sandSave": false, "greenInRegulation": false, "fairwayHit": true }, { "hole": 4, "par": 4, "strokes": 4, "penalty": 0, "putts": 2, "greenInRegulation": true, "fairwayHit": true }, { "hole": 5, "par": 3, "strokes": 3, "penalty": 0, "putts": 1, "sandSave": true, "greenInRegulation": false }, { "hole": 6, "par": 3, "strokes": 3, "penalty": 0, "putts": 2, "greenInRegulation": true }, { "hole": 7, "par": 4, "strokes": 5, "penalty": 0, "putts": 3, "greenInRegulation": false, "fairwayHit": true }, { "hole": 8, "par": 5, "strokes": 6, "penalty": 0, "putts": 2, "greenInRegulation": false, "fairwayHit": true }, { "hole": 9, "par": 5, "strokes": 5, "penalty": 0, "putts": 2, "greenInRegulation": true, "fairwayHit": true }] }, { "name": "G2", "score": 48, "holes": [{ "hole": 1, "par": 4, "strokes": 5 }, { "hole": 2, "par": 4, "strokes": 5 }, { "hole": 3, "par": 4, "strokes": 8 }, { "hole": 4, "par": 4, "strokes": 5 }, { "hole": 5, "par": 3, "strokes": 5 }, { "hole": 6, "par": 3, "strokes": 6 }, { "hole": 7, "par": 4, "strokes": 5 }, { "hole": 8, "par": 5, "strokes": 5 }, { "hole": 9, "par": 5, "strokes": 4 }] }] }]}

A few notes about the example payload:

version - version of the JSON emitted by EasyScore. Intially this will be 1.
segments - array size 2, representing front and back. "type":"front"|"back"
If a field is missing then it not being collected e.g. putts.
startHole valid values: 1, 10, 19
uploadTime - Milliseconds since Epoch i.e. 1970-01-01T00:00:00Z + millisecondsSinceEpoch ms in the given time zone (local or UTC)

visit https://currentmillis.com/

Expected Response

The app will expect a HTTP response code of 200, or 489. Anything else will be reported as an error in the application

Custom Validation

If you want to do custom validation of the incoming payload and you find a problem, then respond with the HTTP response code of 489. Also include the reason upload-validation failed with the following JSON response.

{ "message": "You already submitted your scores to the league network"}

In this case the message will show in the app to alert the user of the problem

Questions

If you have any question please click here

Page updated

Google Sites

Report abuse