change lead field data type

[dpt123]

Hi
I created a lead field data field type as a text field, but realise it should be an integer.
Its a number, a square meterage, and the problem occurs because users enter 123m instead of 123 and then I cannot do calculations on exported data because of the "m".

Now that this has happened I need to either change the field type (and hopefully stop people entering an "m") or create a new field and have the old data transferred across.

Any ideas?

[salesagility]

Create a new field and transfer the data across.

[dpt123]

Hi,
I am concerned at losing data when I just "transfer it across" can you point me to a tutorial that lets me change a data type, or attributes of a field.

For instance, I cannot click in the box that will make phone number a required field?

Do I clone this field? will data come across automatically?

Should I attempt to find the field in the database and change it there using PHPMYADMIN for instance.

[andopes]

I am concerned at losing data when I just "transfer it across" can you point me to a tutorial that lets me change a data type, or attributes of a field.

For instance, I cannot click in the box that will make phone number a required field?
Once this is a custom field you should be able to configure this one as a required field!
Anyway, you can add the attribute:

 'displayParams' => array(
  'required' => true,
), 
  

Into field definition at editviewdefs.php

Do I clone this field? will data come across automatically?
No.

Should I attempt to find the field in the database and change it there using PHPMYADMIN for instance.
This is an option. You have to do the following:
Update the table fields_meta_data to modify the field type of the given field;
Alter the table <module_table>_cstm to modify the field type accordingly;
Go to Admin -> Quick Repair and Rebuild.

Obviously make a backup before.

Cheers