Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
I would hate to see it hardcoded like this but to directly answer your question you would make a formula called [Service Group filter]
Case(User(),
ToUser("jdoe@mycompany.com"), "West Corridor",
ToUser("flintstione@mycompany.com"), "East Corridor")
And the faster on your report would be where the [service group] because the [service group filter]
But I think a better way to do this would be to have a table of users who need the report filtered where the key field is the user ID. There would be a field on the table for which service group there is relevant to them.
Then on the table that has the report records there would be a formula field called [current user] with the formula of
User()
And make a relationship based on that field and look up the service group filter from that user table. Then as there are changes in the future you anyone can update the table with additional users or changes to the service filter and not have to edit your formula.
Case(User(),
ToUser("jdoe@mycompany.com"), "West Corridor",
ToUser("flintstione@mycompany.com"), "East Corridor")
And the faster on your report would be where the [service group] because the [service group filter]
But I think a better way to do this would be to have a table of users who need the report filtered where the key field is the user ID. There would be a field on the table for which service group there is relevant to them.
Then on the table that has the report records there would be a formula field called [current user] with the formula of
User()
And make a relationship based on that field and look up the service group filter from that user table. Then as there are changes in the future you anyone can update the table with additional users or changes to the service filter and not have to edit your formula.
DirkRuana
7 years agoQrew Captain
Thanks Dan..... you've insight was useful. I think I need to re-assess.
Thanks,
Dirk
Thanks,
Dirk