Discussions

Expand all | Collapse all

No Allow Some HTML Option On Text Formula Fields?

  • 1.  No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-18-2017 15:28
    I don't see the "Allow Some HTML" option on text formula fields.




  • 2.  RE: No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-18-2017 15:36
    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 ...


  • 3.  RE: No Allow Some HTML Option On Text Formula Fields?

    Posted 12-18-2017 15:36
    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.


  • 4.  RE: No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-18-2017 15:47
    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.


  • 5.  RE: No Allow Some HTML Option On Text Formula Fields?

     
    Posted 12-18-2017 15:40
    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.


  • 6.  RE: No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-18-2017 15:54
    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. 


  • 7.  RE: No Allow Some HTML Option On Text Formula Fields?

     
    Posted 12-18-2017 16:12
    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.


  • 8.  RE: No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-18-2017 16:50
    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. 


  • 9.  RE: No Allow Some HTML Option On Text Formula Fields?

     
    Posted 12-18-2017 16:53
    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').


  • 10.  RE: No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-18-2017 17:06
    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. 


  • 11.  RE: No Allow Some HTML Option On Text Formula Fields?

    Posted 12-20-2017 18:36
    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.


  • 12.  RE: No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-19-2017 05:43
    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.


  • 13.  RE: No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-19-2017 05:43


  • 14.  RE: No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-19-2017 05:45
    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.


  • 15.  RE: No Allow Some HTML Option On Text Formula Fields?

    Top
    Contributor
    Posted 12-19-2017 15:49
    One Hacker Way Rational alternative of Agile - Erik Meijer



  • 16.  RE: No Allow Some HTML Option On Text Formula Fields?

    Posted 02-05-2018 23:20
    Rational.... o boy.... that's far from rational but very entertaining.