Tuesday tip: Create custom forms with Google Drive

If you have a Google account and access to Google Drive, create a form there. (I’ll leave the how-to on that to your own research. It’s not difficult.) “Share” the form so that you get the link to the form, and create a bookmark in DEVONthink for that form. When forms are created in Google Drive, you have the option to create a spreadsheet there to collect the responses. Do so, then navigate to that spreadsheet and grab the link for it. Create a second bookmark in DEVONthink for the spreadsheet.

Forms can be completed by you as you take notes (put them in their own windows). If you have text fields in your form, you can drag text or RTF files to those fields and the content of the files will be inserted into the field. You can drag in URLs, images, etc. into various fields. Just be sure to “Submit” the form when you update it, and the data from that form will be appended to your results spreadsheet. Internet access is necessary for the Google apps, of course.

A great tip from DEVONthink and forum power user korm — thank you!

2 Responses to “Tuesday tip: Create custom forms with Google Drive”

  1. Katrin says:

    I just came across this awesome tip, but experienced it not working as described – not sure why.

    Adding the form as a bookmark to DEVONthink works just fine.
    The spreadsheet that collects the responses however (added as a bookmark also), does not open up in DEVONthink. What I get is the Google login screen instead, asking me to log into my Gmail account.
    -> which raises another question: If I would enter my password there, would it be saved somewhere in DEVONthink?

  2. eboehnisch says:

    @ Katrin: Yes, DEVONthink acts like another browser here and you need to log into your Google again also from there. It does not save your password but you might be asked by WebKit (the underlying Safari engine) if you would like to save it to the keychain.