Skip to main content
Solved

Create a slug from 2 items

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

Best answer by kuovonne

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.

View original
This topic has been closed for replies.

3 replies

ScottWorld
Forum|alt.badge.img+35

Just use an ampersand:

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

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • Answer
  • March 12, 2021

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!

Terms & ConditionsAccessibility statement