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.