untold walrus
I put together this script to take data from a row in sheets and creates a URL link for a prepopulated google form. But the link it creates doesn't work. It will open the form but it doesn't prepopulate the fields. When I create a prepopulated link through the form, the link has different field ID's than the ones the script creates. What am I missing?
function prepopulateFormFromSheetRow() {
// Replace the form URL and sheet ID with your own values.
var formUrl = 'https://docs.google.com/forms/d/e/1JAE-VFugP4TzksLy7Q6QOxLKu1PZSFix-89nzRHsgtc/viewform';
var sheetId = '1itES_kdE_61kGG_JSayKhn_h-FdduaSG697a5qoNz34';
var sheet = SpreadsheetApp.getActiveSheet();
var row = sheet.getActiveRange().getRow();
var form = FormApp.openById('1JAE-VFugP4TzksLy7Q6QOxLKu1PZSFix-89nzRHsgtc');
var responseUrl = form.getPublishedUrl();
var items = form.getItems();
var parameters = '?usp=pp_url';
for (var i = 0; i < items.length; i++) {
var value = sheet.getRange(row, i + 2).getValue();
if (value != "") {
Logger.log(items[i].getTitle()+ items[i].getId() + value);
parameters += '&entry.' + items[i].getId() + '=' + encodeURIComponent(value);
}
}
var prepopulatedUrl = responseUrl + parameters;
SpreadsheetApp.getUi().alert(prepopulatedUrl);
}
brazen blade
