Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Create a slug from 2 items

Topic Labels: Formulas
Solved
Jump to Solution
1014 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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.

See Solution in Thread

3 Replies 3

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!