heaversm / google-custom-form

Submit to a google spreadsheet using a form of your own design
194 stars 50 forks source link

Posting to 2 places #19

Open paynestaker opened 7 years ago

paynestaker commented 7 years ago

I am trying to use this code to both save data in a google spreadsheet (which it does flawlessly) and push the same data into an a form via a POST. Is this possible? I have searched around, but have not been able to figure this out.

rafawashere commented 7 years ago

You can push information on to a Google Form using the GET method. All you need to do is list the name of the entry and assign the value to the input name (as seen below)

<inputname="entry.1269686327"value="New Chair" class="ss-q-short valid" id="entry_1269686327" dir="auto" aria-label="Item Name " title="" type="text">

/viewform?entry.1269686327=New%20Chair

-Hope this helps

Copy and Paste this URL to see working example (from Awesome Tables) https://docs.google.com/forms/d/e/1FAIpQLScsF4lkfKVsJxHpsaKQ19_7S9o3jCO_PhfMWPgqV1Kmm864SA/viewform?entry.1269686327=New%20Chair&entry.1674711477=My%20First%20Name&entry.1474716092=My%20Surname&entry.1170165588=1234%20Street&entry.1038664795=123456&entry.1389840431=This%20City&entry.1558379578=This%20Country