Convert entered text to uppercase

Hello friends,
I would like to convert the entered text to uppercase, I have tried some forms without exception, please support

Welcome to the AppSheet community!

I do not think there is a way to silently force to uppercase at the point of entry in that single field.

There are some options however.

  1. You could insert a Valid_If condition that checks if what was entered was uppercase and when not invalidate the entry with a message that uppercase is required.

  2. You could add a second column that has an App Formula that forces uppercase using UPPER() function.

  3. You could add an Action on Form Save that takes any columns you wish to be uppercase and applies the UPPER() function to them.

  4. Similar to 3) you could use a Workflow that forces entered values into uppercase. This would be more after the point of entry.


Option 3) is probably the least impact to the user and the app - meaning you would see the uppercase result almost instantaneously after saving.

3 Likes

I tried to use the third option but it leaves the name with an empty string.
onFormSaved event the action is set a column for this row: name = UPPER([name])

I just tried this again on a little tester app I have and I am not seeing an issue.

Action to Force Column “A” to UpperCase

Action Attached to Form’s Save Behavior

I hope this helps!!

3 Likes

Gracias a todos sus comentarios me fueron de gran ayuda, segui sus consejos de la siguiente manera:
1.- Cree la acción llamada “ForzarMayusculas”

2.- Luego cree el workflow “AplicarAccionForzarMayusculas”:
image

3.- Revise mi origen de datos de Google Sheets y los datos ingresados efectivamente fueron convertidos a mayusculas.

2 Likes

if its just for display purposes you could use a format rule. This has the option to convert to uppercase.

format rule

Is that what you wanted - to have the columns shifted by a Workflow?

If your values are being added by a Form, you could also attach your Action “ForzarMayusculas” to the “Form Saved” behavior in the Form.

The advantage is that this update is applied on the device side so you see it immediately in the display of the device but also it is sent to the server as a simple data update. This would be more efficient than triggering the Workflow. It is only a small difference.

2 Likes

Hello
Could you please show how you can use an expression to check if the entered text is in uppercase using Valid If?

You could insert a Valid_If condition that checks if what was entered was uppercase and when not invalidate the entry with a message that uppercase is required.

Try:

(FIND(UPPER([_THIS]), [_THIS]) = 1)
4 Likes

Hello Steve,

Worked perfectly… thank you so much! I appreciate your help.

Rudyard

2 Likes