Need help with filters
Filters are relatively easy to understand, at least the simple version. But I've run into trouble backing out of a set of filters. I had some filters on one of my table to see a subset, then I wanted to see everything again, and now I don't see any data at all! It's an expense database. I've got start and end dates set to cover the month of Sept (but no other months), and... nothing. I'm positive there were some expense entries in September. Okay, now I took off the filter restricting the data to September entries only. And now I see some zeros instead of empty fields under "total", but other than that, still nothing. What am I missing here? TIA for any suggestions.
Also if you see nothing then sometimes you might have done a filter and changed to another view where the filter condition might not apply. If you type x (any letter will do in th search box) and then cancel it you get the full view back showing your records.
I think Ninox need to give a little more some though to this. They want us the have multiple table views as they claim this is part of it's power. But some consideration needs to be applied in handling/clearing a view filter condition when you switch tabs to a different view. Trouble is sometimes you also want that filter to hold?
I think this is called having your cake and eating it!
Ah-HAH! Fixed it. Wasn't either of the things Nick or Mel mentioned, so I'm posting it here in case someone later has the same problem. In table view, I clicked on the header of the field named "Category 1". That brought up the small window that gives you sort options. The 2nd window down usually (at least so far, with my experiments) has the grayed-out word "filter", and I think you can type in your own filter criteria. Since my recent thrashing around, that field, instead of saying "filter", allowed me to choose between "All", "Empty", or "Not Empty". Thinking that referred to the field itself (I didn't want to put any filter critteria in), I'd set it to "Empty". Experimenting this evening, I found that when I set it to "Not Empty" voila! I saw data again. And when I set it to "All", I saw all my records, even ones where that particular field had nothing in it. I still don't entirely understand Views, but at least my panicked thoughts of "oh no! I've deleted all my data somehow!" have subsided. Thanks for your suggestions, they did encourage me to keep trying. Onward & upward!
P.S. I was going to post a screenshot of the window I mentioned above, but it looked really wonky after I brought it into this text box. Any suggestions should I want to post a screenshot in the future?
Ah yes understand why now both johna dn I took at your word that you had backed out of the filters ie canceling them
That filtering is a standard feature and allows some flexibilty - it you set it to empty and all your data is greater than null for that field you put thr filter on then of course you want see anything. This is feature comes into it's own with combo boxes etc.
It still confirms my point that views are brilliant but you get what you ask for. You set it to show all data that was equal to null!
This filtering is fully covered in the basic user manual.
Now that you are aware of how the view filters work. You can make them work for you.
ie make a view and copy it. add any filters and save it. Copy that one and change filters for other selection criteria etc.
I in my Jobs table
I have fiters veiws for
all jobs (no filter set)
Jobs out on proof