Apps Script: Contact Form Example

[@mahmoudalhyari2684]

you probably know this by now however, Alt+A and Tab will indent every thing automatically

[@bhadreshgvyas]

very good explanation. thanks for video

[@mscoca]

It is possible to create a Google sheets scrip to perform a POST request to a given API as new row is added?

[@clashingtv2527]

Sir can you explain me how to return redirect a new url after doPost (post request)

[@noureddinekhelifa4080]

thank you for this video! we are a group of a student , and we want to gether data (final projects) from other students by a form, which will work like this ( form with map to get latlong inside the form address, title...etc. and a file upload button for pdf/word and cover image)and send all this to google drive with results inside google sheet please help us, thank you

[@JordanRhea]

Thanks for the comment! I would love to help out more with your project. I did make a video using the mapping service in apps script. Does that help point you in the correct direction? kzbin.info/aero/PLb7kfLzbzocPoLjDYWFCoijWfI4K4MXVI

[@josuelinares9024]

good afternoon Mr. Jordan Rhea greets him and writes josue chiara from PERU. a query could also be made this same criterion in creating a form in html to connect with fusion tables or your api best regards will be waiting for your answer

[@JordanRhea]

+josue linares greetings to you also! I am not familiar with fusion tables but basically anything is possible with the query parameters. I need more specific info to better help you

[@nmastroianni]

Jordan, Love your content. I was really hopeful to make this "trick" work too. However, I must agree with a few of your viewers that the doPost(e) is "borked" (I love that word... reminds me of the Swedish Chef). You mentioned the CORS policy in your video, despite my best efforts, I can't do anything with the post request except return the contentservice response without triggering the CORS error. Are you still making use of this method? I copied your pen and your .GS code, no dice. ☹

[@arindamoitra58]

I followed the same steps. Forked the code from your Pen at CodePen but it is not working. Throwing the error code that I added in the catch block. How can I debug the code to understand the problem?

[@chenchen1872]

What a nice and clear explanation! Thanks a lot!

[@anandjha9033]

hey u said u would post the codepen link

[@robrita]

I didn't know this is possible.. thanks man.. really!

[@JordanRhea]

+Carlo Reyes Thanks, I really appreciate the compliment. My exact goal is to demonstrate what is possible!

[@elabinnovations]

Please add image upload in this project with base64 method

[@devmrin]

Thanks man! This helped a ton!

[@JordanRhea]

Glad to hear you enjoyed it!

[@adampoznanksi6421]

I am having some trouble getting the form to submit. I tried both on codePen and by creating a new html form. On code pen the status bar runs for a while. on mt html form nothing happens when after clicking the submit button

[@adampoznanksi6421]

this is the error i am getting when I submit Failed to load script.google.com/macros/s/....................exec: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'localhost' is therefore not allowed access.

[@pipo_lucido]

​@@adampoznanksi6421 same issue here

[@xiijaanzu3439]

doPost is borked :(

[@tinkershukla1725]

can you explain the jquery code

[@unstable0520]

Thank you very very very muxh$!!!!

[@Bruhfinally]

Couldn't someone with your web app URL abuse it?

[@JordanRhea]

Depends on the function you write. What kind of security do you envision needing?

[@ALWALEEDALWABEL]

did not work with me :((.

[@WasanKhunnadiloksawet]

Maybe only you can understand your clip.

[@elabinnovations]

Please give code

[@iben1195]

e.postData.contents reveals the data sent, however this particular line of code doesn't execute in mine. If i comment this line out, the script works as expected. But again, without that line, i can't retrieve the data sent. I've never been this baffled in my life. I came here cuz i have no clue what's going on

[@genovo]

here is the codepen: codepen.io/rheajt/pen/prGjdV