Remove Records with Attachment From Report

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hello QB Community,

I have a report that I need to add another filter to, which removes any records that has a file attachment present.  I was looking through my options and playing around with different selections in the report, however, I have been unsuccessful so far.  It doesn't act like a checkbox where I could say "is not equal to - checked", so I am curious if I need to create another field that converts the attachment into an IF statement, if that's even possible.  I've messed around with the different drop down selections, which I've attached a screenshot of, but the filename attachments can pretty much contain any letter or number plus dashes.  The options I've tried either remove everything from the report or nothing at all.

Any expertise would be greatly appreciated - thank you!

Photo of bintu85

bintu85

  • 90 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Try

Where filename is not equal to .... (blank) .. just leave that text box empty.