updating existing data on google spreadsheet using a form?

forms google-apps-script google-sheets google-sheets-api
jupcan picture jupcan · Feb 14, 2014 · Viewed 24.2k times · Source

I want to build kind of an automatic system to update some race results for a championship. I have an automated spreadsheet were all the results are shown but it takes me a lot to update all of them so I was wondering if it would be possible to make a form in order to update them more easily.

In the form I will enter the driver name and the number o points he won on a race. The championship has 4 races each month so yea, my question is if you guys know a way to update an existing data (stored in a spreadsheet) using a form. Lets say that in the first race, the driver 'X' won 10 points. I will insert this data in a form and then call it from the spreadsheet to show it up, that's right. The problem comes when I want to update the second race results and so on. If the driver 'X' gets on the second race 12 points, is there a way to update the previous 10 points of that driver and put 22 points instead? Or can I add the second race result to the first one automatically? I mean, if I insert on the form the second race results can it look for the driver 'X' entry and add this points to the ones that it previously had. Dunno if it's possible or not.

Maybe I can do it in another way. Any help will be much appreciated! Thanks.

Answer

Harold picture Harold · Feb 14, 2014

I believe you can found everything you want here.
It's a form url, when you answer this form you'll have the url of the spreadsheet where the data are stored. One of the information stored is the url to modify your response, if you follow the link it will open the form again and update the spreadsheet in consequence. the code to do this trick is in the second sheet of the spreadsheet.
It's a google apps script code that need to be associated within the form and triggered with an onFormSubmit trigger.

Related questions

Retrieve the e-mail address of a Google Form respondent without asking for their e-mail address in the form

The scenario goes: Via email, a Google Form is sent to a respondent. Via this sent email, the respondent answers the form and sends their response. This form has no email address field. I need to retrieve the respondents e-mail …

Read More
Use a Google Forms to update existing Google Sheets

I'm trying to build a Google Forms that fills out certain cells of an existing Google Sheets with the responses from the Google Forms. I also need some of the answers on the Google Forms to come from the spreadsheet …

Read More
How to allow users to upload files with Google Form without login?

Where can I find code and instruction on how to allow users to upload files with Google Form without login? I searched all over here and couldn't find any information. https://developers.google.com/apps-script/reference Thanks in advance.

Read More