I need your help to fix my Google Apps Script.
It is not working.
I have set up the trigger, but onFormSubmit(e) is not called.
If you see the error(s), please send me a message.
Thank you!
function myfunction() {
var form = [login to view URL]('PSSD / PSF survey');
// Add problems question with "Other" option
var problemsQuestion = [login to view URL]()
.setTitle('Problems')
.setChoiceValues(['Libido','Anesth', 'brain fog'])
.showOtherOption(true);
// Add gender question on a new page
var genderQuestion = [login to view URL]()
.setTitle('Gender')
.setGoToPage([login to view URL])
.addMultipleChoiceItem()
.setTitle('What is your gender?')
.setChoices([
[login to view URL]('Male'),
[login to view URL]('Female'),
[login to view URL]('Other')
])
.setRequired(true);
// Log the published URL of the form
[login to view URL]('Published URL: ' + [login to view URL]());
}
function onFormSubmit(e) {
var form = [login to view URL]();
var formResponse = [login to view URL];
var itemResponses = [login to view URL]();
for (var i = 0; i < [login to view URL]; i++) {
var itemResponse = itemResponses[i];
var question = [login to view URL]().getTitle();
var answer = [login to view URL]();
// Ask "why did you choose answer" for all questions except gender confirmation
if (question !== 'Are you sure that you are a <gender>?') {
var followupQuestion = [login to view URL]()
.setTitle('Follow-up question')
.setGoToPage([login to view URL])
.addParagraphTextItem()
.setTitle('Why did you choose ' + answer + '?');
}
// Add gender confirmation question on a new page
if (question === 'What is your gender?' && answer !== 'Other') {
var confirmationQuestion = [login to view URL]()
.setTitle('Gender confirmation')
.setGoToPage([login to view URL])
.addMultipleChoiceItem()
.setTitle('Are you sure that you are a ' + answer + '?')
.setChoices([
[login to view URL]('Yes'),
[login to view URL]('No')
])
.setRequired(true);
}
}
}
Hi there!,
Hope all good there.
I read your project details and I'm very interested to hear from you to discuss more asap.
I can generally complete the work within time.
You can see some of my past work in my portfolio here: https://www.freelancer.com/u/devikagupta/ and then you can contact me or accept my bid so that we can discuss more and start on your project asap.
I am waiting for your positive response to start on this project.
Thanks!
Devika :)
?Greetings!
I have read your description carefully and understand what you actually need.
I am an experienced developer and can handle this project easily and in perfect manner.
I am available now and can start right away, I will develop it in the least time.
I am an experienced and professional developer so everything will be well managed.
I assure you the work will be provided with quality.
Waiting for your response, feel free to get in touch.
Thanks!