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] <mailto:[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 <http://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]
    <mailto:simile-widgets%[email protected]>.
    To post to this group, send email to
    [email protected]
    <mailto:[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.


Reply via email to