I want to submit a form from my web site over to a Gscript file on my Google Drive and have it take the form values, and generate a PDF file and email it. I have this working already using Google Forms, a Google Sheet, but the goal here is to have the data itself stored in a MySQL relational database where data is not duplicated, and as we fill in our form data will auto-populate if it already exists, or we can choose it from a list on the left to fill in pertinent informaton. This is for a donation receipt system for a nonprofit organization.
The key for us is to separate donor information from donations. We want to be able to store our donor info, with things like birthdays, anniversaries, and other miscellaneous information so we can send out birthday cards, etc but not store that data over and over again because they made several donations.
Is there any way I can move the form itself over to a secured portion of my own server, and submit the data over to my .gs file that already parses the data and puts it into the PDF document, Mailchimp, and backwards into my MySQL database, and sends the appropriate emails. I could cut out so much of that extra work on the Google side, and do all of it except for the PDF and email from my own server, and handle the rest from Google if I can just submit the data as a POST or GET request or to JSON to the .GS script.
I cannot find anything about it anywhere.
