Substitute characters in a string with another set...

[maad]

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
)

[pressGO_design]

Try this

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