tag:blogger.com,1999:blog-5826651679423515354.post6440887766851390562..comments2023-04-25T19:37:05.486-05:00Comments on chadkafka.com blog: Using Google Forms FormEmailer ScriptChad Kafkahttp://www.blogger.com/profile/12657981899446042096noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-5826651679423515354.post-87423488365010746222013-10-15T11:16:49.721-05:002013-10-15T11:16:49.721-05:00If anyone can shed some light....
Some advice plea...If anyone can shed some light....<br />Some advice please.<br /><br />I have a form that I'm using for registration. The form is setup to send a copy of submission to two people (person filling in registration form as well as attendee). However, if someone (lets say Admin Assistant) is registering more than one person I would like for the Admin Assistant to still continue to get a copy of theAnonymoushttps://www.blogger.com/profile/02590376955889726489noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-24603027058937049522013-09-06T15:29:49.979-05:002013-09-06T15:29:49.979-05:00I am having a hard time including a hyperlink in m...I am having a hard time including a hyperlink in my email like you have in the last line of your example. I'm using this as the HTML code but it's not including a hyperlink<br /><br />Here's my code. Do you know why it's not linking the text?<br /><a href="%E2%80%9CURL%E2%80%9D" rel="nofollow">this form.</a>Jen Jonsonhttps://www.blogger.com/profile/15320702440418352921noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-20361476743497887512012-09-05T18:55:43.543-05:002012-09-05T18:55:43.543-05:00couldn't you use a scale type question with 1-...couldn't you use a scale type question with 1-4 and get a point that way?emccarthyhttps://www.blogger.com/profile/13736633711626419655noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-33656569956248368132012-05-07T15:25:15.737-05:002012-05-07T15:25:15.737-05:00Not to my knowledge without some crafty scripting ...Not to my knowledge without some crafty scripting work. I just keep the points in a range that I can quickly add them in my head.Chad Kafkahttps://www.blogger.com/profile/12657981899446042096noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-87856728745381401132012-05-07T15:23:41.250-05:002012-05-07T15:23:41.250-05:00Is there a way to assign point values like one wou...Is there a way to assign point values like one would with a traditional rubric and have the points appear in the email and on the spreadsheet?khurst2007https://www.blogger.com/profile/07841446638387676476noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-36871017946475491702012-05-07T14:20:59.328-05:002012-05-07T14:20:59.328-05:00This comment has been removed by the author.khurst2007https://www.blogger.com/profile/07841446638387676476noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-61895225755036170102012-03-09T20:45:15.109-06:002012-03-09T20:45:15.109-06:00In response to Fel's question, a quick and eas...In response to Fel's question, a quick and easy way to accomplish would be to use the importrange function. It can pull pre-formatted data from one spreadsheet to another 'master' sheet.Kern Kelleyhttps://www.blogger.com/profile/16918073875608014468noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-74092633850168686242012-03-06T09:19:13.530-06:002012-03-06T09:19:13.530-06:00The script should now be back in the gallery.The script should now be back in the gallery.Michelle Russellhttps://www.blogger.com/profile/13423893096446320755noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-1630645426339036612012-02-29T08:29:32.710-06:002012-02-29T08:29:32.710-06:00Chad and Henrique -
Awesome post. Thank you so m...Chad and Henrique - <br />Awesome post. Thank you so much. I went into the Script Gallery and can no longer find the FormEmailer script to choose. Are we just waiting for Google to approve the script?<br /><br />Thanks, JaredMr. Reckhttps://www.blogger.com/profile/04095777859955637979noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-26985830408541743462012-02-24T16:05:19.720-06:002012-02-24T16:05:19.720-06:00Henrique - thanks for the comments and the update ...Henrique - thanks for the comments and the update on the "trigger" stuff. I'll have to edit my post to incorporate your new information. Really appreciate what you did to make the FormEmailer script. Very excited to be using it with students.Chad Kafkahttps://www.blogger.com/profile/12657981899446042096noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-24837929807569266662012-02-23T07:12:21.638-06:002012-02-23T07:12:21.638-06:00Nice post Chad. I'm Henrique, the FormEmailer ...Nice post Chad. I'm Henrique, the FormEmailer developer.<br />The trigger setup instructions didn't showed up in the spreadsheet because of a new issue on Google Apps Script API.<br />http://code.google.com/p/google-apps-script-issues/issues/detail?id=1106<br /><br />You can break up the cells merge manually and the instructions will appear.<br />The trigger used with this version of the Henrique Abreuhttps://www.blogger.com/profile/12437855938041506624noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-5834113500917229162012-02-18T08:12:15.006-06:002012-02-18T08:12:15.006-06:00Hey Claudia. Thanks for the compliment! Glad it c...Hey Claudia. Thanks for the compliment! Glad it could help. I don't know off hand how to do what you're asking. However, I would check out Hank Thiele's blog post here where he shares a way to do the "form collection" like I posted about but have it go an extra step where it also puts that individual submission in a Google Doc Folder as a "Google Document." He Chad Kafkahttps://www.blogger.com/profile/12657981899446042096noreply@blogger.comtag:blogger.com,1999:blog-5826651679423515354.post-89004012777920003172012-02-18T08:03:24.072-06:002012-02-18T08:03:24.072-06:00Wow- fantastic! Thank you Chad! A related question...Wow- fantastic! Thank you Chad! A related question to walk-throughs- is there a way for admin to have a running google form for each teacher, but then also merge the form data from all teachers in a building, and then again across the district? My superintendent really wants this functionality. Any advice? Thank you! Claudia FelskeFelhttps://www.blogger.com/profile/04082704552854773914noreply@blogger.com