CiviCRM Community Forums (archive)

Hello, I have a Profile that I am using as part of a Membership/Donate form.  I would like to make a couple of fields "textarea" to allow for larger text input and better usability. 

How can I make the profile give certain fields a textarea as opposed to a regular <input type=text ?

Thanks!

Thanks, what if I have a custom field already populated with data that is "Text". 

How can I turn it to a "Note"? 

Currently I do not see a way to do that with the admin interface on 2.0.5.

Stuart

There has got to be a way within MySQL to change a field from Text to Note (or vice versa).  What would I look for in the schema if I wanted to change some things manually with MySQL.   Am I stuck?

@Lobo -- Hi, I am revisited this issue and trying to convert a TEXT field into a NOTE.   I have created the new note field, but you mention doing a "sql copy" of the text data into the note data.  In what table do I want to do this?   I scoured around for a little while but it wasn't clear where the actual data for this custom field lives.  Help?

Thanks this worked well.

For posterity's sake and to help others here is the SQL statement I used to copy the columns within the table:

UPDATE `civicrm_value_1_foo` SET field_new=field_old ORDER BY id

There was no data conversion necessary, as selecting a Note field in CiviCRM 2.0.x seems to correspond to a MySQL column of type 'text' -- not a 'blob' as you thought.