Formula Query - Data Reliant on Current User
Hi, Below is a Report formula I built to ideally solve the following problem: We have an application where users can submit records to be processed. We want to limit the number of records that can...
Forum Discussion
Curtis,
I have this problem with many issues. The solution I am using is to have a Pipeline fire when the record is created that will related the record to the Employees table. I am comparing the Record Owner with the User in the Employee table and limiting the Search Results to one record.
I am using this against business objects such as Tasks, Forecasts and Opportunity Submissions. The Employee table has a lot of relationships but the follow on business logic becomes much simpler to execute.
The Field Queries are great but they are still very limited.
------------------------------
Don Larson
------------------------------
I have this problem with many issues. The solution I am using is to have a Pipeline fire when the record is created that will related the record to the Employees table. I am comparing the Record Owner with the User in the Employee table and limiting the Search Results to one record.
I am using this against business objects such as Tasks, Forecasts and Opportunity Submissions. The Employee table has a lot of relationships but the follow on business logic becomes much simpler to execute.
The Field Queries are great but they are still very limited.
------------------------------
Don Larson
------------------------------