Uppercase field input

dwr

New member
Hi. I'm a new user but up and running. I have a requirement to force uppercase input on certain fields (e.g. Customer Code, Post Code, etc). I'm surprised there is no tick box available against a field to force uppercase. How can I convert key strokes to uppercase?

Cheers
Dave

DaDaBIK version 7.2 PRO
PHP Version: 5.6.21
mysql version: 5.5.5-10.1.13-MariaDB
Web server: Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.21
Client: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0
 

eugenio

Administrator
Staff member
Hello Dave,
at the moment there is no built-in function to force uppercase.

You can, however, check if the input is uppercase using a custom validation function.

You can also force a conversion to uppercase before the actual insertion working on the insert_record() function in /include/business_logic.php (you have to hack the code, though). Another option is probably the use of a MySQL trigger to launch before insertion.

Best,
 

dwr

New member
Thank you for the swift response.

I'll investigate and try the options you've suggested. Shame though as it's a relatively easy option to add. I use it in manually coded PHP solutions.
 
Top