OAuth - Bridge between functionality and privacy

Imagine someone telling you they've created an itinerary mapping application that you can use to plan your vacation and it utilises your google calendar to help with which dates you need to be where, however in order to use it you need to handover your google username and password? No!

In a time where everything is personal but still privacy is high on the chain of command (Twitter doesnt allow you to private message someone that isnt following you and Facebook doesnt allow you to write on walls of people that you aren't friends with) there exists a door between convenience for a user to gain functionality and maintaining security.

This door is called OAuth.

Auto Tweet a welcome message!

At some point, everyone wants to gain more growth and create a community behind their organisation. Nothing like letting your newcomers feel welcomed by tweeting their presence on your twitter channel and signing them up to your mailing list via a google signup form.
 
So someone finally comes across your blog, website or even facebook page! Wow, great now that you've gotten this lead, how can you get them to signup for joining your community and ensuring they enjoy the process?

SpreadSheet Formula Vs JavaScript

Problem: I need to copy a spreadsheet formula in google docs down to other rows when a new form is submitted.

Solution: Create formula Cell c2 = b2 + a2
              Delete (shall I say it louder? DELETE all other rows below this row (row 2 in which u entered the formula)
            Then like magic, whenever any other forms are submitted, the formula will automatically copy itself down into the other rows. Of course, remember to use your absolute ($) expression etc depending on what you want to do.

Solution 2: Write a JavaScript file that reads the input from your spreadsheet, does the calculation and assign it to a variable. Then manually set the script to run each time a form is submitted (just google for google docs triggers).

I think I'll come back to this post and put up a nice and nifty little documentation with images and such.

Cheers.