Strip html from formula text field
The first field on my edit form is "Organization". This field is set as the field for the form title. It is a rich text field. Problem is that the form title displays the name of the organization i...
Forum Discussion
(Note Tested)
Try creating a formula text field to mirror your [Organization] field.
Use the formula
ToText([Organization])
That might work, but i bet it will still get some weird stuff.
Try creating a formula text field to mirror your [Organization] field.
Use the formula
ToText([Organization])
That might work, but i bet it will still get some weird stuff.
Ed, what field type was that formula field? If it was a formula Rich text field can you try a field type of formula text and not formula rich text.
You will then see code like this.
<span style="color:#FFFF00;"><span style="font-size:11px;"><span style="font-family:tahoma,geneva,sans-serif;"><span style="background-color:#FF0000;">hello</span></span></span></span>
Now, if your users have gone crazy with formatting it will be difficult to parse out the actual words. In my case my field said "hello", and I had lots of formatting.
But if the formatting is standard and you post the resulkant HTML code like i did, we may be able to write a formula to parse out the actual words.
You will then see code like this.
<span style="color:#FFFF00;"><span style="font-size:11px;"><span style="font-family:tahoma,geneva,sans-serif;"><span style="background-color:#FF0000;">hello</span></span></span></span>
Now, if your users have gone crazy with formatting it will be difficult to parse out the actual words. In my case my field said "hello", and I had lots of formatting.
But if the formatting is standard and you post the resulkant HTML code like i did, we may be able to write a formula to parse out the actual words.