It's straightforward to set up Workbooks to create new cases, and update existing cases, via email. The idea is that users can send an email to a support email address, the email is logged in Workbooks, and an acknowledgemet email is sent back to the user. Here I'll outline the steps you'll take to implement this for yourself.
There is an Email to Case script provided in the Workbooks Script Library. It checks an email account held on an IMAP-capable email server (most email servers, including MS Exchange and Lotus Notes, support IMAP) and, if there is email:
- copies the email into Workbooks;
- either finds an existing case or creates a new one;
- links the email to the case;
- ensures the case has an appropriate status;
- notifies the originator of the email as appropriate, attaching the received email and including the case number;
- and moves the email into an archive folder.
At Workbooks we use this to deal with received customer support emails; rather than monitoring the INBOX folder we have the process set up to monitor a 'Workbooks Case' folder and drag relevant emails into this. This reduces the number of unnecessary cases and case updates we have to deal with. Our policy is to keep the INBOX empty so that all cases are handled within Workbooks.
When a user replies to the acknowledgement email the case number is included so the reply also ends up associated with the case; and the case is flagged for attention.
Copy it to your own database using the Copy to My Scripts button. You can now Save the script (click to enlarge the image). There is no need to read or change the Source Code but it's there if you need the flexibility.
Once you've got the script you need to set up a Process to run the script. it can be invoked as frequently as once per minute - like this (click to enlarge the image):
Before saving the new scheduled process go to the Parameters tab for the process and set values for each parameter. There are a lot of options but each is fully documented in the screen where you enter its value (click to enlarge the image).
The only parameter which is a little difficult is the IMAP Flags parameter - these are passed straight to PHP's imap_open function when the script connects to the IMAP server. The correct value depends on the email server; for an SSL server we use /novalidate-cert/ssl and it's left empty if SSL is not being used. The documentation for the imap_open function, here, details some more possible values.
Having set the parameters, save the process and wait for logs to appear in the Process Logs area. Each time the script runs a record is created here. If there are errors you can find out what is going wrong by reviewing the log; perhaps a username or password is incorrect.
That's all there is to it.