Anyone has ever used a database table with words and abv of those word to shorten text inputted?
Are you wanting like an autofill where you put in ST and it fills in with STREET?
I wanted to shorten an existing field and populate another field with the shorten version using abbreviations from a database table. e.g Databse table has two values white=wht and street= st, Field A = We like white street Field B= We like wht st AJAX on change event would be the best way to handle such.
I haven’t tried it, but I imagine you could do an ajax on click or on change and sc_lookup(rs,“select shortname from table where longname={field}”); Then $newfield={rs[0][0]} and {field}=$newfield.