Forum Discussion

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

Qrew Legend

Are you just talking about a filter on a report?

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

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
Qrew 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
------------------------------