Hi Everyone,
Can someone please help me im new on SuiteCRM. the problem im facing is that im unable to view the ID field in Leads, only name shows there, i can only see id in url or mysql leads table. Therefore i want to see the leads ID in my leads view and also want to change the auto increment format like 6 or 7 digit number is it possible? please reply>>
Welcome @Fakhrfar!
It is possible to accomplish that but not quite easy.
Instead you may create an autoincrement field on Leads and display it in the layouts. An autoincrement field is basically a Interger field (length 11) to be created through Extended vardefs with some additional attributes.
Take a look at cache/modules/Cases/Casevardefs.php and search for ‘case_number’.
You have to create the field “lead_number” and the index “leadsnumk”:
$dictionary[‘Lead’][‘fields’][‘lead_number’] = array(
‘name’ => ‘lead_number’,
‘vname’ => ‘LBL_NUMBER’,
‘type’ => ‘int’,
‘readonly’ => true,
‘len’ => 11,
‘required’ => true,
‘auto_increment’ => true,
‘unified_search’ => true,
‘full_text_search’ => array (
‘boost’ => 3,
),
‘duplicate_merge’ => ‘disabled’,
‘disable_num_format’ => true,
‘studio’ => array (
‘quickcreate’ => false,
),
‘inline_edit’ => false,
);$dictionary[‘Lead’][‘indices’][‘number’] = array (
‘name’ => ‘casesnumk’,
‘type’ => ‘unique’,
‘fields’ => array (
‘case_number’,
),
);$dictionary[‘Lead’][‘indices’][] = array (
‘name’ => ‘lead_number’,
‘type’ => ‘index’,
‘fields’ => array (
‘lead_number’,
),
);
Remember to run Quick Repair and Rebuild after creating the extended vardefs.
Regards
Hi, Andopes
Thanks for the reply i have created the field in studio with auto increment but it starts form Id 1,2,3 what i
need is to define my own number series consist of 5 or 6 digit number i.e 456723 how can i accomplish this?
So you don’t need an autoincrement field as you asked at your topic, right?
So you just need to create a regular Integer field.
Regards