Skip to main content

Hi,


I am using a formula to create a slug: SUBSTITUTE({Job Title}," “,”-")

However, is it possible to add another item in the formula, such as {location}?


Many Thanks,

Hannah

Just use an ampersand:


SUBSTITUTE({Job Title}," ","-") & " " & {Location Field}

Just use an ampersand:


SUBSTITUTE({Job Title}," ","-") & " " & {Location Field}


If you want the location as part of the slug, you need to include it inside the SUBSTITUTE


SUBSTITUTE(

  {Job Title} & "-" & {Location Field},

  " ",

  "-"

)

You may also need multiple nested SUBSTITUTE functions to replace other characters that are not allowed in slugs.

If you want the location as part of the slug, you need to include it inside the SUBSTITUTE


SUBSTITUTE(

  {Job Title} & "-" & {Location Field},

  " ",

  "-"

)

You may also need multiple nested SUBSTITUTE functions to replace other characters that are not allowed in slugs.


That’s great, thank you!

Reply


Terms & Conditions