Skip to main content

Posts

Showing posts from April, 2015

Getting the Edit Link From A Google Form Response

This code snippet may be of use to someone. I couldn't find an easier way of doing this. You need to familiar with Apps Script and Forms to get this, sorry. When you have a Google Form saving responses into a Google Spreadsheet, at times it would be nice to be able to give people the link to edit their form ( later ). So.. in your onFormSubmit(e) function you need... var timestamp = e.range.getValues()[0][0] var row_num = e.range.getRow() If you get the value from e.values or e.namedValues it doesn't work. No idea why... it may be something to do with millisecond precision or the space/time continuum... dunno. Then you need a function like this... /** * Gets edit link for a response's timestamp * * @method render_text * @param {string} Form ID" * @param {timestamp} A date * @return {string} A URL. */ function get_edit_link_for(form_id, timestamp){      var form = FormApp.openById(form_id)   var formResponses = form.getResponses();      // Le