Skip to main content
Question

"Ends with" Filter Solution

  • May 15, 2023
  • 0 replies
  • 21 views
JimHarrison
Forum|alt.badge.img+16

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, there is a "begins with" filter. Any ideas? 

Thanks,



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

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • May 15, 2023

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement