Help

Re: Change character in URL string with Formula

588 0
cancel
Showing results for 
Search instead for 
Did you mean: 
maad
4 - Data Explorer
4 - Data Explorer

Hello,

Hope someone can help me here. I would like to change one character in the URL when 360 Edition is selected which corresponds to the selected Record. 

I imagine it would be something like if Record I is selected the URL is "360-Edition-Record-I.pdf" if Record II is selected "360-Edition-Record-II.pdf" etc.

How can I achieve this? 

 

 

 

IF(
  {Edition} = "360 Edition",
  "https://www.dropbox.com/.../360-Edition-Record-I.pdf?...dl=1,
  "https://....." <- URL for when 360 Edition is not selected
)

 

 

 

 

1 Reply 1

Try this

IF(
     {Edition} = “360 Edition”,
          “https://360-Edition-Record-” & ENCODE_URL_COMPONENT({Record data}) & “.pdf?…dl=1”,
          “https://…..”
)