## Documentation Index Access the complete documentation index at: https://www.zoho.com/us/books/kb/llms.txt Use this file to discover all available documentation pages before proceeding. [Back](./) # How do I view records that have an empty value in specific fields? ![](/books/images/ue-resources/llm-utility-menu/sparkle-ai.svg) Explore With AI ![](/books/images/ue-resources/llm-utility-menu/dd-arrow.svg) * [Open in ChatGPT (opens in new tab)](https://chatgpt.com/?prompt=Analyze+the+content+of+https%3A%2F%2Fwww.zoho.com%2Fus%2Fbooks%2Fkb%2Fgeneral%2Ffilter-empty-records.html+and+understand+it+thoroughly+so+I+can+ask+questions+about+it.) * [Open in Claude (opens in new tab)](https://claude.ai/new?q=Analyze+the+content+of+https%3A%2F%2Fwww.zoho.com%2Fus%2Fbooks%2Fkb%2Fgeneral%2Ffilter-empty-records.html+and+understand+it+thoroughly+so+I+can+ask+questions+about+it.) * ![Copy for LLM](/books/images/ue-resources/llm-utility-menu/copy.svg) Copy for LLM * [![View as Markdown](/books/images/ue-resources/llm-utility-menu/md.svg) View as Markdown (opens in new tab)](/us/books/kb/general/filter-empty-records.md) You can use a custom view to filter records that have an empty value in a specific field. Let’s understand this better with the help of a scenario. **Scenario:** Patricia, a purchasing manager, manages material orders for production at her manufacturing company. Upon receiving a raw material request from production, she creates a purchase order in Zoho Books, which she sends to the vendor. The vendor fulfills the order and returns an invoice, occasionally without the order number, which Patricia records as a bill. To identify such bills, Patrcia creates a custom view with the condition “Order Number is empty” in the Bills module. She then adds the Order Number to those invoices. To create a custom view to filter records that have an empty value: * Go to the module for which you want to create a custom view. * Click the _All Bills_ dropdown (the dropdown name will change based on the module) at the top of the page and select **\+ New Custom View**. ![Click + New Custom View from the dropdown](/books/kb/images/general/new-custom-view.png) * Enter the name of the custom view in the **Name** field. * Enter the criteria in the _Define the Criteria_ section (**Order Number is empty** in this case). * Click **Save**. ![Enter the criteria for the custom view](/books/kb/images/general/custom-view-criteria.png) A custom view will be created which displays records with empty values (in this case, bills not having an order number). * * *