Discussions

Expand all | Collapse all

Formula Rich Text

  • 1.  Formula Rich Text

    Posted 01-12-2020 17:25
    Having an issue with the mobile app on Android. URLs give an error of try again. I want to try a formula rich text field to point to a URL field in the record the button is located. 

    I found this in the Magic Buttons App

    "<a class=\"Vibrant Success\" href=\"http://quickbase.com/webinars/\">16B. Go to some URL</a>"

    Trying to point this to the field in the record that contains the URL I need to visit when pressed.

    ------------------------------
    ProjectsForce
    ------------------------------


  • 2.  RE: Formula Rich Text

    Posted 01-12-2020 20:31
    Try this

    var text URL = [my url field];
    var text Words = "Words to click";

    <a class='Vibrant Success'" & " a href=" & $URL & ">" & $Words & "</a>"


    // in place of the word Success

    also try

    Danger (which gives red)
    Snowy (which gives white)
    Alert ( which gives yellow)
    Primary and Success both give blue

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Formula Rich Text

    Posted 01-21-2020 12:04
    What if you needed it to open in a new tab? I know to use Target="_blank", but not sure where to put it.

    ------------------------------
    ProjectsForce
    ------------------------------



  • 4.  RE: Formula Rich Text

    Posted 01-21-2020 12:54
    not tested, but try this

    <a 'target=_blank' class='Vibrant Success'" & " a href=" & $URL & ">" & $Words & "</a>"

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Formula Rich Text

    Posted 01-21-2020 13:38
    It gives an error at the _ part right before the word blank

    var text URL = [Link To Project];
    var text Words = "Words to click";

    <a 'target=_blank' class='Vibrant Success'" & " a href=" & $URL & ">" & $Words & "</a>"
    //"<a class='Vibrant Success'" & " a href=" & $URL & ">" & $Words & "</a>"

    ------------------------------
    ProjectsForce
    ------------------------------



  • 6.  RE: Formula Rich Text

    Posted 01-21-2020 13:46
    try this - there was a missing opening " before the <a target= ....

    var text URL = [Link To Project];
    var text Words = "Words to click";

    "<a 'target=_blank' class='Vibrant Success'" & " a href=" & $URL & ">" & $Words & "</a>"


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Formula Rich Text

    Posted 01-21-2020 14:00
    The button works, but it does not open in a new tab, still opens in same window.

    ------------------------------
    ProjectsForce
    ------------------------------



  • 8.  RE: Formula Rich Text

    Posted 01-21-2020 14:05
    OK, this one is tested :)

    var text URL = "https://google.com";
    var text Words = "Google";

    "<a class='Vibrant Success'" & " a href=" & $URL & " target=_blank" & ">" & $Words & "</a>"

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 9.  RE: Formula Rich Text

    Posted 01-21-2020 14:32
    This works perfectly!!! Thank you sir!

    ------------------------------
    ProjectsForce
    ------------------------------