adding more fields to a form

Question

adding more fields to a form

HGBeary opened this issue 9 years ago · 16 comments

I would like some info to customize "html-form-send-email-via-google-script-without-server". I need to add additional text labels but it's, apparently, not as easy as it looks!

Answer 1 · 2015-12-01T07:25:29.000Z

Hi @HGBeary, thanks for contacting us!
Can you please clarify if you want new Labels or new Form Fields?
Labels describe the fields whereas fields allow you to enter/record more data.

Answer 2 · 2015-12-01T12:26:27.000Z

Thanks for the quick reply! I've prepared a form for volunteer tutors to
enter their monthly hours: text fields for tutor info, student info, hours,
miles, etc. Getting all of that data into the spreadsheet is my goal. Henry

Henry G. Beary
HGB Diversified Services LLC
"Small Business Consultants"
860 350-6123 (office)
203 994-4935 (cell)

On Tue, Dec 1, 2015 at 2:25 AM, Nelson notifications@github.com wrote:

Hi @HGBeary https://github.com/Hgbeary, thanks for contacting us!
Can you please clarify if you want new Labels or new Form Fields? Thanks!

—
Reply to this email directly or view it on GitHub
#9 (comment)
.

Answer 3 · 2015-12-01T13:35:21.000Z

Ok. Understood. I will need to slightly modify the form handler to achieve this.
When do you need it? (we have a deadline today, but we can take a look at it tomorrow, is that ok...?)

Answer 4 · 2015-12-01T14:15:38.000Z

Wow...thank you so much! Tomorrow would be perfect! Attached is a screen
shot of what my database-driven page will look like when I finally get
there; for now, the mail form will work. Thanks again, Henry

Henry G. Beary
HGB Diversified Services LLC
"Small Business Consultants"
860 350-6123 (office)
203 994-4935 (cell)

On Tue, Dec 1, 2015 at 8:35 AM, Nelson notifications@github.com wrote:

Ok. Understood. I will need to slightly modify the form handler to
achieve this.
When do you need it? (we have a deadline today, but we can take a look
at it tomorrow, is that ok...?)

—
Reply to this email directly or view it on GitHub
#9 (comment)
.

Answer 5 · 2015-12-03T07:37:49.000Z

@HGBeary i've updated the form handler to be generic so that you can add any fields to the form and collect any data in the Google Spreadsheet.
see: https://github.com/dwyl/html-form-send-email-via-google-script-without-server#add-your-own-fields
If you have any other questions let us know!
Thanks again for your feedback.

please ⭐ the repo to show others you found it useful...

Answer 6 · 2015-12-03T21:09:53.000Z

Thanks for the updates! I've got a minor (I hope) issue: if I use

I get the message page but the data does not get emailed
or put into the spreadsheet. If I don't use the id=gform I get a page of
data but I also get an email and the spreadsheet populates. What am I doing
wrong?? Here's my test page without the id="gform":

http://lvg-ct.org/Tutor-Form-monthly-report-Gmail.php Thanks again for
getting me this far! Cheers, Henry

Henry G. Beary
HGB Diversified Services LLC
"Small Business Consultants"
860 350-6123 (office)
203 994-4935 (cell)

On Thu, Dec 3, 2015 at 2:37 AM, Nelson notifications@github.com wrote:

@HGBeary https://github.com/HGBeary i've updated the form handler to be
generic so that you can add any fields to the form and collect any data in
the Google Spreadsheet.
see:
https://github.com/dwyl/html-form-send-email-via-google-script-without-server#add-your-own-fields
If you have any other questions let us know!
Thanks again for your feedback.

—
Reply to this email directly or view it on GitHub
#9 (comment)
.

Answer 7 · 2015-12-03T21:22:29.000Z

The gform id is required in the form because that's how the form handler "listens" for the submission event. Try ading the id to your form and then opening your developer console to check if there are errors. (there shouldn't be... but if there are keep the page live and we can help you debug them...)

also, consider the addressing any markup validation issues: https://validator.w3.org/nu/?doc=http%3A%2F%2Flvg-ct.org%2FTutor-Form-monthly-report-Gmail.php to prevent issues.

Answer 8 · 2015-12-04T00:13:53.000Z

Thanks for the reminder to clean up my html! The attached screen capture
shows the error from the console. Thanks again, Henry

Henry G. Beary
HGB Diversified Services LLC
"Small Business Consultants"
860 350-6123 (office)
203 994-4935 (cell)

On Thu, Dec 3, 2015 at 4:22 PM, Nelson notifications@github.com wrote:

The gform id is required in the form because that's how the form handler
"listens" for the submission event. Try ading the id to your form and
then opening your developer console to check if there are errors.

also, consider the addressing any markup validation issues:
https://validator.w3.org/nu/?doc=http%3A%2F%2Flvg-ct.org%2FTutor-Form-monthly-report-Gmail.php
to prevent issues.

—
Reply to this email directly or view it on GitHub
#9 (comment)
.

Answer 9 · 2015-12-04T07:02:36.000Z

It appears That Github does not allow images to be uploaded to issues as email attachments... Please manually upload it, or send us the link to the version of the page with the gform I'd. Thanks.

Answer 10 · 2015-12-04T12:53:25.000Z

When I run the page in the Chrome debugger I get the following error on
line 24 of form-submission-handler.js:

Uncaught TypeError: cannot read property “style” of null

Henry G. Beary
HGB Diversified Services LLC
"Small Business Consultants"
860 350-6123 (office)
203 994-4935 (cell)

On Fri, Dec 4, 2015 at 2:02 AM, Nelson notifications@github.com wrote:

It appears That Github does not allow images to be uploaded to issues as
email attachments... Please manually upload it, or send us the link to the
version of the page with the gform I'd. Thanks.

—
Reply to this email directly or view it on GitHub
#9 (comment)
.

Answer 11 · 2015-12-04T15:35:32.000Z

Ah... that's because you have changed the DOM significantly.
the line attempting to apply the style is to hide the form once its been successfully submitted.

You are serving the page using a PHP-enabled server, this script was meant to be for static pages where no sever interaction was permitted...

You can still take advantage of the script while serving the page from PHP, but you have much more power than our original constraint dictated.

If you are going to serve the page from your Dreamhost server, and alter the page's DOM, it might be worth customising the form-submission-handler.js and loading that from your static folder too.

Answer 12 · 2016-02-01T19:48:54.000Z

How can you add a new field that has drop down options or allows users to select more than one option

Answer 13 · 2016-05-09T02:36:53.000Z

@nelsonic I've added a checkbox input to my form and the corresponding column to the spreadsheet - everything else is working fine, but no matter if I check the checkbox or not, I'm getting the same value reported to the spreadsheet. Do you know how to accomplish this for a simple True/False value?

Answer 14 · 2016-05-29T19:08:35.000Z

Does our OP have any more concerns on this issue? If not, please close! Hopefully you were able to get something working, but static pages are best.

For other posts, please see #31 on the checkbox input (new features/bugs should be separate issues), and same for a drop-down multi-select. I can take a look at these when I have more time.

Answer 15 · 2016-07-19T04:07:10.000Z

The original issue has been resolved with the support for more form fields. Again, please post in other issues if particular fields are not working for you!

Answer 16 · 2019-08-06T06:11:08.000Z

@divyats6550

This issue is >3 yrs old and I do not believe has anything to do with captcha. We have had issues around captcha if you search closed GitHub issues. We implemented a Honeypot technique and recently made it the default experience for all forms as well (that utilize the JS that is).