PROBLEM: If the initial user (student/parent) fills out the form and uses Quotes or Backslash or a Hard Return when telling their story, this causing the hyperlink to NOT work in the FormMule email. I have a screenshot of what I mean below.
1) Is there any kind of 'extra' step I can do in the spreadsheet with a formula that will make this really long/custom URL into something like a tiny or shortened URL so when it's pulled into FormMule, it will work? (When I go to the spreadsheet and highlight the entire contents of the cell where the URL is and copy/paste into a new tab, the URL works)
2) Other suggestions on how to fix.
I also made a video here that shows this process if helps. Would love any feedback.
We have a spreadsheet of our locker combinations for our padlocks we issue to students (sample picture below)
In row 2, I set a CONDITIONAL FORMAT for CUSTOM FORMULA for cell C2 as =B2=1 to turn that cell Yellow. I can repeat for cells D2, E2, F2 and G2 so that if the head custodian puts in to use combo 1, 2, 3, 4, or 5 in row B, then the correct cell will highlight with the in-use combination. My problem is this -- how do I COPY that Conditional formatting down to the next rows so that the formula in the "custom formula" changes to work for B3 and B4 and B5 and so on.
I understand I can highlight and copy my first row and then PASTE SPECIAL > CONDITIONAL FORMATTING but the formula stays locked on for the first row of information rather than changing to the current row. Maybe I need to use a different formula? Help?
I hope none of you have been affected but you can never be too sure!
g(Math) is now available as an Add-on live in the Google Chrome Store!
I am super excited that gMath is now available as an official Add-on live in the Google Chrome store. You can now add it to your Add-on list
Great Plains Summit Featuring Google for Education
July 19–20th, 2012. Southwest High School, Lincoln, Nebraska.
Official Google Enterprise Blog: Bringing it all together for Google App...
With this new combined storage, you can use your storage how you need to. If your business or school is like most, you know how many importa
Teacher Tech Talk #07 - 15 Pounds of Equipment!? - EdReach
ttt-300x300. Te@cher Tech T@lk #07 – 15 Pounds of Equipment!? In this episode, we welcome a guest for the episode in the form of Mrs. Beth L
Google Driving With Students | Developmental Studies Center
Students and staff at Forest Park Middle School in Franklin, Wisconsin received Google Apps for Education accounts during the 2011–2012 scho