{"id":468,"date":"2011-06-05T23:21:28","date_gmt":"2011-06-06T06:21:28","guid":{"rendered":"http:\/\/eloine.com\/blog\/?p=468"},"modified":"2011-07-18T19:31:37","modified_gmt":"2011-07-19T02:31:37","slug":"google-docs-form-for-garden-data-collection-way-too-simple","status":"publish","type":"post","link":"https:\/\/eloine.com\/blog\/archives\/468","title":{"rendered":"Google docs form for garden data collection &#8211; way too simple!"},"content":{"rendered":"<p>This is for everyone who has had to create forms on a website to collect information. Unless there is some sort of automatic widget built in to your content management system this can be a complicated or time-consuming task. Google has made this ridiculously simple though so in case you aren\u2019t aware I thought I would share with you how easy it is to make a slick little data collection form in just a few steps.<\/p>\n<ol>\n<ol>\n<li>Create a Google account (<a href=\"https:\/\/www.google.com\/accounts\/NewAccount\">https:\/\/www.google.com\/accounts\/NewAccount<\/a>) or if you already have a Gmail account just login and click the \u201cdocuments\u201d link at the very top to login into your Google docs account.<\/li>\n<\/ol>\n<\/ol>\n<p><a href=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image001.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-472\" title=\"image001\" src=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image001-300x72.png\" alt=\"\" width=\"300\" height=\"72\" srcset=\"https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image001-300x72.png 300w, https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image001.png 434w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<ol>\n<ol>\n<li>Once there Click the \u201ccreate new\u201d drop-down button in the upper left and select \u201cform\u201d<\/li>\n<\/ol>\n<\/ol>\n<p><a href=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image002.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-473\" title=\"image002\" src=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image002.png\" alt=\"\" width=\"141\" height=\"194\" \/><\/a><\/p>\n<ol>\n<ol>\n<li>From here give the form a name and then you can just start filling in what you want the questions to be. Just keep adding until you are done. You can create simple text fields or get fancier and create multiple-choice buttons and drop down selections.In this example I thought I would make a quick and easy way for me to record what I have planted in my garden. I tend to forget and wonder what that plant is. I always think I will remember what it is and where I got it but never do! <a href=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image003.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-474\" style=\"margin: 10px;\" title=\"image003\" src=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image003-300x231.png\" alt=\"\" width=\"300\" height=\"231\" srcset=\"https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image003-300x231.png 300w, https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image003.png 434w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ol>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>All the information above is collected into an online spreadsheet that you download and open in excel or just store and access on Google docs. You can even share with your friends and co-workers the information. Depending on the information inputted Google will also create a summary of the information with charts where appropriate.<\/li>\n<li>Google also has a number of themes you can choose from. In this page the garden theme works perfectly.<a href=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image004.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-475\" title=\"image004\" src=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image004-250x300.png\" alt=\"\" width=\"250\" height=\"300\" srcset=\"https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image004-250x300.png 250w, https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image004.png 434w\" sizes=\"auto, (max-width: 250px) 100vw, 250px\" \/><\/a><\/li>\n<li>The next step is to embed this form on your website which Google does through the use of an iframe. You can select \u201cembed this form\u201d under the \u201cMore actions\u201d button. Copy the little bit of code and paste the HTML into the HTML of your website and you are done.<br \/>\n<a href=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image005.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-476\" title=\"image005\" src=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image005-300x230.png\" alt=\"\" width=\"300\" height=\"230\" srcset=\"https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image005-300x230.png 300w, https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/image005.png 434w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li>Unfortunately there aren\u2019t too many themes to choose from and Google doesn\u2019t yet allow you to create your own and you can\u2019t modify the colors, fonts or images by the steps mentioned above.<\/li>\n<li>If you want most of the functionality of the form but want to edit the appearance then you will have to click \u201cview this form\u201d at the bottom and then view the source code in your browser. Copy the code and paste it into your HTML view of your web-editing program. From there you can edit the CSS and alter the appearance and images of the form to match your site. I will get into this in a later blog post in there is interest.<\/li>\n<\/ol>\n<p>The coolest thing for me is that now I can update what I have done in the garden without having to go to my computer. I just open my iPhone (picture of my scarecrow on the home screen btw) and bring the web page up in the browser and input what I have done right there in the garden before I forget!<\/p>\n<p><a href=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/phone.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-490\" title=\"phone\" src=\"http:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/phone.jpg\" alt=\"\" width=\"720\" height=\"540\" srcset=\"https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/phone.jpg 900w, https:\/\/eloine.com\/blog\/wp-content\/uploads\/2011\/06\/phone-300x225.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is for everyone who has had to create forms on a website to collect information. Unless there is some sort of automatic widget built in to your content management system this can be a complicated or time-consuming task. Google has made this ridiculously simple though so in case you aren\u2019t aware I thought I [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,8],"tags":[],"class_list":["post-468","post","type-post","status-publish","format-standard","hentry","category-garden","category-web-design"],"_links":{"self":[{"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/posts\/468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/comments?post=468"}],"version-history":[{"count":22,"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/posts\/468\/revisions"}],"predecessor-version":[{"id":632,"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/posts\/468\/revisions\/632"}],"wp:attachment":[{"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/media?parent=468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/categories?post=468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eloine.com\/blog\/wp-json\/wp\/v2\/tags?post=468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}