Forum Discussion

JasonPhenicie's avatar
JasonPhenicie
Qrew Trainee
9 years ago

Remove disallowed characters from a text field

Our app has a [Project Name] field in which our users can input whatever project name they like. We then have a [Project ID] field that uses 9 Part([Project Name],1," ") formulas to combine the first ...
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
9 years ago
Use IOL:

Remove Disallowed Characters
https://haversineconsulting.quickbase.com/db/bmj2gmzcs?a=nwr

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=556

It is best to prevent the disallowed characters from entering your application during keyboarding rather than after the fact using formulas.

If you or your dog need additional assistance implementing this solution feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt