{"id":4022,"date":"2018-11-28T15:07:23","date_gmt":"2018-11-28T15:07:23","guid":{"rendered":"http:\/\/wiki.davelevy.info\/?p=4022"},"modified":"2023-11-04T13:35:49","modified_gmt":"2023-11-04T13:35:49","slug":"forms-with-google","status":"publish","type":"post","link":"https:\/\/davelevy.info\/wiki\/forms-with-google\/","title":{"rendered":"Forms with Google"},"content":{"rendered":"<p>The time has come! I found <span style=\"text-decoration: underline;\"><a href=\"https:\/\/zapier.com\/learn\/google-sheets\/how-to-use-google-forms\/\">this<\/a><\/span>, and am working through it as an example. Here are my notes.<!--more--><\/p>\n<p><span style=\"font-size: 1.7rem;\">Here&#8217;s my first form\u00a0<\/span><a style=\"font-size: 1.7rem;\" href=\"https:\/\/goo.gl\/forms\/Fqydq6nwtV4lHtDE2\">https:\/\/goo.gl\/forms\/Fqydq6nwtV4lHtDE2<\/a><span style=\"font-size: 1.7rem;\">. I have used a standard template. The response tab has an on\/off switch it would be nice to have a gone away postion. i.e. this form is no longer accepting responses, I suppose responses = off has this position.\u00a0<\/span><\/p>\n<p>I needed to make a form to integrate with <span style=\"text-decoration: underline;\"><a href=\"https:\/\/web.archive.org\/web\/20211130194710\/https:\/\/davelevy.carrd.co\/\">my carrd site<\/a><\/span>; and I looked at these links &#8230;<\/p>\n<ol>\n<li><a href=\"https:\/\/www.makeuseof.com\/tag\/website-contact-form-google-forms\/\">https:\/\/www.makeuseof.com\/tag\/website-contact-form-google-forms\/<\/a><\/li>\n<li><a href=\"https:\/\/zapier.com\/learn\/google-sheets\/how-to-use-google-forms\/\">https:\/\/zapier.com\/learn\/google-sheets\/how-to-use-google-forms\/<\/a><\/li>\n<li><a href=\"https:\/\/www.labnol.org\/internet\/google-docs-email-form\/20884\/\">https:\/\/www.labnol.org\/internet\/google-docs-email-form\/20884\/<\/a>, this was to get the contact requests forwarded to my mailbox<\/li>\n<\/ol>\n<p>The contact form is<span style=\"text-decoration: underline;\"><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLScGfUwzq8WxOefS19lGYf9K6i5XfiOgM7VFZ59cyT3CsKi1nA\/viewform\"> here &#8230;<\/a><\/span>\u00a0 or at\u00a0http:\/\/bit.ly\/2VQmWTO.\u00a0I don&#8217;t think the mail notification is working yet.<\/p>\n<p>I want to have another go at collecting into a sheet<\/p>\n<ol>\n<li><a href=\"https:\/\/blog.sheetgo.com\/google-sheets-features\/how-to-connect-google-forms-to-google-sheets\/\">https:\/\/blog.sheetgo.com\/google-sheets-features\/how-to-connect-google-forms-to-google-sheets\/<\/a><\/li>\n<\/ol>\n<p>Also<\/p>\n<p><iframe loading=\"lazy\" title=\"How to Link Google Form to Google Sheets | Create Data Entry Form for Google Sheets\" width=\"1099\" height=\"618\" src=\"https:\/\/www.youtube.com\/embed\/y-fGjt23en0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The time has come! I found this, and am working through it as an example. Here are my notes.<\/p>\n","protected":false},"author":1,"featured_media":4023,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_share_on_mastodon":"0"},"categories":[111,27,3],"tags":[1236,1235],"class_list":["post-4022","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","category-software","category-technology","tag-forms","tag-google-forms"],"share_on_mastodon":{"url":"","error":""},"jetpack_featured_media_url":"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2018\/11\/walrus.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/4022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/comments?post=4022"}],"version-history":[{"count":2,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/4022\/revisions"}],"predecessor-version":[{"id":9410,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/4022\/revisions\/9410"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media\/4023"}],"wp:attachment":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media?parent=4022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/categories?post=4022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/tags?post=4022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}