function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
cfishercfisher 

If Statement in Custom Report Link

Hello - I am new to doing more complex language in Custom Report Links and needed some help.  I am trying to create a dynamic link that will check the user's Region ("Americas") and then pull in a different report based on that factor.  

 

I keep getting a syntax error.  Do i need to encase the report links in some url brackets?

 

Thanks,

 

Charlie

 

{!IF(
{!ISPICKVAL($User.Region__c,"Americas")},
/00O80000005EMGc?pv0={!Campaign.Id},
/00O800000057qbj?pv0={!Campaign.Id}
)}

Mike @ BlackTabMike @ BlackTab

You may have to encode the url, for example replace " / " with " %2F "
AshlekhAshlekh

Hi

 

Pls try this 

 


{! IF( ISPICKVAL($User.Region__c,"Americas"),  ' /00O80000005EMGc?pv0={!Campaign.Id} ',  

      '/00O800000057qbj?pv0={!Campaign.Id}' ) }

 

 

you can put the link also in  HYPERLINK ( '/00O80000005EMGc?pv0={!Campaign.Id}', friendly_name [, target] )

and use this hyper link ,where you are giving dierect link eg:

 

{ ! IF( ISPICKVAL($User.Region__c,"Americas"),

    HYPERLINK ( '/00O80000005EMGc?pv0={!Campaign.Id}', link name  ),  

    HYPERLINK (  '/00O800000057qbj?pv0={!Campaign.Id}' ,link name)  

}

 

 

If this is your solution than mark it as a solution and dont forget to give me kudo's 

 

Thanks 

Ashlekh Gera