question How to change the Number field back to string? in ITOM forum

How to change the Number field back to string?

bgn — Wed, 12 Mar 2014 09:08:44 GMT

I mistaskenly manually changed the Number field type from String to Reference while OOB configuration is set to String .

I did it in a table which extends the Task one.

Does anyone know how i can fix it?

Thanks

Re: How to change the Number field back to string?

nR9 — Wed, 12 Mar 2014 13:01:41 GMT

Yes,

You can change that.

There are 2 ways.

Go to System Defination >> Dictionary, locate the field and make changes
Open the form, right click on the field and make the necessary changes

A thing I want to add here is, if you have created any record with the previous datatype, all the data will be deleted when changing the datatype.

hope this helps.

Re: How to change the Number field back to string?

bgn — Wed, 12 Mar 2014 13:53:31 GMT

Thank you for your answer.

Option #1 : after updating the Task table it's written : "Type unchanged for field "Number". Cannot convert from Reference to String." And I don't understand why. The Task table is the only one where the type is Reference instead of String or Integer.

Option #2 : it doesn't work either

Re: How to change the Number field back to string?

venkatesh_chakk — Wed, 12 Mar 2014 15:04:29 GMT

Hi,

When you are trying to change the field Type it will give the following error "Your changes will remove all field data from Beer or Wine in table Food Service. Continue?". Once you update the Field Properties the data in that particular field will be lost. If you are OK for that you can modify the field property.

Following are the Steps to update the Field Property

1. Open the form

2. Right Click on the field

3. Select the Option Personalize Dictonary

4. Select the required Type (String, Date, Image, Decimal etc.) as per your requirement

But Keep in mind that you will be getting the following warning ""Your changes will remove all field data from Beer or Wine in table Food Service. Continue?". and all the data pertaining to that field will be lost.

Thanks,

Venkatesh Chakka

Re: How to change the Number field back to string?

daveness — Mon, 14 Apr 2014 17:03:23 GMT

I have the same issue, and I'm getting the same results as bgn, "Type unchanged for field "Number". Cannot convert from Reference to String." I've used both methods, modifying the Type from the System Definition >> Dictionary, and from the form itself, same results.

I've tried this with elevated privileges to no avail. Am I missing something?

Re: How to change the Number field back to string?

bgn — Tue, 15 Apr 2014 07:56:58 GMT

Hi,

Try to disable the "Validate type change" of the Business Rule and it may allow you to set the value back to string.

Regards

Re: How to change the Number field back to string?

daveness — Thu, 24 Apr 2014 13:50:05 GMT

This did the trick, thank you so much!!

Re: How to change the Number field back to string?

Gowthami Senthi — Thu, 04 Aug 2016 11:46:09 GMT

Hi Lucilla,

I am not able to find the "Validate type change" business rule in my instance. Is this the custom BR or OOB?

Do I need to enable any plugin for this?

Re: How to change the Number field back to string?

kushwahapooja — Tue, 20 Jun 2017 13:27:28 GMT

i also didnt find this business rule.

please help me

Re: How to change the Number field back to string?

kushwahapooja — Wed, 21 Jun 2017 06:35:16 GMT

please explain me how can i do that