problem after submit

[carloslencargorges]

when I press submit I see this message:
{"result":"error","error":{}}

[levinunnink]

Hmm. Can you post example of the HTML code that you're using to submit?

[abdohwebdev]

same here

this is the html

<form 
  method="POST" 
  action="https://script.google.com/macros/s/AKfycbw8QzcqXLrg2CjRclFm3s5WVRG7a2uYshRCjyc1JivqWW0mrhM-I8n3mX118yj85fw/exec"
>
  <input name="email" type="email" placeholder="Email" required>
  <button type="submit">Send</button>
</form>

[Christopher-Force]

FIXED
The headers for the spreadsheet are case-sensitive with the form name attribute. The headers do not need to be in order, but the name attribute must EXACTLY match with the header.

<input name="email" type="email" placeholder="Email" required> <input name="name" type="text" placeholder="Name" required>

PREVIOUSLY

"Unfortunately, I have this problem as well."

Failed to load resource: the server responded with a status of 404 ()

[levinunnink]

Thanks for the update, Christopher. I'll update the documentation to reflect this finding.

[dih-vicenza]

when I press submit I see this message: {"result":"error","error":{}}

same error here. Someone help me please :(

[Christopher-Force]

when I press submit I see this message: {"result":"error","error":{}}

same error here. Someone help me please :(

Please share your form code and your spreadsheet headers and I'll take a look

[Christopher-Force]

Hi I had a problem here, I have followed all the tutorial and according to me it should work perfectly but when I click the submit button nothing happens, not even the Google screen comes, just the page is to be seen where i filled up the form and nothing is reflecting in the form.

I have copied the same code which is written here

`<form

  method : "POST"

  action : "https://script.google.com/macros/s/AKfycbwBX_cJC5avaNsdHv-pWAIt0EEHqtAC6XZBxEQWa6OjGutT78umU-NBsZZoMOkHkKYF/exec">

`

If you're still having issues, please send your entire form element with the input elements along with your spreadsheet headers and I'll take a look

[dih-vicenza]

when I press submit I see this message: {"result":"error","error":{}}

same error here. Someone help me please :(

Please share your form code and your spreadsheet headers and I'll take a look

Ok @Christopher-Force !

The headers are: https://docs.google.com/spreadsheets/d/1NNn8Lxp0nBO7ngCwCJXkGKPT29k1pL2vQ3WK_O4_p5I/edit?usp=sharing

while the form code is:

Send

Thank you!

[Christopher-Force]

when I press submit I see this message: {"result":"error","error":{}}

same error here. Someone help me please :(

Please share your form code and your spreadsheet headers and I'll take a look

Ok @Christopher-Force !

The headers are: https://docs.google.com/spreadsheets/d/1NNn8Lxp0nBO7ngCwCJXkGKPT29k1pL2vQ3WK_O4_p5I/edit?usp=sharing

while the form code is:

method="POST"

action="https://script.google.com/macros/s/AKfycbys401RD2C4sYkd4U6PYvsmeIqpJko6yNC3luI1F_9eohg5_ROVUTt_sEKHUy2eZ3sXOA/exec"

Send

Thank you!

If you don't use this, your code will disappear 🙂

[dih-vicenza]

sorry @Christopher-Force, I'm a newbie :)

`<form
method="POST"
action="https://script.google.com/macros/s/AKfycbys401RD2C4sYkd4U6PYvsmeIqpJko6yNC3luI1F_9eohg5_ROVUTt_sEKHUy2eZ3sXOA/exec"

Send `

[Christopher-Force]

sorry @Christopher-Force, I'm a newbie :)

`<form

method="POST"

action="https://script.google.com/macros/s/AKfycbys401RD2C4sYkd4U6PYvsmeIqpJko6yNC3luI1F_9eohg5_ROVUTt_sEKHUy2eZ3sXOA/exec"

Send

`

This is an old example of regular html implementation (Not a framework like React)

Each of your name attributes for your <input> elements must match case-sensitive to your headers, disregarding date.

The id attribute on <form> is only if you wish to stop the page from redirecting to a success screen, similar to what you saw for the error. This is explained in the readme as well and requires a script that the creator has kindly written for us.

Let me know if this helps and if you have other questions!

-Chris

[shafeequekp]

ajax code for not to redirect to another page. means saving from same page not to go next page

[standa006]

hi a got a same issue
{"result":"error","error":{}}
My form is

<form method="POST" action="https://script.google.com/macros/s/AKfycbw4Odn2kvRBVB_-xrx23l7SjpUrfhhsWgMGZJONjPCEj_fQshsadEKtieUA7sd6FIyc9w/exec">
  <input name="email" type="email" placeholder="email" required>
  <input name="name" type="text" placeholder="name" required>
  <button type="submit">Send</button>
</form>

and header in excel like

Could you help me?

[luk1790]

@standa006 Check on code from step2 :
const sheetName = 'Sheet1' this name is the same like on your sheet

[ExhausteDD]

@standa006 Check on code from step2 : const sheetName = 'Sheet1' this name is the same like on your sheet

I have same problem
Checked name of sheet, even naming sheet like in this example - still have {"result":"error","error":{}}

[ExhausteDD]

hi a got a same issue {"result":"error","error":{}} My form is

<form method="POST" action="https://script.google.com/macros/s/AKfycbw4Odn2kvRBVB_-xrx23l7SjpUrfhhsWgMGZJONjPCEj_fQshsadEKtieUA7sd6FIyc9w/exec">
  <input name="email" type="email" placeholder="email" required>
  <input name="name" type="text" placeholder="name" required>
  <button type="submit">Send</button>
</form>

and header in excel like

Could you help me?

Finaly i found what is the problem.
Here -> https://github.com/levinunnink/html-form-to-google-sheet#3-run-the-initialsetup-function you must set "doPost" instead of "InitialSetup" and it will work

[Keshy12]

If it's still not working for somebody:
Keep in mind that google uses your native language by default. Before doing the first intialSetup change the sheetName accordingly.

Mine was "Arkusz1", I had to redo all of the steps with this change but after this it worked like a charm.

[rcuesta00]

Another mistake that maybe some people could be doing has to do with the Deployments.

Try to test first your deployment: Deploy > Test Deployment

Copy the URL to your HTML code (<form method="POST" action="URL_Test").

After testing, now you can do the Deploy as in the documentation. Otherwise, every time you change something in your script you has to do another deployment.

[ashloren]

How can I redirect those who submit the form to a URL on my site?

[Keshy12]

How can I redirect those who submit the form to a URL on my site?

I'd try using AJAX to send POST request, and then redirect on success with jquery.

[erikantony]

It works great. How can I set that after form confirmation and sending will be reloaded new blank form? Thank you

[ff1st]

Mine worked perfectly well with the doPost. How do I redirect the form to another .html page, please, @Christopher-Force?

[ff1st]

How do you do that?

[Christopher-Force]

Mine worked perfectly well with the doPost. How do I redirect the form to another .html page, please, @Christopher-Force?

Sorry if my answer seems incomplete, in a rush and wanted to see if I could throw out some quick help.

This is a quick piece from an old project.
Written in ReactJS. Maybe use this to give a little guidance.

I imported useNavigate so that I'm able to change which page is routed. Highly recommend asking your questions to ChatGPT as they've already helped me code programs by myself that make my work life easier.
Prevent default stops the redirect, that's regular JS. After sending the data, I use the .then to insert my navigation function. You will have to use a different function if not using react.

import { useNavigate } from "react-router-dom";

const subscribeToNewsLetter = (e) => {
e.preventDefault();
quoteButton.click();

jsonp(`https://outlook.us5.list-manage.com/subscribe/post-json?xxxxx&${queryString.stringify(formValue)}`, { param: 'c' }, (err, data) => {
  console.log('err:', err);
  console.log('data:', data);
}).then(navigate('/thankyou'));

}

[wkpires]

Hey guys, I'm trying to do the same test (with external html), but restricting access to the domain and it's not working. With an html inside the google script it works.

[ff1st]

Hi, I'm sorry for late response. I'd like to know if you have found a way around it yet to know if I am to send you the complete steps I took

…

On Tuesday, 7 March 2023, Wagner Pires ***@***.***> wrote: Hey guys, I'm trying to do the same test (with external html), but restricting access to the domain and it's not working. With an html inside the google script it works. [image: image] <https://user-images.githubusercontent.com/11415665/223450099-5837eb3c-122a-4c8c-a8ee-b39ea60e8224.png> — Reply to this email directly, view it on GitHub <#3 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AUZ6ACKOHEZ5ZI4XLLPKNFLW25AH3ANCNFSM5MY37OPQ> . You are receiving this because you commented.Message ID: ***@***.***>

[tthompson0712]

Thanks for sharing. I got everything working but I don't like the return page for success. I then have to click the back button to go back to my website and the form is not reset. Is there a way to automatically go back to the webpage after submit and auto reset form?

[Keshy12]

Thanks for sharing. I got everything working but I don't like the return page for success. I then have to click the back button to go back to my website and the form is not reset. Is there a way to automatically go back to the webpage after submit and auto reset form?

Do it via AJAX, then you won't even need to redirect anywhere at all :)

[ff1st]

That is the only con I see about it, but I have stopped using the Google sheet method, but instead, I use Php and Ajax

…

On Sat, 20 Apr 2024 at 14:52, Keshy12 ***@***.***> wrote: Thanks for sharing. I got everything working but I don't like the return page for success. I then have to click the back button to go back to my website and the form is not reset. Is there a way to automatically go back to the webpage after submit and auto reset form? [image: image] <https://private-user-images.githubusercontent.com/143217767/323696971-ab19033a-7cd2-4c79-803c-f43a2eddd8d0.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTM2MjEzOTksIm5iZiI6MTcxMzYyMTA5OSwicGF0aCI6Ii8xNDMyMTc3NjcvMzIzNjk2OTcxLWFiMTkwMzNhLTdjZDItNGM3OS04MDNjLWY0M2EyZWRkZDhkMC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNDIwJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDQyMFQxMzUxMzlaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT00Zjc5NjgyMTYzYzNhNjI5MWU2MDM4ZmJjZTI4MThiMGI5OWE0MjQzYTM3ZmY3NmQzZDFlZTI5YTdjZWEzYjliJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.lIfaAFGOJWFOfXMCiMqS3QXlgMu5xC3qnXLCG466hnI> [image: image] <https://private-user-images.githubusercontent.com/143217767/323697075-b7431272-f88e-4905-a201-08f8021854d7.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTM2MjEzOTksIm5iZiI6MTcxMzYyMTA5OSwicGF0aCI6Ii8xNDMyMTc3NjcvMzIzNjk3MDc1LWI3NDMxMjcyLWY4OGUtNDkwNS1hMjAxLTA4ZjgwMjE4NTRkNy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNDIwJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDQyMFQxMzUxMzlaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1iNjJmZTMzYjVhZTA1ZDc3ZDEzOGU0ZTU0NTg1NDdkNGNmMzVhOWVkOGNkNzdjNWNlNzE0MmMwZTFhYTYyYTg4JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.0eBDlmFqD_IBryrjmklwUkxFeczgYxRPuR6vdru8izM> Do it via AJAX, then you won't even need to redirect anywhere at all :) — Reply to this email directly, view it on GitHub <#3 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AUZ6ACINI5FNXKWVKHR6JHLY6JXLRAVCNFSM5MY37OP2U5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TEMBWG43DQMJSGM4Q> . You are receiving this because you commented.Message ID: ***@***.***>