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

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.

That’s great, thank you!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.