GerardLibby
5 years agoQrew Member
Force Prefix on User's Data Entry
New QuickBase user, trying to figure out how to replicate something I was used to from MS Access.
I have a text "Purchase Order" field that will store a unique entry as "PO-XXXX" where X is a number. I'd like the user to be able to type "PO-1234" and have that data in the table as "PO-1234" or if they type "1234" then I automatically add the "PO-" prefix and the data again gets stored as "PO-1234."
I can figure out the logic of testing and adding the text, but I can't figure out where this formula should live or how to implement it.
------------------------------
Gerard Libby
------------------------------