You need to sign in to do that
Don't have an account?
Kurt A Brimberry
Dynamically generate pvX values based with custom URL logic
I created a report from Campaign members that will act as a call down report for the Sales team. I then created a custom link that passes the Campaign ID and up to 3 Campaign Member Statuses. This is the framework for the report:
pv0 = Campaign.ID
pv1 = Campaing Member Status 1
pv2 = Campaing Member Status 2
pv3 = Campaing Member Status 3
The report has filter logic of 1 AND (2 OR 3 OR 4).
When building the URL the campaign ID is always {!Campaign.ID}. However, based on the value of a custom pick-list field on the campaign I need to dynamically pass values to pv1 through pv3. The following is my formula which returns a syntax error.
/00O0j000000O5jt?pv0={!Campaign.Id}
{!IF( ISPICKVAL( Campaign.Targeted_Audience__c , "Distributor") ,
pv1="Planned Invitation"&pv2="Invited",&pv3="Committed"
pv1="Planned Outreach"&pv2="In Process")}
Thanks in advance for any help the community can provide!
pv0 = Campaign.ID
pv1 = Campaing Member Status 1
pv2 = Campaing Member Status 2
pv3 = Campaing Member Status 3
The report has filter logic of 1 AND (2 OR 3 OR 4).
When building the URL the campaign ID is always {!Campaign.ID}. However, based on the value of a custom pick-list field on the campaign I need to dynamically pass values to pv1 through pv3. The following is my formula which returns a syntax error.
/00O0j000000O5jt?pv0={!Campaign.Id}
{!IF( ISPICKVAL( Campaign.Targeted_Audience__c , "Distributor") ,
pv1="Planned Invitation"&pv2="Invited",&pv3="Committed"
pv1="Planned Outreach"&pv2="In Process")}
Thanks in advance for any help the community can provide!