Saturday, November 25, 2017

How to properly set Subforms in Zoho Creator Part 1

This is the most important step in the process of setting up your zoho creator database. A properly linked setup will enable your information to run smoothly and avoid waisting space ( MB )

First, you need to create at least 2 Forms. For example.- Orders and Items. An Order can have multiple items and 1 item can be part of many Orders. Creating a many to many relationship.

Second, you need to add the Subform Items inside the Form Orders and name it. Then you have to add a Lookup field in the Items Form and click on Existing Relations. 
Do NOT forget this part. This is the key. You must have a lookup field linking the original Form to each record on the subform you are creating. Makes Sense?

If it does not or need any help do not hesitate to contact us. We can guide you through the process to set your Subform for success.

Wednesday, October 11, 2017

Instantly Populate Sales Quotes from Zoho CRM

With a tool like Zoho CRM, you can easily manage your entire sales cycle from a single interface, leading to improved efficiencies and closing more deals.  Another way you can improve your sales process is to use WebMerge to automatically populate documents like proposals, contracts, quotes, and more.

In this example, we’re going to show you how to automatically populate sales quotes from data in Zoho CRM then we’ll email the quote directly to our customer for their review.

To get started, we’re going to set up the template for our quote using a Word document.  Inside Word, we’re going to add our repeating information like our logo, contact information, and details of our company.  For the spots that we want to insert our deal/customer info, we’re going to use merge fields that look like {$FirstName}, {$Address}, {$Amount}, etc.

Here’s what our quote template looks like:
 


Once we have our template finished, we need to upload it to WebMerge.  From the Documents page in WebMerge, click the New Document button and enter a name.  On the next step, select Office Document as the document type and then pick the file from your computer.
 


After you upload your quote template, you’ll be taken to the Settings tab where you can modify various options like the type of file that is generated and the name of the file.  For this example, we’re going to use the name of our deal in the file name and we’re going to generate a PDF.
 


Next, we’re going to set up the email delivery for our document so that the quote is automatically emailed directly to our customer.  Under the Deliver tab, we’re going to Edit the default email delivery.  For the To address, we’re going to choose the email merge field for our customer’s email address.  If you don’t have a merge field in your document, you can choose <<Other>> from the drop-down then enter something like {$Email} in the box.

Feel free to edit any of the other email settings.  Here’s what our email delivery looks like:
 


Once we have saved our email delivery, we are done with the setup process in WebMerge and we’re ready to integrate with Zoho CRM.  If you haven’t already, please make sure to install the WebMerge plugin from the Zoho Marketplace.

Inside Zoho, we’re going to go to the WebMerge Mappings module and we’re going to create a New Mapping.  After you give the mapping a name, we’re going to choose the Module we want to use (Potentials), then we’re going to choose the WebMerge Document we want to merge.
 


Next, we’re going to match up the merge fields in our document with the fields from our CRM.  This tells Zoho how to send the data over to WebMerge so that it’s populated in the correct spot on your template.
 


Once you have matched up all of your merge fields, go ahead and save your mapping.  We’re ready for a test!  Open up one of your Potentials and then click the WebMerge button (it might be under the “…” drop-down).  This will generate the quote and email it out!

Here’s what our quote looked like ready for the customer:
 


Congrats, you’re all finished!  You can now instantly generate all kinds of documents from your Zoho CRM data.  Can you think of any other ways you can use WebMerge to simplify your paperwork process?