ii. Connect a Google Form to Awesome Table

*** This page is deprecated. Delight click here for the new version ***

Permit users update your data / add the ability to read & write data

You can hands use Awesome Tabular array with a Google Form. Create your form , mail service some responses, then add a new row in the spreadsheet betwixt the headers and the first response (to indicate which filters you desire to use). Example

And you tin can even use Crawly Table to create an Avant-garde Summary for your form. Case

Google Forms are very useful to let people submit new data in a spreadsheet but y'all can also employ a grade to let people update previous entries, clicking on the "Edit entry" button:

All you need for that is to shop the unique URL letting y'all edit each form'due south response. And you lot can grab all those unique URLs with a little apps script.

Get-go you lot need to open up the spreadsheet and create a form, or, if you employ the template sample Awesome Tabular array Google Form , the form is already linked in the spreadsheet but equally the responses in the database of the form are empty you need to re-populate with your own responses.

Beginning instance make your own Google Form :

Second case Edit the existing Google Form if you lot utilize the example :

Note: Beware, if you use the spreadsheet of the example we recommend you to not modify the construction of the linked form.

Then add together a column containing the edit links what will exist generated with the script.

In the spreadsheet click on the menu: Tools -> Script Editor

A new tab opens. Yous tin can meet a first role which was written into the file, delete it and copy/paste the post-obit script:

var formURL = 'https://docs.google.com/forms/d/18AuVZ2WTdox-x53DVM31mBzNL6QQ6SpO5JGJO0Et1cg/viewform';

var sheetName = 'Form Responses';

var columnIndex = 8;

role getEditResponseUrls() {

var canvas = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);

var data = sheet.getDataRange().getValues();

var form = FormApp.openByUrl(formURL);

for (var i = ii; i < information.length; i++) {

if (data[i][0] != '' && data[i][columnIndex - 1] == '') {

var timestamp = data[i][0];

var formSubmitted = form.getResponses(timestamp);

if (formSubmitted.length < 1) go along;

var editResponseUrl = formSubmitted[0].getEditResponseUrl();

sheet.getRange(i + 1, columnIndex).setValue(editResponseUrl);

}

}

}

Replace the showtime 3 rows of the script with your own parameters (the yellowish parts) :

    • FormURL : copy/past the URL of your Grade

    • sheetName : the name of the sheet which contains the grade responses

    • columnIndex : the index of the column where you desire to put the links to edit the form responses (e.1000.: column H >> columnIndex = eight). It will non work if the column doesn't have a header ("Update" in our example).

Trigger the script through the menu "Run". A dialog will enquire you permission to run the script. After that you should see the link to edit each grade response un your spreadsheet.

But y'all certainly don't desire to manually trigger the script every fourth dimension y'all add together a new entry. In the script editor, click on the menu Resource -> Electric current project's triggers and set up an automated trigger similar that :

Save and... Done ! Now users will be able to edit each entry in your spreadsheet