Forum Discussion

NingLi's avatar
NingLi
Qrew Trainee
5 years ago

How to set a text field that doesn't allow starting/ending with a extra space?

Hi there,  How can I set a text field that doesn't allow starting/ending with a extra space?   When copy and paste, or even manually type in, this text field may contain extra space in the start...
Formulas and functions
UrsulaLlaveria's avatar
UrsulaLlaveria
Qrew Assistant Captain
To my knowledge, there is no way to do this naturally. You can have a formula field that trims all extra leading/ending spaces from the textbox, and use that field instead. 
Trim([Original Text field])
A link to this function's features: https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=61&rl=pmy

------------------------------
Ursula
------------------------------
NingLi's avatar
NingLi
Qrew Trainee
5 years ago
Hi Ursula, 

Thank you very much! 

I will talk with other users about changing existing records (will change the last modify date) and see how would they like this. 

Many thanks, 

Ning

------------------------------
Ning W
------------------------------