By User on Monday, 11 February 2019
Posted in General Issues
Replies 13
Likes 0
Views 513
Votes 0
Hello. How can I change text box field to text area? I have to edit database?Thanks.

Feature request:
Please make ability in backend to change field type (JomSocial has it):
Textbox <-> Textarea.
Radiobix -> Checkbox / List.
etc.

Also please make: If I delete “FIELD_MOVIE (textbox)” and create “FIELD_MOVIE (textarea)”, data that was filled in textbox before will be displaying in textarea.

Thanks.
Hello. I edited ***_social_fields DB table and changed app_id columb value from 112 (textbox) to 111 (textarea). Seems it works
No need to delete field in backend and recreate (and lost data).
·
Saturday, 29 June 2019 17:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

You can remove the textbox field first then add a field which is textarea into the workflow by inserting a new custom field as shown in the screenshot for an example.

Can you have a try and see how it goes?
·
Monday, 11 February 2019 11:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi. Deleting FIELD_MOVIE (textbox) will not lose field data? So I just need to create new FIELD_MOVIE (texarea)?

The same way if I want to replace radiovutts by checkboxes or droplist? Thanks.
·
Monday, 11 February 2019 12:02
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

Hi. Deleting FIELD_MOVIE (textbox) will not lose field data? So I just need to create new FIELD_MOVIE (texarea)?

The same way if U want to replace radiovutts by checkboxes or droplist? Thanks.


After deleting the data of FIELD_MOVIE (textbox), it won't be shown BUT the data will not be removed in the database. You can check it out the table `#__social_fields_data`. You need to replace the #_ with your table prefix if you want to look for it in your database.
·
Monday, 11 February 2019 13:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello. I just deleted "FIELD_MOVIE (textbox)" and created new "texarea" with the same "FIELD_MOVIE", but profile doesn't display any data. If I edit profile - it's empty

Yes I can see old textbox data in DB, but it has different "field_id" than new texarea (see attached).
·
Wednesday, 06 March 2019 04:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

Hello. I just deleted "FIELD_MOVIE (textbox)" and created new "texarea" with the same "FIELD_MOVIE", but profile doesn't display any data. If I edit profile - it's empty


Do you mean that after you deleted textbox field and created a new textarea field, the user profile's textarea field is empty during editing. It is empty is because there is no data has been inserted.

If I understand your question wrongly, can you explain more about it and show us with some screenshots so that we can have a better understanding of it?

Yes I can see old textbox data in DB, but it has different "field_id" than new texarea (see attached).


Of course it will different, as there are different fields.
·
Wednesday, 06 March 2019 11:08
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello. Question is:
1) I created few weeks ago a "FIELD_MOVIE (textbox)" field.
2) Users filled it.
3) Later I understand that “text box” field type not the best solution.
How can I change it to textarea and not lose data?
4) if I’ll delete “FIELD_MOVIE (textbox)” and create new “FIELD_MOVIE (textarea)”, new field will not display previous entered data to “FIELD_MOVIE

Thanks.
·
Wednesday, 06 March 2019 11:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

Oh I see. Unfortunately It is impossible to do that currently.
·
Wednesday, 06 March 2019 13:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

Thanks for sharing.
·
Monday, 01 July 2019 10:32
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post