Discussions

Expand all | Collapse all

Extrapolate text from rich text formula

  • 1.  Extrapolate text from rich text formula

    Posted 04-07-2021 10:10

    Hi,

    I created a "change log" table, anytime certain fields change, it will log the old data and the new data, then I have a formula field set up to tell me if that field "Changed" or "No Change"

    Field is Rich Text:

    If([NEW BM STATUS]=[OLD BM STATUS], "<div style=\"color:white; background-color:green;\"> NO CHANGE</div>", "<div style=\"background-color:pink;\">"& "CHANGED"&"</div>")

    When we download the report for someone to work from - the rich text formula shows up. I need a way to extrapolate just the "changed" or "no change" so people can have an easier time filtering changes.


    this is what the report looks like downloaded to csv:

    <div style="background-color:pink;">CHANGED</div>


    What can I do to get just the "changed" or "no changed"?

    Thanks!

    Renee



    ------------------------------
    Renee Hansen
    ------------------------------


  • 2.  RE: Extrapolate text from rich text formula

    Posted 04-07-2021 10:28
    Q:What can I do to get just the "changed" or "no changed"?
    A: Make a separate field to use when downloading.

    If([NEW BM STATUS]=[OLD BM STATUS], "NO CHANGE", "CHANGED")


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



  • 3.  RE: Extrapolate text from rich text formula

    Posted 04-07-2021 11:43

    Well when you put it like that, it seems obvious! haha!

    Thank you so much!!



    ------------------------------
    Renee Hansen
    ------------------------------