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
Great..
ReplyDeleteCan you freeze form input fields for cancellations of identical data ?
Hi Rory:
ReplyDeleteAs 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
Thanks Yogi..
ReplyDeleteWhat 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?
Hi Rory:
ReplyDeleteGoogle 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
Yep, I have a rough Idea how to pass the parameters in Google Apps Script.
ReplyDeleteWill have a go...
Thanks again for your Help!
Rory