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 nu...
Forum Discussion
Thanks! So if I'm understanding this correctly, my table will have a field that's mostly junk data (values both with and without the PO prefix) as well as the "good field" that's been manipulated by the formula? Also, would I have to put another formula on the data entry box on the field so that it is apparent to users that the data has been auto switched to adding "PO"?
MarkShnier__You
Qrew Legend
Qrew LegendThe data entry box would only show in Add and Edit mode on the form. It will never be used on a y reports. I would name that field like [PO# Data Entry]. Then I would show the would show the [PO#] (ie the formula field) in View mode. You can decide if you also want it to show in Add Edit mode.
So there will just be two fields, one for data entry and one for display purposes.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
