Hola!
Cuando quiero convertir una columna en mayusculas (UPPER) del tipo KEY, sea con un BOT o una ACTION da un error en Appsheet diciendo que no se puede modificar una columna de este tipo.
La consulta es la siguiente:
1-Hay algun metodo para convertir este tipo de columnas (KEY) en MAYUSCULAS?
2-En caso negativo a la primera pregunta, hay algun metodo para enviar una notificacion, popup o tooltip al usuario para que ingrese los datos en MAYUSCULAS?
Algo parecido al ejemplo de la foto.
Gracias!
Solved! Go to Solution.
Please try the following expression in the valid_if of the [CLINTE] column.
FIND([_THIS], UPPER([_THIS]))=1
The expression takes advantage of the fact that FIND() is a case sensitive function.
However , you may want to consider some other column such as a column with UNIQUEID() function as key column for your table. This is because in rare cases the [CLINTE] name could repeat.
Please try the following expression in the valid_if of the [CLINTE] column.
FIND([_THIS], UPPER([_THIS]))=1
The expression takes advantage of the fact that FIND() is a case sensitive function.
However , you may want to consider some other column such as a column with UNIQUEID() function as key column for your table. This is because in rare cases the [CLINTE] name could repeat.
Excellent! @Suvrutt_Gurjar
Works perfect,
thanks!
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |