Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
3 years ago

"Ends with" Filter Solution

Hello Community, How would you find a text field where all records end with a dash?  "-" Most fields do not end with a dash. I notice Quickbase does not offer the "ends with" as a filter, ther...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

np :)

I assume that you were talking about a report filter?
Just make a helper field called [Ends with Dash?]

Ends([My field[], "-") 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • JimHarrison's avatar
    JimHarrison
    Qrew Champion
    3 years ago

    Thanks!!



    ------------------------------
    Jim Harrison
    transparency = knowledge + understanding : The Scrum Dudes
    ------------------------------