Filtered tables and search
Hi Quickbase community:
I posted many times recently because I was on a trial period for my organization. We may eventually go with quickbase, but for the moment are on pause with that process...
Forum Discussion
Mark:
Thanks for that about the 1st question. There's a lot riding on that IsCurrentUser field and would be bad if that broke the whole thing!
Re: the second part. That's exactly it: I set up the role that he was testing to have a Table Home page to show a report that was filtered based on that user's location. So show the customer if IsAtCurrentUsersLocation = 1 then show the Customer -- everyone else was filtered out. BUT from what he said, when he used the search box on that page with the report as set up, he indicated he was seeing Customers from other locations in addition to Customers from the current location. Do you think that was what was happening? Or is that not really possible?
Thanks
Dave
------------------------------
Dave Halter
------------------------------
Thanks for that about the 1st question. There's a lot riding on that IsCurrentUser field and would be bad if that broke the whole thing!
Re: the second part. That's exactly it: I set up the role that he was testing to have a Table Home page to show a report that was filtered based on that user's location. So show the customer if IsAtCurrentUsersLocation = 1 then show the Customer -- everyone else was filtered out. BUT from what he said, when he used the search box on that page with the report as set up, he indicated he was seeing Customers from other locations in addition to Customers from the current location. Do you think that was what was happening? Or is that not really possible?
Thanks
Dave
------------------------------
Dave Halter
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendIts not possible. The box on top of a report is a filter box, not a search box. It only make the results of a report smaller, not larger.
But its easy enough to test. You can click near your name at the top right and so a test as User. You can impersonate any user (for viewing but not actually making edits).
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
But its easy enough to test. You can click near your name at the top right and so a test as User. You can impersonate any user (for viewing but not actually making edits).
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Okay. Thanks much..
I wonder if it was a problem when I put a search box on the app home page. That might have been the problem rather than on the table home page.
In which case I either need to remove the search box from the time page or figure out how to limit that one. Either of those is a possible solution.
Thanks again,
Dave- MarkShnier__YouThe search box on the Dashboard for the app, can be configured as a general search box, or to just search certain fields or to search against a specific report. So you can set the search report same as the table home page.
But you are probably correct that it was the dashboard search box.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
