{"id":9165,"date":"2024-09-19T05:46:08","date_gmt":"2024-09-19T05:46:08","guid":{"rendered":"https:\/\/www.infinitivehost.com\/knowledge-base\/?p=9165"},"modified":"2024-09-19T09:55:14","modified_gmt":"2024-09-19T09:55:14","slug":"add-custom-dropdown-dynamically-from-db-in-vtiger-lead-form","status":"publish","type":"post","link":"https:\/\/www.infinitivehost.com\/knowledge-base\/add-custom-dropdown-dynamically-from-db-in-vtiger-lead-form\/","title":{"rendered":"Add Custom Dropdown Dynamically from DB in vTiger Lead Form"},"content":{"rendered":"
<\/span> 1,657<\/span> Views<\/span><\/div>\n

To add a custom dropdown with values dynamically fetched from the database in the lead form of vTiger<\/strong>, you need to perform the following steps:<\/p>\n\n\n\n

1. Create a Custom Field for Dropdown<\/strong><\/h3>\n\n\n\n

First, create a custom dropdown field in the Leads<\/strong> module.<\/p>\n\n\n\n

    \n
  1. Go to the vTiger CRM<\/strong> dashboard.<\/li>\n\n\n\n
  2. Navigate to CRM Settings<\/strong> > Module Management<\/strong> > Module Layouts and Fields<\/strong>.<\/li>\n\n\n\n
  3. Select the Leads<\/strong> module and click Add Custom Field<\/strong>.<\/li>\n\n\n\n
  4. Choose Picklist (Dropdown)<\/strong> as the field type and give it a suitable label.<\/li>\n\n\n\n
  5. Save the custom field.<\/li>\n<\/ol>\n\n\n\n

    2. Modify the Database to Fetch Dynamic Values<\/strong><\/h3>\n\n\n\n

    If you want to fetch dropdown values dynamically from your database (e.g., from a custom table), you’ll need to modify the code.<\/p>\n\n\n\n

    Steps:<\/h4>\n\n\n\n
      \n
    1. Create a Table to Store Dropdown Values:<\/strong>
      Create a table in the database to store the dynamic values for your dropdown.<\/li>\n<\/ol>\n\n\n\n
         CREATE TABLE custom_dropdown_values (\n       id INT AUTO_INCREMENT PRIMARY KEY,\n       value VARCHAR(255) NOT NULL\n   );<\/mark><\/code><\/code><\/pre>\n\n\n\n
      Insert some initial values:<\/p>\n\n\n\n
         INSERT INTO custom_dropdown_values (value) VALUES ('Value 1'), ('Value 2'), ('Value 3');<\/mark><\/code><\/code><\/pre>\n\n\n\n
        \n
      1. Modify the Code to Fetch Values Dynamically:<\/strong> You’ll need to modify the core files to dynamically populate the dropdown values.<\/li>\n<\/ol>\n\n\n\n