{"id":9003,"date":"2024-08-30T07:06:14","date_gmt":"2024-08-30T07:06:14","guid":{"rendered":"https:\/\/www.infinitivehost.com\/knowledge-base\/?p=9003"},"modified":"2024-08-31T08:05:26","modified_gmt":"2024-08-31T08:05:26","slug":"create-datetime-field-in-vtiger-7-crm-module-using-vtlib","status":"publish","type":"post","link":"https:\/\/www.infinitivehost.com\/knowledge-base\/create-datetime-field-in-vtiger-7-crm-module-using-vtlib\/","title":{"rendered":"Create DateTime Field in Vtiger 7 CRM Module Using Vtlib"},"content":{"rendered":"
<\/span> 1,899<\/span> Views<\/span><\/div>\n

To create a DateTime<\/code> field in a custom module in Vtiger 7 CRM using VTlib functions, you’ll need to use the addField<\/code> method in conjunction with the Field<\/code> and Block<\/code> classes.<\/p>\n\n\n\n

Here’s a step-by-step guide to create a DateTime<\/code> field:<\/p>\n\n\n\n

Step 1: Initialize the Module<\/h3>\n\n\n\n

First, you’ll need to load the module where you want to add the DateTime<\/code> field.<\/p>\n\n\n\n

$moduleInstance = Vtiger_Module::getInstance('ModuleName'); \/\/ Replace 'ModuleName' with your custom module's name<\/mark><\/code><\/code><\/pre>\n\n\n\n
Step 2: Initialize the Block<\/h3>\n\n\n\n
Next, you’ll need to get the block instance where the new field should be added.<\/p>\n\n\n\n
$blockInstance = Vtiger_Block::getInstance('BlockName', $moduleInstance); \/\/ Replace 'BlockName' with the name of the block<\/mark><\/code><\/code><\/pre>\n\n\n\n
Step 3: Create the DateTime Field<\/h3>\n\n\n\n
Now, create the field instance and set the required properties for the DateTime<\/code> field.<\/p>\n\n\n\n
$fieldInstance = new Vtiger_Field();\n$fieldInstance->name = 'date_time_field'; \/\/ Field name in the database\n$fieldInstance->label = 'Date Time Field'; \/\/ Display label of the field\n$fieldInstance->uitype = 23; \/\/ UI type for DateTime\n$fieldInstance->typeofdata = 'DT~O'; \/\/ Data type; 'DT' for DateTime, 'O' for optional\n$fieldInstance->displaytype = 1; \/\/ Display type; 1 means always visible\n$fieldInstance->columntype = 'datetime'; \/\/ Database column type\n$blockInstance->addField($fieldInstance);<\/mark><\/code><\/code><\/pre>\n\n\n\n
Step 4: Save the Changes<\/h3>\n\n\n\n
Once the field has been created and added to the block, the changes are automatically saved to the database.<\/p>\n\n\n\n
Step 5: Assign the Field to Profiles<\/h3>\n\n\n\n
To make the field available to users with certain profiles, use the following code:<\/p>\n\n\n\n
$fieldInstance->setRelatedModules(array('ModuleName')); \/\/ Replace 'ModuleName' with the name of the module you want to relate<\/mark><\/code><\/code><\/pre>\n\n\n\n
Additional Notes<\/h3>\n\n\n\n