Google Apps “Contact us” form example

You absolutely love our patented Google Apps integration and asked to keep the love flowing. You told us that money would drop from the sky if you had more ways to collect customer data. You begged us for new ways of getting out those stubborn holiday stains.

Just in time for the New Year, our team is proud to announce the first of a brand new dimension of Google Apps integration. Say hello to the Solve360 Google Apps Form! [hold for applause] This nifty little guy gathers data with a Google form and drops the data straight into your Solve360 account... and it’s a snap to setup: Simply watch the highly entertaining dance party video and then follow the carefully laid-out steps (don’t tell cousin Jeffery aka your web guy; with all these web apps around, he’s already worried about job security).

In the video it took only 2:30 to implement a basic form. Here's the step-by-step version of the video so you can try it out too. Please follow the steps below carefully, in sequence, or others will make fun of the odd look on your face.

Create a new spreadsheet with the Solve360 script

1. Open Google Docs > Create new > Spreadsheet > File > Rename... > 'Solve360 contact form'
2. Click Tools > Script Editor... > replace the text in the editor with this code i.e. open this web page, copy then paste the content, do not just paste the URL into the script editor
3. File > Save > 'Solve360 contact form' > Ok
4. Run > onInstall > Authorize
5. Run > onInstall (first time was to authorize, this time it does the work)
6. Click Resources > 'Current script's triggers...' > 'Add a new trigger' > choose the following options: 'onFormSubmit', 'From spreadsheet', 'On form submit'
7. File > Save > close the script editor

Create a form to capture data from the user

1. Click Tools > Create a Form
2. Edit the fields labeled 'First name' and 'Last name' selecting 'Make this a required question' checkbox
3. Edit the field labeled 'Comments' and change 'Question type' to 'Paragraph text'
4. Click Save > close the form editor window

Configure your unique settings and test

1. Click 'Solve360 by Norada' > Settings > enter your email and token > Save > close the settings window
2. Click Form > Go to live form

If the Solve360 menu > Modify user accounts > "Prevent Private Data" option has been checked for the user account being used to save the contact, then the Google Doc > Solve360 by Norada > Ownership field must contain a Workgroup ID.

Add extra fields (optional)

1. Click Form > Edit form
2. Add item ... > Save
3. Click 'Solve360 by Norada' > Settings > map the new fields to their Solve360 field names > Save > close the settings window

Although this example is ready to be used as-is for the prescribed “Contact us” form on your website, it was actually cooked-up in our test kitchen here to demonstrate the Cloud in action. Really, how cool (not to mention amazingly useful) is it to connect your data and processes evolving in the Google-sphere to your client and project database in Solve360? This is just a taste, the possibilities are exciting and endless.

As for the holiday stains... we have no idea what you guys are talking about.