Invalid email address stops data from saving to spreadsheet #345

Closed
opened 2025-10-14 16:53:06 -06:00 by navan · 0 comments
Owner

Originally created by @iteles on 6/13/2017

UPDATE: See comment below, it appears this is only an issue when the email address is invalid.


I have my form submitting and showing up in the Google sheet locally (no emails sent but that's another story).

However, when I move onto part 2 and:

  • Add in the AJAX script
  • Add in the thank you message div
  • Add in the invalid email div

See the diff here: https://github.com/iteles/w-day-website/pull/7/commits/11d32dfb71c9fc7e256b5478f60ce149222ea23c#diff-eacf331f0ffc35d4b482f1d15a887d3bR193

All of this throws no errors in the console. In fact, all appears well on the browser console but nothing shows up in the Google Sheet and the thank you message doesn't show up either.
screen shot 2017-06-13 at 21 03 43

If I comment out the script tag the form submits again (moving the user to the next page with the raw submissions as per the end of Part 1) and answers show up in the sheet again. 😬

*Originally created by @iteles on 6/13/2017* **UPDATE:** See [comment below](https://github.com/dwyl/html-form-send-email-via-google-script-without-server/issues/111#issuecomment-308234774), it appears this is only an issue when the email address is invalid. <hr/> I have my form submitting and showing up in the Google sheet locally (no emails sent but that's another story). However, when I move onto part 2 and: + Add in the AJAX script + Add in the thank you message div + Add in the invalid email div See the diff here: https://github.com/iteles/w-day-website/pull/7/commits/11d32dfb71c9fc7e256b5478f60ce149222ea23c#diff-eacf331f0ffc35d4b482f1d15a887d3bR193 All of this throws no errors in the console. In fact, all appears well on the browser console but nothing shows up in the Google Sheet and the thank you message doesn't show up either. <img width="394" alt="screen shot 2017-06-13 at 21 03 43" src="https://user-images.githubusercontent.com/4185328/27102088-e781cc06-507b-11e7-9356-5fbe1fb123ae.png"> If I _comment out the script tag_ the form submits again (moving the user to the next page with the raw submissions as per the end of Part 1) and answers show up in the sheet again. 😬
navan 2025-10-14 16:53:11 -06:00
Sign in to join this conversation.
No labels
Priority-1
Priority-1
Priority-1
Priority-1
Priority-1
Priority-1
Priority-1
Priority-1
awaiting-review
awaiting-review
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
chore
chore
discuss
discuss
discuss
duplicate
duplicate
duplicate
duplicate
duplicate
duplicate
duplicate
duplicate
duplicate
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
enhancement
epic
epic
external-dependency
external-dependency
external-dependency
hacktoberfest-accepted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
help wanted
in-progress
in-progress
in-progress
in-review
invalid
invalid
invalid
invalid
invalid
invalid
invalid
invalid
invalid
merge-conflicts
merge-conflicts
please-test
please-test
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
question
spam
spam
starter
starter
starter
starter
starter
starter
starter
starter
starter
technical
technical
technical
technical
technical
user-feedback
user-feedback
user-feedback
user-feedback
user-feedback
user-feedback
wontfix
wontfix
wontfix
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github/learn-to-send-email-via-google-script-html-no-server#345
No description provided.