Comment field expansion

[dreedy]

Our company uses the comment field to write out notes then that gets moved to our crm in the case of a special dispo. I see that the current comment field is limited to 255 character and that if i enable the note field that that is only bound by the TEXT structure of the mysql. Unfortunately, i am limited to using the comments field as the utility that moves the information over to the crm is hard coded to use that field and the rest of the lead information. Am i correct in thinking if i ALTER the comments field in the MYSQL to a VARCHAR (500) that this would enable the comments to go to 500 characters ? and would i need to expanded the agent and admin screen reference to allow the comment to be seen in one screen ? There does not seem to be a word wrap in the html code so it is one solid line.

[blackbird2306]

Yes by increasing to VARCHAR(500) it would be possible to save longer comments. I didn't find any other place, where this field is truncated. Further I don't think you need to expand anything, but try it by yourself.

[mflorell]

Yes, you can change the comments to VARCHAR(500) if you want and it should not cause any problems. As for newlines, the comments field can have them, but when put into the database, they are changed to '!N', and when the lead comes up in the agent screen, they are change to newline characters(\n).

[dreedy]

Thank you all i have tested this out and had to alter 2 places for the comments. vicidial_list and vicidial_comments. once i altered that to expand the store capacity to 500 char the information would go to 500 char. The line does not break though when reviewing the lead information. It is just one long string when view it in the agents screen or searching a lead.