No Allow Some HTML Option On Text Formula Fields?

  • 40
  • 1
  • Question
  • Updated 10 months ago
  • Answered
  • (Edited)
I don't see the "Allow Some HTML" option on text formula fields.


Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 28,144 Points 20k badge 2x thumb

Posted 12 months ago

  • 40
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 28,144 Points 20k badge 2x thumb
Apparently you have to use Formula Rich Text field now. I wonder of this change breaks existing text fields which had the Allow Some HTML option set ...
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
So over the weekend they introduced a new field type called Rich Text and formula Rich Text.  All the field which used to be formula text fields, but with HTML enabled check boxes are now Formula Rich text fields and that concept of a checkbox no longer exists.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 28,144 Points 20k badge 2x thumb
I figured that was it.

BTW, in creating a Rich Text Formula field QuickBase should have allowed the insertion of fields that would be interpolated. So you could write a Rich Text Formula like this:

"<h1>[Title]</h1>"

instead of:

"<h1>" & [Title] & "</h1>"

This would have been extremely helpful.

There ain't enough creative juice flowing.

When I get a chance I will have to create a RTF will all HTML elements to see which ones are allowed.
Photo of David

David

  • 680 Points 500 badge 2x thumb
Very cool to finally get this field type ... until I found it broke my form rules to copy text into the new rich text fields. I assume QB will call this a bug.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,266 Points 5k badge 2x thumb
Mark would be correct with the release this weekend all existing Formula - Text fields did get converted over to the Rich Text field type and going forward Rich Text would be the option you would want for any Formula - Text fields that would have had HTML enabled.

In your instance David did it break a form rule to copy text into a rich text field or was it a form rule copying text out of a rich text field? If this behavior is persisting we would certainly love to know about it so that we can look into it, since this was a significant change we are trying to find any issues or bugs that may have come up with the field type being opened up. 
Photo of David

David

  • 680 Points 500 badge 2x thumb
Evan--

It is copying from a rich text formula from a linked table.

I have a table with a RT-formula field that I use as a template, then in the linked table, the form rule copies that linked field info into a RT-text field for the user to further edit. So maybe it is that it is from another table, but I doubt it. In the past, when I've used js to create an rich text editing tool, I had similar problems.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,266 Points 5k badge 2x thumb
Hi David,

So you were using a form rule to grab a related rich text fields value and then push that linked field into another formula field? Were you doing this via some embedded scripting? Typically a formula fields return isn't open for editing by a user on the form, so I ask just to get clarification. 
Photo of David

David

  • 680 Points 500 badge 2x thumb
No, I am pushing a rich-field-formula-from-a-linked-table into a rich-text-field (used to be a text field 'with some html').
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,266 Points 5k badge 2x thumb
Thank you David, that definitely clarifies the situation you are running into. I am going to bubble that feedback up to our Product Team that worked on the Rich-Text fields. I would also suggest if you want to get a specific issue spun up and tied to you so that you get a progress update to open a support case. I know we definitely want to track any use cases where the Rich Text update caused issues with existing applications. 
Photo of Tony

Tony

  • 110 Points 100 badge 2x thumb
Evan, I also had this issue.  Not only did QB change the Text Formula fields to Rich Text, they also changed the Text (Multi-Line) fields I had to Rich Text.  This broke my Form Rules as well.  Mine were a simple, "If this checkbox field is checked, put this text into the field".  They were not trying to push data from Rich Text somewhere else.  I have reported to Support, who has no clue this is happening.  Can't believe more users aren't noticing this yet.
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
I'm coming out a month plus hiatus from the community...

Try to set up the IOL with a formula text box, without the html.
During the beta of this I brought up that it causes errors and will break many apps that use this and other variable onload techniques. 

They said they would address that prior to release.  

Doesn't look like they did.

Say you want to make a new button formula text that appears on all records...  YOU CAN"T.

Every release I'm more and more confident that the developers don't test or use quick base.
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
I'm curious how they are handling all of the legacy fields.  

Looks like the field properties are still there in the schema, they just hide the UI.
hmmm.
(Edited)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,694 Points 20k badge 2x thumb
One Hacker Way Rational alternative of Agile - Erik Meijer

Photo of Joshua Tate

Joshua Tate

  • 1,016 Points 1k badge 2x thumb
Rational.... o boy.... that's far from rational but very entertaining.