Print a list if a specific field is not blank

[phil downs]

I used bento to create shopping lists. I had a database of items and stores and isles. I would find items and I had a field where i would enter how many I wanted. Then I would print a shopping list of only the ones that were not blank in that field. Is this possible with tap forms? I have the latest version 5 on my Mac.

[Brendan]

Hi Phil,

Yes this is.

To do that, click on the filter button next to the Search field when you have your form selected. Select the field you want to find out if it’s empty or not. Then choose the “is empty” comparison operator. Click the Save button when you’re done. Now you’ll have a Saved Search appear just below your form that when clicked on will always filter your records to show only those that have that field empty.

Thanks!

Brendan

[Author]

Posts