Jump to content
  • 0

Search option for missing files



I have a table with a file field and want to allow the user to search for all records where the file field is blank.

This is easy enough for a static report but it would be good if I can allow the user to click or select an option that says missing files. So two options: return all files or just the blank ones.

I thought I could do this with a custom drop down leaving the value blank. You can set it to return all records when left blank or only empty records when left blank but I need it to do both depending on the selection.

Hope that makes some sense to someone?


Thanks for any hints

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hello Brian,

I might not be understanding you, but you can configure the field to achieve that behaviour. When the checkbox is checked, then it will only show records that have the field empty, otherwise the report will show all the records.


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...