Do you have any idea how to write a script in Google Form that it will automatically upper case no matter how you type when it submit to the response spreadsheet.
Hi @desmondlee, glad reading from you.
I wouldn’t do the App Script on the Forms but on the Google Sheet after submitting and entering into the spreadsheet.
Does that work?
As long as the letter submitted to the responses sheet is upper case will be good enough for me
I dont know whether this works of not. I remember I did create a script to auto upper case direct to the responses spreadsheet. The result is those I type directly will become upper case but those data from google form doesn’t work. Let me try first