"Forms" has absolutely no error checking/validation capability. If erroneous data is entered, it goes into the spreadsheet. You can handle the form entry in a script, but you can't invalidate the entry or have the user go back and fix it. Google says any such mechanism would be beyond the scope of "Forms", saying any validation shouldn't happen on the server side... I'm guessing they are against "cloud computing".
On Tue, Jan 18, 2011 at 4:27 PM, Vic Fryzel <[email protected]> wrote: > Hey Viperay, > > Have you seen Google Forms? > http://docs.google.com/support/bin/topic.py?hl=en&topic=15166 > > Sounds like those will handle what you're looking to do with much less > effort on your part. > > Thanks! > -Vic > > > > > On Sun, Jan 16, 2011 at 3:52 AM, ViPeRaY <[email protected]> wrote: >> Hey Folks, >> I am planning to migrate from SharePoint to Google Spreadsheet. I am posing >> this because I have no idea how to start. Basically I have a small job >> database which have the information below: >> ***** >> Job Number >> Customer >> Address >> Phone >> Job Specs >> ****** >> I have imported the database to Google Docs without a problem. In >> Sharepoint, I am currently using Infopath forms to query and enter data to >> database. Basically I would like to accomplish the same here. I want to >> create a form where users can enter job information to create a new job and >> add that to the spreadsheet. >> I also need couple forms where users can enter the job number and view the >> related data such as Customer name, address etc. They also need to be able >> to print this as well. >> I am leaning towards using Python to accomplish this. I have basic >> programming knowledge in C++ and Java. >> First of all, can I accomplish what I am trying to do with Google >> spreadsheet? Also I know the API also supports Java. Which language should I >> use, Java or Python? >> I appreciate all the advices and help. >> Thanks a lot. >
