Change character in URL string with Formula

maad · ‎Sep 08, 2023

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 · ‎Sep 09, 2023

Try this

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