1

I have a module ABC in that i need to create another users picklist irrespective of "Assigned To" like already there for every module. I tried to create that by copying existed field for "Assigned To" in vtiger_field table. But it is not working for me nothing new happens in module ABC.

tabid : ABD(tabid)
columname : doneby
tablename : vtiger_crmentity
generatedtype : 1
uitype : 53
fieldname : doneby
fieldlabel : Inspected By
readonly : 1
presence : 2
maximumlength : 100
block : <confused>(Need clarification)
typeofdata : V~M
summaryfield : 1

i really confused with block and typeofdata field.

Can anybody help me to get users list field?

Subbarami Reddy
  • 101
  • 10

1 Answers1

1

You can easily create it by modifying tablename with vtiger_abc and block is likely to be same as where you expected follow the already existed block which you identify in vtiger_field previous colums in the same table.

More ever you need to create the same name field in vtiger_abc table also which must be varchar(size).

Change the typeofdata with V~0 this is for optional. Because "Assigned To" entity field will have mandatory so if you really need it as mandatory then let it be.

update these two fields.
tablename : vtiger_abc
block : <update with existing block of same table field>
Jaccs
  • 1,052
  • 3
  • 12
  • 33