It could be made to add numbers at the end to prevent duplicates...and you could set a max. length limit...
e.g. UrlSlug([Column1),PreventDuplicatesBoolean,MaxCharacterLength) UrlSlug([Column1],true,120)
Get voting folks! Gotta be a useful function this one.
Regards
Jonathan
ID 2013
Category Setup
Author Jonathan Gee
Date Created 10/3/2023 9:41:00 AM
Date Updated 10/12/2023 11:27:19 AM
Status New Idea
Score 30
Promoted By
Patricio Bustos
cooper collier
Jonathan Gee
Comments
cooper collier 10/3/2023 9:43:37 AM
drats, hit the promote button Have you considered using a regex to accomplish this?
Jonathan Gee 10/11/2023 5:23:47 AM
Hahaha. Drats. Not heard that word in a long long time.
Go on then.. Whats Regex? lol
More I seem to learn on here the less I seem to know.. haha
cooper collier 10/12/2023 11:27:19 AM
Of course Regex may not be the solution you need. I know that I could likely write a formula to do what you wish, but it would be a very complicated one. Regex was designed to make this "simpler, so if you can use it.. great.
Regex is just a way to make complex patterns. There is no way for me to teach regex here and it is not needed. What you do is go to the regex library and find a pattern that work for you already. Maybe tweak it a small amount.
This works in text columns, towards the bottom of a text collum setup there is a Validation check box. Checking that you can add a Validation pattern. It accepts Regex expressions. If you are using multiple columns and combining them into your URL Slug, You can use regex to make sure people enter the correct format in each.
Another way to use it is to replace characters, Here I am a bit... well, a LOT foggy. I have not done this in Teamdesk. Maybe you can use it in a formula maybe not. You can however use it in JavaScript, and you can write JavaScript in resource section in teamdesk. This is the first google result on how to use regex to replace in JavaScript
