-
ricardostartitAsked on January 15, 2018 at 4:32 PMEu preciso das minhas informações de DATABASE EM CAPS. Eu não me importo com o que parece no formulário ou no que parece no e-mail que vem para mim. Eu só me importo que seja TODOS OS CAPS no banco de dados real csv ou excel que é baixado. Há alguma maneira de fazer isso? Agora eu tenho que baixar o banco de dados e corrigir tudo e, em seguida, importá-lo para o software que eu preciso.
-
Elton Support Team LeadReplied on January 15, 2018 at 5:29 PM
Unfortunately, it is not possible to change the casing in the submissions page unless the submitted data are already in upper casing.
The workaround is to automatically capitalize all the letters submitted by the user. That is only possible when you implement casing function in your form source code by using custom scripts. Here's how to take your form source code http://www.jotform.com/help/104-How-to-Download-a-Source-Code-of-your-Form.
Or, you can stay with what you did, download the submissions to excel, change the casing before uploading it to our database. This is pretty much the easiest way around since you can quickly change the text casing in Excel application. You can also use Macros in Excel to automatically capitalize all text.
Sub Upper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = UCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub