Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function objectifyForm() {
- //Makes the form info into an object
- var myform = FormApp.getActiveForm();
- var formResponses = myform.getResponses()
- var currentResponse = formResponses[formResponses.length-1];
- var responseArray = currentResponse.getItemResponses()
- var form = {};
- form.user = currentResponse.getRespondentEmail(); //requires collect email addresses to be turned on or is undefined.
- form.timestamp = currentResponse.getTimestamp();
- form.formName = myform.getTitle();
- for (var i = 0; i < responseArray.length; i++){
- var response = responseArray[i].getResponse();
- var item = responseArray[i].getItem().getTitle();
- var item = camelize(item);
- form[item] = response;
- }
- return form;
- }
- function camelize(str) {
- str = str.replace(/[.,-/#!$%^&*;:{}=-_`~()@+?><[]+]/g, '')
- return str.replace(/(?:^w|[A-Z]|bw|s+)/g, function(match, index) {
- if (+match === 0) return ""; // or if (/s+/.test(match)) for white spaces
- return index == 0 ? match.toLowerCase() : match.toUpperCase();
- });
- }
- //Use with installable trigger
- function onSubmittedForm() {
- var form = objectifyForm();
- Logger.log(form);
- //Put Code here
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement