Is it possible to display popup on google form submit

Question

I want to know whether its possible to display a dialog box popup after submitting google forms. Just before the screen in which a confirmation screen is displayed that your request has been recorded.

I checked this post in which onOpen event of spreadsheets is used to display a popup. How do I open a web browser using google apps script?.

Can i do the same onFormSubmit event of spreadsheet. If it's possible than how to do this because I am new to google app script. My requirement is to use fileUpload with google forms. After user submits the forms a dialog should appear asking user if he/she wants to upload a file. Thanks.

Solution

Unfortunately you can't display a popup dialog box after submitting Google forms. To show a popup you must be with the spreadsheet opened.

If you want to customize the message to the user with a popup box you will have to built the form manually using HtmlService

Comments

[Nishant]

Thanks for reply.. So is there any other way of adding the file upload functionality to google forms..

[Rafael De Alemar Vidal]

You can't add file upload to google forms. Again, HtmlService is the way to go for this matter!

[Nishant]

Ok i created custom form with app script with the file upload. User accessing it can fill the form and upload the file as well. File will be stored to my drive. But now i can't find a solution for embedding that script in my application. I am using SAPUI5 as front end. Published url is like this. script.google.com/macros/s/......./exec. Is there any way to do this.

[Andrew Roberts]

One of the limitations of GAS apps (gadgets) is you can only embed them in a Google site, not your own webpage. code.google.com/p/google-apps-script-issues/issues/…

[Nishant]

Can you please explain me where you added that button/link and how to add it. Because i can't find it.

[Andrew Roberts]

Open your form in GDrive and you should see it in "edit view". At the bottom of the page is the text and options for the confirmation page: see this example image

[Nishant]

Your method is good and is almost similar what i want. But my link is a published GAS link. script.google.com/macros/s/...../exec But i want to write upload files which should be a clickable link.. So how can i hide a link behind some name.

[Andrew Roberts]

I don't think you can do that, but you could try experimenting with markdown or html tags. When I did it, the URL just automatically turned into a link. You could shorten it with something like bit.ly

[tehhowch]

This is not possible for Google Forms