How can I get the Google Spreadsheet to automatically order the incoming form responses alphabetically (2nd column)?
I know how to do this manually or by going in and editing a cell, but cannot get it to do this as an onevent for incoming response.
Google-sheets – Auto-sort column Google Spreadsheet on incoming Google Form response
google sheetsgoogle-forms
Related Solutions
Maybe this has changed in new Google Sheets because in the second and subsequent Forms it seems possible to select Responses, Choose response destination:
New sheet in an existing spreadsheet..., Choose:
find the Response Sheet for the first Form, Select and for this to work.
Yes, it's possible, but with slight different approach:
Submit one answer for each respondent in order to get one edit URL by each of them, then send the corresponding URL to each respondent.
Below is a code snippet that programmatically submits a response and log some response attributes including the edit response url by two methods, the first one has an issue, the second one is a workaround.
It will work as a stand alone or as a bounded script.
/*
This code shows how to get the edit response url of a
programmatically submitted response to a Google Form
*/
// Replace the form ID by your own form
var formID = '1234567890abcdefghijklmnopqrstuvwxyz';
function myFunction() {
var form = FormApp.openById(formID);
var response = form.createResponse();
var items = form.getItems();
var item = items[0];
if (item.getType() == 'TEXT') {
var textItem = item.asTextItem();
var itemResponse = textItem.createResponse('my text');
response.withItemResponse(itemResponse);
}
// Submit response
var submittedResponse = response.submit();
// Get submitted response attributes
var values = {
ID : submittedResponse.getId(),
TS : submittedResponse.getTimestamp(),
/*
Issue 4476: FormApp: getEditResponseUrl() produces invalid URL
https://code.google.com/p/google-apps-script-issues/issues/detail?id=4476
*/
ER1 : submittedResponse.getEditResponseUrl(),
/* Workaround from
https://code.google.com/p/google-apps-script-issues/issues/detail?id=4476#c2
*/
ER2 : submittedResponse.getEditResponseUrl().replace(
/\?edit2=.*/,"?edit2=" + submittedResponse.getId()
)
};
Logger.log(values);
}
References
Related Topic
- Google-drive – Edit multiple form responses inside a Google form
- Google Sheets – Automatically Wrap Text to New Responses from Form
- Google Forms – Can Response ID Be Accessed?
- Google-sheets – Importing data into Google Form response sheet with date, list, grid
- Google-sheets – On Google Forms, can someone edit their response but can’t add a new one
Best Answer
I have one suggestion: on the next empty column on your Form Response:
Where
rangeis the range of the responses andxis the column that you want to sort. Hide the columns where the answers are automatically inserted.