UPPER() Key Columns

Hi Team,

I have created a table inside which the column is Client Id. And I have also created an action behavior for the same column but I am facing an error. Appsheet is not running UPPER() functions for key columns. how can I run this action behaviour. 

0 3 54
3 REPLIES 3

You can't because you are not able to modify key column's value after it's created.

Any suggestions 

If the goal is to have that key column with upper letters, use a validation and your own error message. For that purpose this should do the job..
FIND([KeyColumn],UPPER([KeyColumn]))>0

Top Labels in this Space