Wednesday, June 27, 2012

Today I've been working on integrating Google Forms and Google Spreadsheets. I've been playing with the form to make it a data entry process resulting in a spreadsheet that can be further refined to complete the OSSS Evaluation Process.

I changed the column order that the form generated on the spreadsheet. I made data validation on the spreadsheet to see if it will kick back to the form with invalid data but it DOES NOT interact with the form and therefore can generate invalid dates and data.

It is important to me to generate a unique combination of Last Name-First Name-Date of birth, so they are required on my form. However, this is NOT a great database platform and it will not be foolproof. (Maybe I shouldn't sign my name to it!). At a minimum, I guess it will give the OSSS staff a taste of what they could have to streamline their process.

One thing I did last night was to embed the form into my website in School Center. Be advised that I don't like the look of the theme on the form when it's embedded because you can't read it. The actual format you may see now is subject to change. 


I'm creating a link to my site to the form. CLICK HERE to see my home page (this is the better way) or click on the NEW OSSS PROCESS to go directly to the form. If you select the form from the website, you will get the real feel of how it may be used from a website (rather than being emailed a copy of a form to fill out. Ultimately, I might have this on a password-protected page that can only be used by authorized users. 


** IMPORTANT INFORMATION ABOUT FORMS:
The Google blogger site as well as Google forms are dynamic (I think this applies to all google products, but I can't vouch for that yet) . That means that when you change it and save the changes, it has changed how it looks to EVERYBODY from now on (until your next update). So if you sent a link with a typo, for example (like I did yesterday), once you catch it and fix it on your blog or form, there is no need to worry further because it is fixed forever more. Even when your form is embedded somewhere, it is using the current version of the form (even when it's on YOUR google "drive"). It is not accessing your computer; rather, it takes it from the "drive" up there in Google-land. 

No comments:

Post a Comment