Wednesday, February 8, 2012

yogi_Recreating Form For Entity Evaluation Program For Select Answers


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user ms.sudderth said:
I am trying to recreate these forms that teachers created and now I want to email the completed recreated forms.
---------------------------------------
following is a solution to the problem based on simulated data as in your spreadsheet. In this solution I chose to do the following:

1) not display (withhold) the information regarding Attendance
    so the response to that question will be blank

2) in regard to Contact Info ... I provided a default answer:
    on file

5 comments:

  1. Great..

    Can you freeze form input fields for cancellations of identical data ?

    ReplyDelete
  2. Hi Rory:

    As of now, Google Form is pretty simple, and one can not use any formulas within Google Form so one would not be able determine whether entry in an earlier question has been repeated in the Form ... if that is what you mean.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete
  3. Thanks Yogi..

    What I meant by freeze was that the text input/selects would not be re-editable!.. disabled!

    To create the equivalent of the HTML: (input type="text" name="name" disabled="disabled" /)

    Is that possible?

    Is there a reference for all the spreadsheet/docs parameters?

    ReplyDelete
  4. Hi Rory:

    Google Form used natively in the spreadsheet environment does not have any coding capability ... you may want to explore using Google Apps Script to see if you can accomplish what you are intending to do.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete
  5. Yep, I have a rough Idea how to pass the parameters in Google Apps Script.

    Will have a go...

    Thanks again for your Help!

    Rory

    ReplyDelete