vtiger

[ales]

HOWTO integrate any field into Custom View as New Collumn or as New Filter ?

It will save time when searching by special fields not included in Custom View ilke Task, Call and Meeting status types from Activity Type field...

Easy. Here is my copa/paste from my code:

1.You must first insert row in table FIELDS:

INSERT INTO `field` VALUES (9, 380, 'activitytype', 'activity', 1, '15', 'activitytype', 'Activity Type', 1, 0, 0, 100, 20, 1, 1, 'V~O');

380 .. is autonumber like, check FIELD_SEQ table.
If the number is used increment FILED_SEQ field value (+1) !!!!!!

2. Insert row in table PROFILE2FIELD for each existing profile:

U MUST USE THE SAME NUMBER FOR fieldid !!!!!! (in this case this number is 380)

//Administrator
INSERT INTO `profile2field` (profileid, tabid, fieldid, visible, readonly) VALUES(1,9,380,0,1);

//Sales Profile
INSERT INTO `profile2field` (profileid, tabid, fieldid, visible, readonly) VALUES(2,9,380,0,1);

//Support Profile
INSERT INTO `profile2field` (profileid, tabid, fieldid, visible, readonly) VALUES(3,9,380,0,1);

//Guest Profile
INSERT INTO `profile2field` (profileid, tabid, fieldid, visible, readonly) VALUES(4,9,380,0,1);



THAT'S IT

Ok, for this you don't need the patch but it will be available soon.

By Ales