Skip to main content
Question

Table Filter - Greater than number or lesser than on Number Fields

  • September 6, 2022
  • 0 replies
  • 120 views
Forum|alt.badge.img+11
I've a simple table which contains  Name (text) , Salary (number)

I can create filters in report settings but can I create filters by clicking filter button to 
Salary more than 40000 (my attempts at >40000 fails)

I believe these are called column filters

------------------------------
Prashant Maheshwari
------------------------------

    MarceloBenavide
    Forum|alt.badge.img+8
    Helloooo... I think ou can use button formula, use the reportUrl and use the QUERY={} param in url

    Marcelo Beanvides Torres


    MarkShnierYou
    Forum|alt.badge.img+24
    np, Create a field called Salary Range to be used as a Dynamic Filter.  Here is an example with Qty ranges.  Play with the words and perhaps some leading spaces to get them to sort correctly.


    var number QtyAvailable = [Maximum Qty Available in East on Specials List in one shade/whse];
    If(
    $QtyAvailable>=1000, "Qty > 1,000",
    $QtyAvailable>= 500, "Qty 500 - 1000",
    $QtyAvailable>=300, "Qty 300 - 500",
    $QtyAvailable>=100, "Qty 100 - 300", "Qty < 100")


    or if its just binary on > 40000, then you can have a formula checkbox to be used as a Dynamic filter.


    [Salary] > 40000

    That will either be true or false, (yes or no)

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement