Reformatting text via a formula

R

Hello. Just starting with Ninox. Imported some data from a Filemaker file into 3 fields: LastName, FirstName and PhoneNumber. The formatting was inconsistent in the Name fields. I am trying to reformat the all upper case entries to a normal formatting ( Just the first letter capitalized) I have placed the formula : lower(substring(FirstName, 1, 16)) into the trigger on update field within the FirstName field options, but it does not seem to work. It works fine in a separate formula field so I am stumped (easy to do). Couls someone point out the error of my thinking? Thanks much

Ninox Profile

Robert,

Use capitalize(Firstname) instead.

Steven.

R

Thank you very much, Steven. Still no joy, however. I entered the field and tabbed out - no change. then I entered the field, changed the name using all caps, tabbed out and still no change. Perhaps I am not understanding what "on update" means? This is on the desktop version of Ninox if that matters.

Ninox Profile

Strange, i've tested it in the ipad and the web version, both are working.

Do you use the trigger after update of the field itself? 
C0F7E46E-D8D7-47A0-A47C-9C3D20D8BCDF
Steven

R

Thank you so much, Steven. Your inclusion of the screenshot clarified it for me. I did place it in the field "trigger after update" but in a briliant display of noobiness, had not included the assign part of the code (using just capitalize (FirstName)) Although no error was displayed in the formula editor. Thank you again, Steven. For now all is good in noobiville.:^)

Reply