How to convert all UPPERCASE every field I fill?
I need a database where all is in UPPERCASE.
Enter layout mode, select your field and select Format / Style / Uppercase from the top menu.
You can also modify you theme, which will apply this change to multiple fields.
If you want to change the stored data, you can change it in Field Options:
Go to File/Manage Database / Fields, select your field to open field options. In Auto-Enter tab tick "Calculated Value" and enter
Upper ( self )
as calculation. Uncheck "Do not replace existing value of field".
Thanks but.. how to use in a field?
example. I insert : "First Name" and I wont that is stored as "FIRST NAME" immediately.
You have a few different options here:
1. To replace existing fields that are not uppercase, you would need to select the field on your layout click Records > Replace Field Contents (Ctrl + =) > Replace with calculated result > Then use the Upper(Table::FieldName) as your calculation. This will replace the field you've selected with the Uppercase version of what ever was in the field before.
2. Going forward, a possible solution might be to just display the calculation fields that use the Upper(FieldName) on your layout.
3. If calculations aren't your thing - you can create a Script Trigger which runs OnObjectExit and it would look something like this:
Set Field [Table::FieldName; Upper(Table::FieldName)
Thanks !!!!! (Grazie mille!)
I just wanted to add to nicolai's excellent answer(s) - because there is DATA and there is DISPLAY that can be changed.
If you choose to just DISPLAY by formatting (and many people do!), and if you need to EXPORT that data (as formatted), only date, time, timestamp and numbers are exported as formatted when you select this in the dialog:
Exporting data from FileMaker Pro | FileMaker
So, keep that in mind. Perhaps you need to think about more than just display formatting?
Your question has been answered technically, but I am curious why you would want to do this. It violates typography rules and general user interface rules. I know some people used to do this if the material was being printed and used a mono-spaced type to help out old OCR scanners, but that is not a problem anymore. You can never say never, but in general, it is poor user interface design to stick to all upper case unless there is a specific need for it. I often use the UPPER function on a field by field case for say a serial number that anticipates only upper case letters and numbers. But I've never done the entire database with UPPER.
Taylor! you know that we can beg clients to do as we suggest, but that does not always happen.
Better to have the "correct way" and the "client's way" both handy if later they change their minds (and they DO).
You're are right!!!! isn't UPPERCASE in stored file.... whit Format / Style / Uppercase only display is uppercase... but stored data are exactly how typed.
Why? I need this format for stored data. How to???
Excuse my bad english... I'm italian.
My client needs this formatting (all UPPERCASE) and I don't care
My client need to share this data with TN3270 software or similar things.
You are right....
This is the solution!!!!!
If you are setting the field to replace any text with the UPPER function, you might also want to have it do a TextForMatRemove too. That way if someone pastes in text that is formatted (e.g., fonts, colors, etc.), it will change to plain text. So you would do something like this:
UPPER ( TextFormatRemove ( Self ) )
Of course that assumes removing text formatting is what you want. But I find a lot of issues with people pasting from web pages or emails and that results in formatted text in fields that you often don't want it formatted as pasted.
Yes.. thanks!!!! This is very helpful for me.
Retrieving data ...