Category: Vtiger Solutions

796 ViewsIf you’re facing issues with a nested condition not working in the VTiger REST Query API, it could be due to the syntax limitations or specific query formatting required by VTiger. Here are some steps you can take to troubleshoot and resolve the issue: 1. Understand VTiger’s Query Language VTiger’s REST API uses a […]

797 ViewsThe error message you’re seeing indicates that VTiger requires MySQL to be configured with specific SQL modes during Vtiger installation or operation. To fix this issue, you need to update the MySQL configuration to set the appropriate SQL modes. Here’s how you can resolve the error: Steps to Configure MySQL SQL Mode: 2. Edit […]

765 ViewsTo validate fields in Vtiger CRM 6.2 for a custom module using jQuery, you can follow these steps. This guide assumes that you’re customizing the module’s form and want to ensure that specific fields are validated before submission. Step-by-Step Guide: Sample jQuery Code: Here is an example that shows how to validate a custom […]

788 ViewsTo export and import custom modules as a package using Vtlib in Vtiger CRM 7, you can follow these steps. This process allows you to move custom modules from one CRM instance to another. 1. Exporting Custom Module: Step 1: Use Vtiger_Module::getInstance to get the module you want to export. Step 2: Call the […]

775 ViewsIn vTiger CRM, the user_privileges files store the access permissions for each user. If these files become corrupted or you need to regenerate user_privileges Files (for example, after updating roles or profiles), you can do so through the following methods: 1. Using vTiger’s Recalculate Permissions Option The simplest way to regenerate user_privileges files is […]

758 ViewsTo add a custom dropdown with values dynamically fetched from the database in the lead form of vTiger, you need to perform the following steps: 1. Create a Custom Field for Dropdown First, create a custom dropdown field in the Leads module. 2. Modify the Database to Fetch Dynamic Values If you want to […]

770 ViewsTo unset a One-to-Many (1:M) relationship between custom modules and the ModComments module in Vtiger CRM 7 using VTlib functions in a PHP script, you can use the Vtiger_Relation::delete() function. Here’s how you can remove (unset) a custom 1:M relationship between your custom modules and the ModComments module: PHP Script to Unset 1:M Relationship: […]

776 ViewsTo unregister BeforeSave and AfterSave handlers in Vtiger CRM 7 using the VTlib library functions in a PHP script, you can use the Vtiger_Event::deleteHandler function. This function allows you to remove the registered event handler from your module. Here’s how you can unregister these event handlers: PHP Script to Unregister BeforeSave and AfterSave Handlers: […]

804 ViewsTo unset or remove a 1:M (One-to-Many) relationship between custom modules (or a custom module and a standard module like Calendar/Activities) in Vtiger 7, you’ll need to use PHP scripting with Vtlib functions. Vtlib provides a set of functions to manage module relationships dynamically, including adding or removing relationships. Step-by-Step Guide to Remove a […]

808 ViewsTo create a PHP custom function for retrieving all users based on a specific role in Vtiger CRM 7, you will use the Vtlib library, which is the framework for creating and managing custom modules and extensions in Vtiger. Steps to Create a Custom PHP Function to Get All Users by Role in Vtiger […]