Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Move to bigger custom field

SOLVED
Go to solution
Highlighted
Steve Liddle
Super Collector

Move to bigger custom field

We are currently using a custom field (String 40) to store the contact email for the caller on a service call. It turns out that this is not big enough for some email addresses and I'd like to change to a new custom field that is a String 80. I'm wondering if others have been through this kind of exercise and what I need to consider when making this change? So far I have come up with:
- create new custom field
- put new field on forms
- remove old field from forms
- copy existing values to new field
- modify rules that reference old field
- modify web service code that references old field

Are there other things I need to consider?

For the copy of the value from the old field to the new field, the only way I know how to do this is through a trick with a database rule. Create a rule based on a temp custom field that will copy values from the old field to the new field. Then use update all to trigger the rule. Does anyone know a better way to do this?
3 REPLIES
Ruth Porter
Honored Contributor
Solution

Re: Move to bigger custom field

Hi Steve,

I think you have it all about right including using a temp DB rule and update all to do the switch.

Good luck!

Regards, Ruth
http://www.teamultra.net
Steve Liddle
Super Collector

Re: Move to bigger custom field

Thanks Ruth, looks like no one else has anything else to add. Much appreciated.
Steve Liddle
Super Collector

Re: Move to bigger custom field

Thread closed
//Add this to "OnDomLoad" event