Mar 12, 2021 05:07 AM
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
Solved! Go to Solution.
Mar 12, 2021 07:22 AM
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.
Mar 12, 2021 06:49 AM
Just use an ampersand:
SUBSTITUTE({Job Title}," ","-") & " " & {Location Field}
Mar 12, 2021 07:22 AM
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.
Mar 12, 2021 07:34 AM
That’s great, thank you!