Search code examples
phpsqlvtiger

How make mandatory field inactive in vTiger?


I am working on a project in vTiger(mainly concentrating on leads module). In that I want to disable to fields 'Created Time' and 'Modified Time', but it seems that I am not able to do so. I have managed to disable mandatory fields such as 'Lastname', 'Firstname' and 'Assigned To'(but I can not hide those fields).

I disabled those fields by changing the UItypes in vtiger_fields table.

Can anyone please help me on this one(to disable/hide fields: 'Created Time' and 'Modified Time' in leads module)?

Thanks in advance


Solution

  • You shouldn't change the presence column, because you need those fields to write times into the database (needed for history for example, because if you change it, you will always get 'created 44 years ago', because no 'Created Time' would be written into the database).

    Instead, change the displaytype column to 4. This way the Time columns won't be shown, while dates will still be written into the database tables. (You can google for an explanation of all displaytype options - there are 4 options.)