Extrapolate text from rich text formula
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" ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendQ: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
------------------------------
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
------------------------------
Well when you put it like that, it seems obvious! haha!
Thank you so much!!
------------------------------
Renee Hansen
------------------------------