How to use Upper()

Hi all. A very basic question. I have a vehicle database and the registration number format for the UK is typically AB12ABC. This is a key field in my data. On the input form, how do I make sure that this is stored as upper case as shown rather than ab12abc?
Iโ€™ve tried using the upper() function in an app formula on the Registration field i.e. upper(Registration) but this generates an error when saving the app changes -

Key column โ€˜Registrationโ€™ in Schema โ€˜Vehicles_Schemaโ€™ cannot use an app formula. The app formula will be removed.

0 11 1,058
11 REPLIES 11
Top Labels in this Space