Check out this article on Google Spreadsheets. It will show you a way to get your formula in a column. The EXPAND and ArrayFormula add your calculations as rows are added with form submissions. Search for =EXPAND(ArrayFormula(A:A*2)) in the article or read it from the beginning https://support.google.com/drive/answer/71291?hl=en
I did make a second sheet in my Google Spreadsheet. The first row of the second sheet has the Exhibit names for each column. Most rows are filled from data in the first sheet. One column has my function for looking up geo codes and is not in the first sheet which is populated by the form. There may be a better way to do many of the things I'm doing with this spreadsheet. It was the first one I ever did. George Adams On Thu, Jul 11, 2013 at 6:53 PM, David Karger <[email protected]> wrote: > I've used this technique but I've found it limiting. I can and have used > a form to create new entries that then populate an exhibit. However, I > often find that I need to add some *computed* column to the raw data coming > in (e.g. geocode an address). The obvious way to do this would be do fill > the whole column with the desired function, leading to a new value being > calculated when the form adds data to a new row. Unfortunately, when > google forms adds a new row it is truly new---it creates an entirely new > row, which does *not* contain my function in the column that I filled. > I've never found a way around this. > > > On 7/11/2013 10:59 PM, George Adams wrote: > > I did something like this 4 years ago. A Google form that populates a > Google spreadsheet. The spreadsheet has a script to look up geocodes and > based on the address adds a pin to a map of local businesses. It uses a > very old version of Exhibit > http://www.hayriverti.org/local-directory-map > > It doesn't always load on the first try so if the map doesn't show try > reloading the page. > > Sign up form is here. > http://www.hayriverti.org/local-directory-map/directory-sign-up-2 > > Since the site is a Google Sites web site I also needed to create a > custom widget and embed the Exhibit code in that. > > > George Adams > > > On Thu, Jul 11, 2013 at 1:31 PM, Matt Denman < > [email protected]> wrote: > >> I am doing something similar with WordPress and Gravity forms ( >> http://www.gravityforms.com/). I am working on a plugin for wordpress >> that will let you embed a timeline into a wordpress page and then configure >> it to use content from the form responses and posts in the site. This way >> the data stays with me on my server. >> >> On Wednesday, July 10, 2013 10:39:14 AM UTC-4, Andrew Taylor wrote: >>> >>> Hi all, >>> >>> For some time I've been experimenting with using Google Docs forms to >>> generate data for spreadsheets . I have used one in the past to get >>> students to create metadata for their art images (similar to crowd-sourcing >>> already), and for the past through years have used a form to keep a log of >>> what I accomplish at my job. >>> >>> Point is, I rant through the tutorial for creating a timeline that >>> references a spreadsheet. I created a timeline for an early Jazz band, >>> then was thinking that I might try to start a crowd-sourced project to >>> build a timeline for the 20s recordings by jazz bands. >>> >>> I have a decent source for data in the Red Hot Jazz Archive ( >>> redhotjazz.com, an old-school non-database website) and a discussion >>> group of aficionados who might participate (many of them older and perhaps >>> having limited tech experience). >>> >>> Have any of you used Google Forms as an interface to enter timeline >>> data? >>> >>> Regards, >>> >>> Andrew Taylor >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "SIMILE Widgets" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/simile-widgets. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > You received this message because you are subscribed to the Google Groups > "SIMILE Widgets" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/simile-widgets. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- > You received this message because you are subscribed to the Google Groups > "SIMILE Widgets" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/simile-widgets. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/simile-widgets. For more options, visit https://groups.google.com/groups/opt_out.
