Forum Discussion
Custom WEB URL
I have a current measure which has been working well and directs me to a customer URL based on case number raised. e.g.
URL = "https://salesforce.com/" & '!My_Report'[Case Number] - https://salesforce.com.com/Case/XXXXXXXXX
Now I noticed the backend URL has changed to https://salesforce.com.com/r/Case/XXXXXXXXX/view
How can I amend /view onto the end of the URL after the Case Number has been injected?
You can just add & "/view" on the end.
URL = "https://salesforce.com/" & '!My_Report'[Case Number] & "/view"
Regards,
Pat
5 Replies
You can use the concatinate function; https://docs.microsoft.com/en-us/dax/concatenate-function-dax
thanks but isnt that just contatinating columns, /view isn't in a column
You can just add & "/view" on the end.
URL = "https://salesforce.com/" & '!My_Report'[Case Number] & "/view"
Regards,
Pat
thanks Pat, knew it was simple!
Hi pat,
can you please help us to resolve below requirment.
Ex: we want to create URL only for Dev,Prod,QA (we followed above Measure which you have shared it is working fine but we are getting URL for Sandbox as well but we don't want that)
We are getting like below but we want to create URL only for Devlopment,Quality,Production because we don't have any URL for Sandbox
Type WorkON ID URL
Sandbox Sandbox https://myworld.com/Sandbox
Devopment Cloud-19 https://myworld.com/Cloud-19
Production Cloud-21 https://myworld.com/Cloud-21
Quality Cloud-2 https://myworld.com/Cloud-2
Sandox Sandbox https://myworld.com/Sandbox
Quality Cloud-1 https://myworld.com/Cloud-1
Devlopment Cloud-420 https://myworld.com/Cloud-420
