Rick Klassen of Klassen Specialty Hydraulics contacted us at InterlockIT.com to see if we could streamline the "tedious" quoting system that they had been using: searching for a similar quote, editing it manually to reflect the new requirements, and then saving it to a new folder on a local server, all followed by opening a spreadsheet that doubled as a database and adding the details of the new quote. And forget about trying to create a new quote from a mobile device or when you were out of the office!
We found that with a bit of custom work, we could make Rick's life much easier, and that's exactly what we did. Here's how.
To start, we need to establish the conditions that allow Solve360 and Google Apps to talk to each other--we want to automate repetitive things, so an activity template is used in Solve360. We insert it, and kick off the first of two scripts by clicking "Create new quote":
|Insert an activity template to get started.|
Once the user submits the Google Form, the second script is executed. The second script processes the latest submission, reading it from the spreadsheet in which Google Form submissions are saved, and performs a number of actions on it. In a later blog post, we'll detail exactly how some of the scripts work.
Finally, the Solve360 record for the contact is once more updated. This time we can see that the script has added two follow-ups with different dates, created a direct link back to the above Google Document so it can be reached quickly and easily, and inserted an Opportunity record that allows you to track the progress of the deal as it moves forwards.
|Here are the final activities that the script adds to the Solve360 record.|
"These days my colleagues and I can create quotes in a snap (from desktop or mobile), and we each get an email whenever a new quote has been created so we can collaborate on it in real-time, then send it to the customer. This can all happen in a matter of minutes from start to finish."
All this is done in the background, completely transparently to the user, and takes the hard work out of creating quotes, leaving you to focus on the important things—like closing the deal.