So I have a field name [Company]; each time I am inputting the company's name such as nissan, toyota, chevrolet, lexus, and so forth I want to make the first letter Capitalize "automatically" =Nissan, Ford, Chevrolet and so forth. By the way table name is "Car".
How would I do that? do I need to create a script? do I need to use the "Calculation"?
I pressed the Help in FileMaker Pro 18 - it shows to use of function ==> Proper (text). However it doesn't work.
So far these are what I have tried so far....
1. Proper(:car::company") - no luck - try to input a new entry still the company's name is all in lowercase format.
2. Proper(car::company) - without the double quotes - no luck.
Please advise and provide and an example.
