Force data entry at Form to be all UPPER case

[desmond_lee]

Hi Expert

Is anyway like expression or feature in the appsheet to force data entry all Capital Letter and not Small letter. Example below is the Key value and user keep enter lower case. 115g-098-R1-009 --- how do I systematically force user to make sure he enter 115G-098-R1-009

[Suvrutt_Gurjar · Accepted solution]

Please try in the valid_if of the [SAP NUMBER] column

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

[Sirfyaad]

Created Behaviour and Bots likes this. 

[desmond_lee]

 I have just done that it does not work because that column is a KEY VALUE and it show an error cannot modified

[Suvrutt_Gurjar · Accepted solution]

Please try in the valid_if of the [SAP NUMBER] column

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

[Marc_Dillon · Accepted solution]

FIND() is the only case-sensitive expression in appsheet.

valid_if = FIND( [_THIS] , UPPER( [_THIS] ) ) = 1

[desmond_lee]

Wow I need to check 900 rows but with this expression it all solved. Thank soooooooooo much