Web-Design web-design Google, Twitter and Facebook.: SpreadSheet Formula Vs JavaScript

Sunday, January 9, 2011

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.



Post a Comment