Integrating Google Forms in a WordPress Site [Following up requests]

I’ve had two requests in the last week for the following:

“How can we have a form that people can use to request a copy of a download, and then we can follow up later? I just want to use a spreadsheet.”

There are a number of autoresponder-type systems that allow you to create a form, where a mailer is sent day 0 (when they sign up) and then follow up emails are sent on the days that you specify after their sign up. This helps you to provide additional information, downloads or requests to contact you should they require more information. This is automated and requires very little in the way of manual human intervention and can be very useful. Mailchimp offers automation, as does aweber. If you do a search for ’email autoresponder’ or similar you will find a slew of options.

For those that I spoke to, they didn’t want to sign up for yet another service, and just wanted a simple list that could be leads generated from their website, where multiple users could view or share for follow up.

After a brief discussion, the solution that resulted requires:

  1. A WordPress website, and the installation of the Google Forms WordPress Plugin.
  2. Google Forms, and installation of the Form Notifications Add-On

Steps – Google Forms

  1. Create your form. If you are not sure how to do this, Google have a tutorial here. It can be a survey, however in this case a 3-5 question form is probably all you’ll want. Note: Make sure you specify that the email and name fields (at a minimum) are required fields (users MUST fill them out).
  2. Install the Form Notifications Add-On. To do this you need to open your form, click the Add-ons menu and then Get add-ons. You can browse the add-ons store, or search for “Form Notifications” Add-on. Click to install the add-on. (More help is available here if that was too brief)
  3. Configure your Form Notifications Add-On. Click on Add-ons –> Form Notifications –> Configure notifications. A sidebar on the right hand side should appear.
    configure-addonTo configure the sidebar:

    1. Configuring form notificationsNotify me. This is to notify you, or anyone you specify, that the form has been completed and the spreadsheet where the answers are collected has been changed. If you want a notification every time the form is updated, change “Send notifications after every” to 1 (the default is 10). If you expect a lot of response on this, then you can adjust accordingly. The higher the number, the lower the email frequency.
    2. Notify respondents. Specify which field contains the respondent’s email address (note that it is a good idea to make this a required field). Then compose the email they will receive. This is very simple with little personalisation. There are more sophisticated solutions should you want something with customisable fields, however the goal of this is to keep it simple. See the screen shot for more detail on how I filled this out for one client.
  4. Save and click on View Live Form. Enter values in to your form and make sure that it works the way you want before you integrate it in to your WordPress website. (You can use it as a link as-is, as well)
  5. Make sure the form is public. Untick the box at the top of the form that says “Require login to view this form” – otherwise your form will only be accessible to those that have a password, and won’t be able to be viewed when embedded on your website.

Tips

  • It’s a good idea to use data validation on your form, especially for email addresses. Fortunately Google Forms makes this relatively easy to do. See the screenshot below when setting up your fields.
    email validation
  • Click on view responses and make sure the data that is appearing is what you expect. This is the spreadsheet where your data is captured.

Steps – Wordpress Website

I am assuming you have a WordPress website and have some familiarity with its navigation.

  1. Ensure the Google Forms plugin is installed. If you are not sure how to install plugins, refer under the heading “Install a Plugin using WordPress Admin Panel Search Option” at this page for more information. The plugin you are searching for is called “Google Forms”. Once installed you should see Google Forms in the left hand menu of your WordPress Admin (it appeared under “Comments” in my installation).
  2. Select Google Forms –> Add New Google Form
    add-new-google-form
  3. Fill out the New Google Form Page. The page pretty much explains itself, but here is some information that I found useful:
    • Form URL – this is the link from the step above when you saved and clicked on View Live Form. If you need to, go back to the form above and copy the URL.
    • Confirm URL – you can leave this blank and you will get the standard Google message. Alternatively you can set up a thank you page on your blog (Pages –> New Page) and then copy and paste the URL of that page here.
    • Style – I prefer to select ‘redirect’ for this as I got some weird behaviours for ‘AJAX’ with my template. Your results may vary.
    • Email –  I left this off as I am using Google Forms to do this. You can use the plugin to do this – up to you. It suited me to use Google Forms so that the email address was collected in to the spreadsheet.
    • Reset form cache – I ticked this while I was making tweaks to my form. Once I had the tweaks done, then I unticked this box.
    • Validation – you can choose to do validation here or on Google Forms side… just remember that the name of the field here has to exactly match the name in the Google Form, and it’s case sensitive.
    • The rest you can fiddle with to determine if the settings suit you, however these are the minimum considerations for getting the form up and running.
  4. Publish the form. Click Publish 8-|
  5. Get the form shortcode. You will need to embed this in another page to view the form. To do this, from the menu click on Google Forms to see the summary page of all the forms you have created so far. Copy the appropriate shortcode – it should look something like this:
    shortcode
  6. Paste the shortcode in to your page or post. Just paste it in, publish the page and view and you should be able to see your form.

I like to put the form in a column format, which you can do using CSS, or tables (depending on your level of expertise).

columns-forms

 

 

How to Add a Tick Symbol ✓ to Writer documents [LibreOffice, OpenOffice]

To insert the tick (✓) symbol into a Writer document, follow these instructions.

From the menu (in Windows and Mac) click on Insert –> Special Character.

From the Font dropdown, you need to select a font that will include the tick symbol. Times New Roman does NOT include this symbol. One font to use is OpenSymbol.

Select OpenSymbol and then scroll down until you see the tick symbols – see screenshot for an example.

You can double click on the symbol to insert into your document, or click once on the symbol and then click ‘OK’.

Reader Question: Showing and Hiding Themes [OpenOffice & LibreOffice]

show-hide-themes

Jerry left a comment saying that he had trouble with the following: “cannot find how to show/hide themes in calc” Thanks, Jerry. I’m not sure if this is exactly what you mean, but some refer to the Gallery in OpenOffice as ‘themes’. (Please leave a comment below if this is not what you meant.) To show […]

[Continue reading…]

Beautiful borders and backgrounds in OpenOffice [or LibreOffice]

Table properties box

I received the following query from Melissa: How do I create page borders that are nice, like ivy leaves or coloured swirly lines? All I can figure out are the straight black border lines. Thanks, Melissa. Personally, I’ve found that the border tool is generally only for variations on the straight border as you have […]

[Continue reading…]

Spell check does not work for Mac 2011

ms-mac-spellcheck-methods

If you are having difficulties with spell check Mac in the new Office 365 suite, then it’s probably no surprise – especially if you’re not using Windows and not in the US. However I find that the advice provided on the MS website is actually working for me, so I’d suggest running through the first […]

[Continue reading…]

Quickly See All the Formulas in Excel with This Shortcut

20131108-083027.jpg

I’ve been flat out so haven’t updated this in a while – apologies to those who’ve used it as a resource. I came across this today, which has been timely as I needed some help with a pesky spreadsheet. Something wrong with some numbers in that spreadsheet? Lifehacker has a shortcut that displays all the […]

[Continue reading…]

Making Search Relevant and Recent (Getting Help that Helps!)

google-search.png

Often, when people search for information on the web, they put search terms into Google and click search. This is especially relevant to searching for solutions to software problems as you want the solution to apply to the version of software that you currently have (if you have the most up-to-date version). Unfortunately, this general […]

[Continue reading…]

Integrating Google Maps in your documents (taking screenshots)

screenshot

A friend of mine recently asked how can he integrate a Google Map into his document. The easiest way to do this is using a screen shot, however it is important to note that if you are going to use a map from Google, you need to attribute it. According to my reading of this […]

[Continue reading…]

How to Extract Media from PowerPoint Files (works for both Windows and Mac)

rename-zip

Lately I’ve been receiving a number of files in pptx format, but I present using my iPad and so convert these presentations to Keynote. If the slides contain images and text only, this conversion is relatively painless – usually there are just a few formatting and alignment issues that need to be addressed and then […]

[Continue reading…]

FAQ: How to I change the default language in Word for Mac? [Word 2011]

language-menu

With Office 2011 for Mac, you can check spelling and grammar in languages other than English. Word 2011 for Mac comes with foreign-language dictionaries such as Czech, French, Russian, and you can also change the ‘brand’ of English (UK, US, Australian). The default dictionary determines which language’s proofing tools Word uses for spelling and grammar. […]

[Continue reading…]