User Setup, Department drop down list?

SUGGESTED

I would like to modify one of the User details fields.

In user setup, there is a field called user_department.  I would like to create a drop down list to populate this field.  However, I don't see how to do that in the CRM interface.

If you go to the field list, it is not a field that appears on the field screen. 

Typically I would use the "Team" field to represent a department.  However, this system was not setup that way and currently the "Team" field represents a "City".

It is my assumption that this field is not displayed on the field list because it is a field that is used with one of the integrated systems.  In regards to the system I am working with, it is not integrated with one of the Sage CRM integrated systems available.

Since this is not an integrated system, would I run into any issues if I modify this field to accomodate a drop down list? (I understand that I would need to make the field visable and change the field type.)  

My other option would be to create a new field.  However, I think it is confusing to then have two department fields on the user setup screen....therefore, I would be looking to hide the current one.

I appreciate any assistance provided.  Thank you!

  • 0
    SUGGESTED

    For some reason the field is flagged as a 'system' field and is therefore not visible in the GUI. 

    You can change this by editing the Custom_Edits record WHERE ColP_Entity = 'Users' AND ColP_ColName = 'User_Department' - change the ColP_System value to 'N' (or NULL).  In CRM, refresh Tables and Columns metadata.  The field will then appear in the Users secondary entity Fields list and you can change it to a Selection type.