Email field class is limiting characters to 32. How to increase the max length?

ngriffiths · ‎01-20-2016

We have a field class on our table that is a type of 'email'. How do I increase the max length the field will accept? I went into the field class table and set the length value on email to 200. I have also tried an attribute max_length=200; but it still is cutting emails to 32 characters.

ngriffiths · ‎03-28-2016

Hi all,

Here is the resolution to this:

1. Go to "sys_glide_object.list"
2. Find and open "email"
3. Enter "100" in the "length" field and save (or update).
4. Now go to the form you want that field on.
5. Add a NEW email field! You can use the same name if you want, but more than likely the actual name will change in the background.
6. Delete or move the first email field.

If you only have a few records, you can update the data manually or if you have a bunch, then you can export the data and then import the data to the correct field.

View solution in original post

billcravey · ‎03-08-2016

Hi Nicolle, Did you get a resolution to this?

Thanks

ngriffiths · ‎03-28-2016

Hi Bill,

Yes, please see the resolution below. Let me know if you have any questions .

Best,

Niccole

Anurag Tripathi · ‎01-21-2016

Reach out to HI, they should give you the exact steps and confirm the same form back end. i made similar change once but for some reason it did not happen in oracle in the back end so although i was seeing the increased field length but the text was still getting truncated after 40 chars.

-Anurag

ngriffiths · ‎01-21-2016

Thanks for reaching out Anurag

rob_blakey · ‎01-21-2016

Hi Niccole,

Sorry it wasn't exactly what you were after, out of curiosity I did some digging myself, and after enabling the class itself, it was then usable on any form i required just as 'string' would be, once I activated this default class i then placed this onto the form I previously had 'email' string setup and when I added this using the dicitonary method above I was able to just change the max length of the new field to 200 and worked fine.

Seeing as you seem to be having some odd Issues, as you have already done by the previous comments, raising a ticket to HI may be your best option.

Please keep us posted on the outcome as it will be interesting to see what ServiceNow resposnds with.