You need to sign in to do that
Don't have an account?
Inanskar007
How to get a picklist value of user object in To do and Visits report
Hi
My requirement is to create a report using the report type as TODos and visits (which refers to acitivies)
with fields in the report as Assigned to (refers to user ) subject, Opportunies, Visit status, etc., based on the filter condition One P&C (custom picklist field) equals as Asia Pac
This custome picklist field is present in User object having the picklist values as Asia Pac, Europe, North America and South America.)
I have 20 users with One P&C field as Asia Pac. In order to get those user details with One P&C field as Asia Pac, I have created a custom field in Actiivites object with field type as formula which use merge field formula to get the One P&C value of user object.
Eventhough i created that formual field, One P&C is not getting any values.
Please look over it and suggest a way to filter the Activities records in report based on the custom picklist field (One P&C in user object).
My requirement is to create a report using the report type as TODos and visits (which refers to acitivies)
with fields in the report as Assigned to (refers to user ) subject, Opportunies, Visit status, etc., based on the filter condition One P&C (custom picklist field) equals as Asia Pac
This custome picklist field is present in User object having the picklist values as Asia Pac, Europe, North America and South America.)
I have 20 users with One P&C field as Asia Pac. In order to get those user details with One P&C field as Asia Pac, I have created a custom field in Actiivites object with field type as formula which use merge field formula to get the One P&C value of user object.
Eventhough i created that formual field, One P&C is not getting any values.
Please look over it and suggest a way to filter the Activities records in report based on the custom picklist field (One P&C in user object).
doravmon
Here is the solution: https://developer.salesforce.com/forums/?id=906F00000008kxbIAA