Data Type: HTML? Does this work?

[jjwdesign]

Data Type: Text/HTML? Do these work as intended with the Module Builder and/or Studio?

I'm having a problem choosing the right data type, if it exists. I'm a bit confused as to the HTML data type. See image attached to this post.

I have a field of data that should be HTML. For the detailed view, it needs to be viewed in by the browser as HTML; not HTML escaped/encoded in any way. I don't need to see the code. I need to see the resulting display of the HTML as the browser interprets it. This would be very similar to the Email Message Body view. In the studio (see image attached) it teases me into thinking that the HTML Editor (tinymce) will be available to edit the content of the field, but it only allows for a default value.

For the edit view, I am trying to figure out of there is a way to use the Editor (tinymce) to edit the HTML for the field. For an HTML field, it makes sense to me that you would be using the tinymce editor (or FCKeditor, etc.) to edit the HTML. Does this kind of field exist?

Thanks.

[jjwdesign]

From the MVC wiki document.

Html: The Html field is a simple field that renders readonly content after the contet is run through the from_html method of include/utils/db_utils.php to encode entity references to their HTML characters (i.e. ">" => ">"). The rendering of the Html field type should be handle by the custom field logic within SugarCRM.

Why is this field read only? Wouldn't we want to allow people to edit this field type using an editor (tinymce)? What custom field logic can be applied and where?

Thanks in advance.

[ptemplin7]

One of the thigns that you will find is that Sugar does not yet fully support or validate some of the data types it gives you.

Another one is the phonenumber data type. The Javascript is there to validate it but Sugar never calls it! Much of the support is still in the process of being added. You have likely found one of them!

Hopefully one of the Sugar Team members will pop in and clarify further,
Paris

[jjwdesign]

What about displaying the field as HTML and not HTML-escaped text?

Does anyone know how to change the logic for this field type?

[dogfuel]

I too am stumped on this one ... trying to insert html with an ETL tool and having no luck even finding where it is stored.

[jjwdesign]

Maybe a SugarCRM guru can shed some light on this topic?

[jjwdesign]

I just found this great pair of videos. Thank you Majed Itani, this helped me greatly!

A few weeks back we did a live webcast with SugarCRM lead architect Majed Itani on building a complex new module in Sugar 5.0. In the session, Majed stepped through building the basic shell of a blogs module with Module Builder and then customizing the code to make it a true blogs module.

We have posted the session into two separate recordings in the Sugar Developers Zone.

Direct links to the recordings:
Bending Sugar with Majed Itani - Part 1 & Part 2

If you are a Sugar developer, these sessions are well worth watching!

[ashishmathur]

You can edit the value of html type field directly in database table "fields_meta_data".