Introduction

Natural Language Query (NLQ) enables you to interact with a database in conversational language instead of programming language or syntax.

Instead of learning complex query languages or database structures, you can ask questions or provide statements in your own words, similar to how you would communicate with another person. For example, you can look up records by using a simple statement like, List all duplicate records created in March.
 

​

The Ask Calculus AI feature supports NLQ commands. ​​

In the CRM, you can create contacts, tasks, events, or other records. Here are a few examples.

• A command like ‘Create $100k deal related to John Smith for opening a new coffee shop.' will create a deal record linked to a contact John Smith, with all the deal details.
• A command like ‘Create an important meeting with Syria tomorrow at 11 AM for one hour' will create an event record for a contact with the name Syria with all the details mentioned. 

You can also display record summaries of NLQ commands. This feature uses GPT to extract relevant details from the CRM to create a record. Use the /command in the Ask Calculus AI window to display information related to the record. 

Feature Availability

Benefits of NLQ

Natural Language Query offers the following benefits:

• Ease of Use - Makes it easy for non-technical users to interact with Vtiger CRM, to pull up data, or to perform simple tasks like creating events, contacts, etc.
• Makes interactions conversational - You can ask questions or provide statements in their own words, making the interactions with the CRM more conversational and familiar.
• Reduces navigation and steps - You can give commands in English to Calculus AI to perform tasks, thereby decreasing navigation and click-time. 
• Bridges the gap between technical and non-technical users—Natural language helps enhance communication and understanding since it is like conversing in a language that any common man can understand.

Query Examples

• Record Search
  • Find deal acme OR Search deal acme
• Record Summary
  • Summarize deal acme  OR Summary deal acme OR Summarise deal acme  OR /sm deal acme
  • Summarize case acme  OR Summary deal acme OR Summarise deal acme  OR /sm deal acme
• Record Creation
  • Create a $100k deal related to John Smith for opening a new coffee shop, and close the deal by 15th Aug this year.
  • Create an important meeting with John Smith tomorrow at 11 AM for one hour.
  • Create a medium-priority reminder task to follow up with Deal Acme tomorrow at 4 PM.
• Report/Chart 
  • Fetch records that are assigned to me:
    • Show my open tasks
    • Show my meetings
    • Show my deals
    • Show my tasks which are due this week.
  • Fetch records that are not closed:
    • Show open deals 
    • Show my open deals
  • Fetch information by grouping the data:
    • Show me open deals by the owner
    • Show me open cases by group
  • Fetch information by using multiple groupings:
    • Show my open deals by sales stage and pipeline
    • Show my open deals by sales stage and owner
    • Show me cases by owner and group
  • Fetch information with conditions and grouping:
    • Show Invoices that have a due date this month grouped by status
    • Show my open Organizations having mailing country in India, France and status in hot and group by owner, status
  • Date-based reporting:
    • Show Contacts that were created between 1st Jan 2023 to 31st dec 2023
    • How many deals were created this week?   (this month/this quarter/this year are also supported)
    • How many deals were created last week? (this week/last week/current week/previous week/next week are also supported)
    • Show deals that are closing after 31st March (before is also supported)
    • Show the top 10 open deals of this month
    • Show recent five contacts created this week
    • Show me open deals whose expected close date is in the next seven days group by sales stage (before & 7/30/60/90/120 days are also supported)
  • Chart type reporting:
    • Show Invoices that have a due date this month grouped by status in the pie chart (donut/bar/column are also supported)
    • Show deals by sales stage and sales agent this quarter in the pivot table
    • Show open cases by group and owner in the pivot table
  •  Get counts:
    • How many deals are there?
    • How many open deals?
    • How many open deals were created this month?
    • How many deals closing this month?
    • How many open deals closing next month?
    • How many open deals closed this month? - not working. It is using deals that are closed but with created time this month.
    • How many deals were created this week?   (this month/this quarter/this year are also supported)
    • How many deals were created last week? (this week/last week/current week/previous week/next week are also supported).

Using NLQ

Follow these steps to use the NLQ in the Ask Calculus AI feature in Vtiger CRM:

1. Log in to the CRM.

2. Click the Ask Calculus AI icon.

3. Go to the Type Query or /Command field.
4. Type your Query.
5. Click Send.

NLQ will analyze and respond accordingly to your queries.

Note: Do not send confidential details such as email and phone. Also, please note that CRM administrators can view the submitted prompts to track usage.