Forum Discussion

SunakshiSethi's avatar
SunakshiSethi
Qrew Member
2 years ago

Do not include formula

Hello, Need help with writing a report formula where the report not include specific supplier IDs. For example never to include ID # 123456 and #654321.  Thanks ---------------------------...
654321.
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

Are you just talking about a filter on a report?



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
SunakshiSethi's avatar
SunakshiSethi
Qrew Member
2 years ago

Hi, 

Yes instead of using  the automated report filters, if I wanted to write a formula instead. 



------------------------------
Sunakshi Sethi
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    You can make a Formula Checkbox field.  if ID is a text field type, then

    [ID#]<> "123456"

     and #654321.

    #654321.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------