# How to use Uppercase text only in ODK **URL:** \ **Category:** Support\ **Tags:** form-design, odk-xlsform\ **Created:** [July 17, 2014, 9:00am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420 "2014-07-17T09:00:46Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Antonio\_Niquisse](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/a/ecccb3/32.png) [@Antonio\_Niquisse](https://forum.getodk.org/u/Antonio_Niquisse)\ **Post date:** [July 17, 2014, 9:00am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/1 "2014-07-17T09:00:46Z")
Dear Community, I am the beginner in ODK environment and I am developing a database to collect information in health area. My question is: How can I only allow to include uppercase only in text type to avoid case sensitivity during data collection? For example, in the name of the facility, name of the patient, etc. I am looking forward to hear from you. Best regards, Antonio. ---
**Author:** ![Koassi\_AKAKPO](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/k/e19b73/32.png) [@Koassi\_AKAKPO](https://forum.getodk.org/u/Koassi_AKAKPO)\ **Post date:** [July 17, 2014, 9:45am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/2 "2014-07-17T09:45:05Z")
Hi Antonio, Answer must beuppercase letters and between 1 and 10 characters long for example constraint= regex(., "^[A-Z]{1,15}$") [http://opendatakit.org/help/form-design/binding/](http://opendatakit.org/help/form-design/binding/) > **···** > > Le jeudi 17 juillet 2014 09:00:46 UTC, Antonio Niquisse a écrit : \> \> Dear Community, \> \> I am the beginner in ODK environment and I am developing a database to \> collect information in health area. \> My question is: How can I only allow to include uppercase only in text \> type to avoid case sensitivity during data collection? For example, in the \> name of the facility, name of the patient, etc. \> \> I am looking forward to hear from you. \> Best regards, \> Antonio. \> ---
**Author:** ![Karim\_Derra](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/karim_derra/32/2984_2.png) [@Karim\_Derra](https://forum.getodk.org/u/Karim_Derra)\ **Post date:** [May 22, 2017, 6:13pm UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/3 "2017-05-22T18:13:37Z")
Dear Community, I am looking for the string function which can convert a lowercase to uppercase in XML Form? I tried this function :"upper-case()" but did not working. Thanks in advance. Regards, Karim Le jeudi 17 juillet 2014 09:00:46 UTC, Antonio Niquisse a écrit : \> Dear Community, \> \> I am the beginner in ODK environment and I am developing a database to collect information in health area. \> My question is: How can I only allow to include uppercase only in text type to avoid case sensitivity during data collection? For example, in the name of the facility, name of the patient, etc. \> \> I am looking forward to hear from you. \> Best regards, \> Antonio. ---
**Author:** ![Antonio\_Niquisse](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/a/ecccb3/32.png) [@Antonio\_Niquisse](https://forum.getodk.org/u/Antonio_Niquisse)\ **Post date:** [July 17, 2014, 10:17am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/4 "2014-07-17T10:17:42Z")
Hi Mokpokpok, Thank you for your reply. I forgot to say that I am using XLSForm. Therefore, I have included the code you sent but it does not give any effect. Is that code suit for XLSForm environment? Best regards, Antonio. > **···** > > On Thursday, July 17, 2014 11:45:06 AM UTC+2, Mokpokpo ADJEODA wrote: \> \> Hi Antonio, \> Answer must beuppercase letters and between 1 and 10 characters long for \> example \> constraint= regex(., "^[A-Z]{1,15}$") \> \> http://opendatakit.org/help/form-design/binding/ \> \> Le jeudi 17 juillet 2014 09:00:46 UTC, Antonio Niquisse a écrit : \>\> \>\> Dear Community, \>\> \>\> I am the beginner in ODK environment and I am developing a database to \>\> collect information in health area. \>\> My question is: How can I only allow to include uppercase only in text \>\> type to avoid case sensitivity during data collection? For example, in the \>\> name of the facility, name of the patient, etc. \>\> \>\> I am looking forward to hear from you. \>\> Best regards, \>\> Antonio. \>\> \> ---
**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\ **Post date:** [May 25, 2017, 3:08pm UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/5 "2017-05-25T15:08:14Z")
Hi Karim, As the previous messages in the thread describe, you can prevent users from entering text in a particular case, but transforms after the fact aren't currently supported. Maybe they should be, so let's talk about it. Is there a reason you can't do this at the entry point or downstream (e.g., during reporting)? Or put another way, why do you need this feature in the XForm? Thanks, Yaw > **···** > > On Mon, May 22, 2017 at 1:13 PM, Karim Derra wrote: \> Dear Community, \> \> I am looking for the string function which can convert a lowercase to \> uppercase in XML Form? \> I tried this function :"upper-case()" but did not working. \> \> Thanks in advance. \> Regards, \> Karim \> \> \> \> \> Le jeudi 17 juillet 2014 09:00:46 UTC, Antonio Niquisse a écrit : \> Dear \> Community, \> \> I am the beginner in ODK environment and I am developing a \> database to collect information in health area. \> My question is: How can I \> only allow to include uppercase only in text type to avoid case sensitivity \> during data collection? For example, in the name of the facility, name of \> the patient, etc. \> \> I am looking forward to hear from you. \> Best regards, \>\> Antonio. \> \> -- \> -- \> Post: opendatakit@googlegroups.com \> Unsubscribe: opendatakit+unsubscribe@googlegroups.com \> Options: http://groups.google.com/group/opendatakit?hl=en \> \> --- \> You received this message because you are subscribed to the Google Groups \> "ODK Community" group. \> To unsubscribe from this group and stop receiving emails from it, send an \> email to opendatakit+unsubscribe@googlegroups.com. \> For more options, visit https://groups.google.com/d/optout. ---
**Author:** ![Koassi\_AKAKPO](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/k/e19b73/32.png) [@Koassi\_AKAKPO](https://forum.getodk.org/u/Koassi_AKAKPO)\ **Post date:** [July 17, 2014, 1:35pm UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/6 "2014-07-17T13:35:41Z")
Hi Antonio, type name label constraint text hh1 Your name regex(., "^[A-Z]{1,15}$") > **···** > > Le jeudi 17 juillet 2014 10:17:42 UTC, Antonio Niquisse a écrit : \> \> Hi Mokpokpok, \> \> Thank you for your reply. \> I forgot to say that I am using XLSForm. Therefore, I have included the \> code you sent but it does not give any effect. \> Is that code suit for XLSForm environment? \> \> Best regards, \> Antonio. \> \> On Thursday, July 17, 2014 11:45:06 AM UTC+2, Mokpokpo ADJEODA wrote: \>\> \>\> Hi Antonio, \>\> Answer must beuppercase letters and between 1 and 10 characters long for \>\> example \>\> constraint= regex(., "^[A-Z]{1,15}$") \>\> \>\> http://opendatakit.org/help/form-design/binding/ \>\> \>\> Le jeudi 17 juillet 2014 09:00:46 UTC, Antonio Niquisse a écrit : \>\>\> \>\>\> Dear Community, \>\>\> \>\>\> I am the beginner in ODK environment and I am developing a database to \>\>\> collect information in health area. \>\>\> My question is: How can I only allow to include uppercase only in text \>\>\> type to avoid case sensitivity during data collection? For example, in the \>\>\> name of the facility, name of the patient, etc. \>\>\> \>\>\> I am looking forward to hear from you. \>\>\> Best regards, \>\>\> Antonio. \>\>\> \>\> ---
**Author:** ![Karim\_Derra](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/karim_derra/32/2984_2.png) [@Karim\_Derra](https://forum.getodk.org/u/Karim_Derra)\ **Post date:** [May 31, 2017, 8:28am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/7 "2017-05-31T08:28:08Z")
Thanks Yaw, I make a pull data in the form with cascading selct. One of the key variable is a composite ID which is initialy in upper case. e.g id=RE067. When I want to keep the 2first two letters of the id variable, I got "re" and not "RE". I used this function : substr(${id},0,2) regards, Karim > **···** > > 2017-05-25 15:08 GMT+00:00 Yaw Anokwa : > > > Hi Karim, > > > > As the previous messages in the thread describe, you can prevent users > > from entering text in a particular case, but transforms after the fact > > aren't currently supported. Maybe they should be, so let's talk about > > it. > > > > Is there a reason you can't do this at the entry point or downstream > > (e.g., during reporting)? Or put another way, why do you need this > > feature in the XForm? > > > > Thanks, > > > > Yaw > > > > On Mon, May 22, 2017 at 1:13 PM, Karim Derra [kderra@gmail.com](mailto:kderra@gmail.com) wrote: > > > > > Dear Community, > > > > > > I am looking for the string function which can convert a lowercase to > > > uppercase in XML Form? > > > I tried this function :"upper-case()" but did not working. > > > > > > Thanks in advance. > > > Regards, > > > Karim > > > > > > Le jeudi 17 juillet 2014 09:00:46 UTC, Antonio Niquisse a écrit : \> Dear > > > Community, \> \> I am the beginner in ODK environment and I am developing a > > > database to collect information in health area. \> My question is: How > > > can I > > > only allow to include uppercase only in text type to avoid case > > > sensitivity > > > during data collection? For example, in the name of the facility, name of > > > the patient, etc. \> \> I am looking forward to hear from you. \> Best > > > regards, > > > > > > > Antonio. > > > > > > ## -- > > > > > > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) > > > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com) > > > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en) > > > > > > * * * > > > > > > You received this message because you are subscribed to the Google Groups > > > "ODK Community" group. > > > To unsubscribe from this group and stop receiving emails from it, send an > > > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com). > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > ## -- > > > > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) > > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com) > > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en) > > > > * * * > > > > You received this message because you are subscribed to a topic in the > > Google Groups "ODK Community" group. > > To unsubscribe from this topic, visit [https://groups.google.com/d/](https://groups.google.com/d/) > > topic/opendatakit/bzUx6paP8MU/unsubscribe. > > To unsubscribe from this group and all its topics, send an email to > > [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Bashir\_Jahed](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/b/3be4f8/32.png) [@Bashir\_Jahed](https://forum.getodk.org/u/Bashir_Jahed)\ **Post date:** [July 17, 2014, 4:18pm UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/8 "2014-07-17T16:18:14Z")
The challenge with this approach is that although the user will not be able to proceed if he/she has entered lower case text they will still be able to insert lower case text and they will have to explicitly select uppercase letters while typing. This may be inhibitive or counterproductive. Why not convert to upper case text post data capture if you require it to be uppercase. Bashir > **···** > > From: opendatakit@googlegroups.com [mailto:opendatakit@googlegroups.com] On Behalf Of Mokpokpo ADJEODA Sent: 17 July 2014 03:36 PM To: opendatakit@googlegroups.com Subject: [ODK Community] Re: How to use Uppercase text only in ODK > > Hi Antonio, > > type > > name > > label > > constraint > > text > > hh1 > > Your name > > regex(., "\[1\]{1,15}$") > > Le jeudi 17 juillet 2014 10:17:42 UTC, Antonio Niquisse a écrit : > > Hi Mokpokpok, > > Thank you for your reply. > I forgot to say that I am using XLSForm. Therefore, I have included the code you sent but it does not give any effect. > Is that code suit for XLSForm environment? > > Best regards, > Antonio. > > On Thursday, July 17, 2014 11:45:06 AM UTC+2, Mokpokpo ADJEODA wrote: > > Hi Antonio, > > Answer must beuppercase letters and between 1 and 10 characters long for example > > constraint= regex(., "\[2\]{1,15}$") > > > **[Form Logic](https://docs.getodk.org/form-logic/)** > > > > ODK Collect supports a wide range of dynamic form behavior. This document covers how to specify this behavior in your XLSForm definition. Form logic building blocks: Variables: Variables reference ... > > Le jeudi 17 juillet 2014 09:00:46 UTC, Antonio Niquisse a écrit : > > Dear Community, > > I am the beginner in ODK environment and I am developing a database to collect information in health area. > My question is: How can I only allow to include uppercase only in text type to avoid case sensitivity during data collection? For example, in the name of the facility, name of the patient, etc. > > I am looking forward to hear from you. > Best regards, > Antonio. > > ## -- > > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com) > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en) > > * * * > > You received this message because you are subscribed to the Google Groups "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com). > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > * * * > > This email is free from viruses and malware because avast! Antivirus protection is active. > > > **[Avast | Download Free Antivirus & VPN | 100% Free & Easy](https://www.avast.com/en-us/index)** > > > > Join hundreds of millions of others & get free antivirus for PC, Mac, & Android. Surf safely with our VPN. Download Avast! * * * 1. A-Z 2. A-Z ---
**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\ **Post date:** [June 1, 2017, 3:42am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/9 "2017-06-01T03:42:48Z")
Hi Karim, This sounds like a bug with JavaRosa. I've filed it at [https://github.com/opendatakit/javarosa/issues/59](https://github.com/opendatakit/javarosa/issues/59). What would really help is if you could upload a very small test form to [https://github.com/opendatakit/javarosa/issues/59](https://github.com/opendatakit/javarosa/issues/59) so a volunteer could try to reproduce this bug. Please also note the version of ODK Collect you are using so we can be precise with our testing. If we can reproduce it, we'll try to fix it in the next release (probably a month from now). Thanks, Yaw > **···** > > On Wed, May 31, 2017 at 1:28 AM, Karim Derra wrote: \> \> Thanks Yaw, \> I make a pull data in the form with cascading selct. One of the key variable is a composite ID which is initialy in upper case. e.g id=RE067. \> When I want to keep the 2first two letters of the id variable, I got "re" and not "RE". \> I used this function : \> substr(${id},0,2) \> \> regards, \> Karim \> \> \> 2017-05-25 15:08 GMT+00:00 Yaw Anokwa : \>\> \>\> Hi Karim, \>\> \>\> As the previous messages in the thread describe, you can prevent users \>\> from entering text in a particular case, but transforms after the fact \>\> aren't currently supported. Maybe they should be, so let's talk about \>\> it. \>\> \>\> Is there a reason you can't do this at the entry point or downstream \>\> (e.g., during reporting)? Or put another way, why do you need this \>\> feature in the XForm? \>\> \>\> Thanks, \>\> \>\> Yaw \>\> \>\> On Mon, May 22, 2017 at 1:13 PM, Karim Derra wrote: \>\> \> Dear Community, \>\> \> \>\> \> I am looking for the string function which can convert a lowercase to \>\> \> uppercase in XML Form? \>\> \> I tried this function :"upper-case()" but did not working. \>\> \> \>\> \> Thanks in advance. \>\> \> Regards, \>\> \> Karim \>\> \> \>\> \> \>\> \> \>\> \> \>\> \> Le jeudi 17 juillet 2014 09:00:46 UTC, Antonio Niquisse a écrit : \> Dear \>\> \> Community, \> \> I am the beginner in ODK environment and I am developing a \>\> \> database to collect information in health area. \> My question is: How can I \>\> \> only allow to include uppercase only in text type to avoid case sensitivity \>\> \> during data collection? For example, in the name of the facility, name of \>\> \> the patient, etc. \> \> I am looking forward to hear from you. \> Best regards, \>\> \>\> Antonio. \>\> \> \>\> \> -- \>\> \> -- \>\> \> Post: opendatakit@googlegroups.com \>\> \> Unsubscribe: opendatakit+unsubscribe@googlegroups.com \>\> \> Options: http://groups.google.com/group/opendatakit?hl=en \>\> \> \>\> \> --- \>\> \> You received this message because you are subscribed to the Google Groups \>\> \> "ODK Community" group. \>\> \> To unsubscribe from this group and stop receiving emails from it, send an \>\> \> email to opendatakit+unsubscribe@googlegroups.com. \>\> \> For more options, visit https://groups.google.com/d/optout. \>\> \>\> -- \>\> -- \>\> Post: opendatakit@googlegroups.com \>\> Unsubscribe: opendatakit+unsubscribe@googlegroups.com \>\> Options: http://groups.google.com/group/opendatakit?hl=en \>\> \>\> --- \>\> You received this message because you are subscribed to a topic in the Google Groups "ODK Community" group. \>\> To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit/bzUx6paP8MU/unsubscribe. \>\> To unsubscribe from this group and all its topics, send an email to opendatakit+unsubscribe@googlegroups.com. \>\> For more options, visit https://groups.google.com/d/optout. \> \> \> -- \> -- \> Post: opendatakit@googlegroups.com \> Unsubscribe: opendatakit+unsubscribe@googlegroups.com \> Options: http://groups.google.com/group/opendatakit?hl=en \> \> --- \> You received this message because you are subscribed to the Google Groups "ODK Community" group. \> To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit+unsubscribe@googlegroups.com. \> For more options, visit https://groups.google.com/d/optout. ---
**Author:** ![Mitch\_S](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/3ec8ea/32.png) [@Mitch\_S](https://forum.getodk.org/u/Mitch_S)\ **Post date:** [July 17, 2014, 5:27pm UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/10 "2014-07-17T17:27:46Z")
Also, if you have fixed sets of names that the user should select, you should consider using the select-one or select-multiple prompts, and supplying the fixed set of values. For large sets of values, see [http://opendatakit.org/help/form-design/external-itemsets/](http://opendatakit.org/help/form-design/external-itemsets/) A typical use case is for cascading selects (e.g., choose province, choose town, choose facility) > **[Form Logic](https://docs.getodk.org/form-logic/#filtering-options-in-select-questions)** > > ODK Collect supports a wide range of dynamic form behavior. This document covers how to specify this behavior in your XLSForm definition. Form logic building blocks: Variables: Variables reference ... > **···** > > On Thu, Jul 17, 2014 at 9:18 AM, Bashir Jahed wrote: > > > The challenge with this approach is that although the user will not be > > able to proceed if he/she has entered lower case text they will still be > > able to insert lower case text and they will have to explicitly select > > uppercase letters while typing. This may be inhibitive or counterproductive. > > > > Why not convert to upper case text post data capture if you require it to > > be uppercase. > > > > Bashir > > > > _From:_ [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) [[mailto:opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com)] > > \*On Behalf Of \*Mokpokpo ADJEODA > > _Sent:_ 17 July 2014 03:36 PM > > _To:_ [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) > > _Subject:_ [ODK Community] Re: How to use Uppercase text only in ODK > > > > Hi Antonio, > > > > type > > > > name > > > > label > > > > constraint > > > > text > > > > hh1 > > > > Your name > > > > regex(., "\[1\]{1,15}$") > > > > Le jeudi 17 juillet 2014 10:17:42 UTC, Antonio Niquisse a écrit : > > > > Hi Mokpokpok, > > > > Thank you for your reply. > > I forgot to say that I am using XLSForm. Therefore, I have included the > > code you sent but it does not give any effect. > > Is that code suit for XLSForm environment? > > > > Best regards, > > Antonio. > > > > On Thursday, July 17, 2014 11:45:06 AM UTC+2, Mokpokpo ADJEODA wrote: > > > > Hi Antonio, > > > > Answer must beuppercase letters and between 1 and 10 characters long for > > example > > > > constraint= regex(., "\[2\]{1,15}$") > > > > [http://opendatakit.org/help/form-design/binding/](http://opendatakit.org/help/form-design/binding/) > > > > Le jeudi 17 juillet 2014 09:00:46 UTC, Antonio Niquisse a écrit : > > > > Dear Community, > > > > I am the beginner in ODK environment and I am developing a database to > > collect information in health area. > > My question is: How can I only allow to include uppercase only in text > > type to avoid case sensitivity during data collection? For example, in the > > name of the facility, name of the patient, etc. > > > > I am looking forward to hear from you. > > Best regards, > > Antonio. > > > > ## -- > > > > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) > > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com) > > Options: [http://groups](http://groups)..google.com/group/opendatakit?hl=en > > [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en) > > > > * * * > > > > You received this message because you are subscribed to the Google Groups > > "ODK Community" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > * * * > > > > [http://www.avast.com/](http://www.avast.com/) > > > > This email is free from viruses and malware because avast! Antivirus > > [http://www.avast.com/](http://www.avast.com/) protection is active. > > > > ## -- > > > > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) > > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com) > > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en) > > > > * * * > > > > You received this message because you are subscribed to the Google Groups > > "ODK Community" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- > Mitch Sundt > Software Engineer > University of Washington > [mitchellsundt@gmail.com](mailto:mitchellsundt@gmail.com) * * * 1. A-Z 2. A-Z ---
**Author:** ![Anil\_GUNAYDIN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/anil_gunaydin/32/10687_2.png) [@Anil\_GUNAYDIN](https://forum.getodk.org/u/Anil_GUNAYDIN)\ **Post date:** [March 6, 2020, 7:17am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/12 "2020-03-06T07:17:33Z")
Hello everyone, I was wondering if it is possible to force user to enter only Upper case letter with digits and only 11 characters. For example "AA11AAAAAAA" Looking forwards for your answers. Best regards, ---
**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\ **Post date:** [March 6, 2020, 10:46am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/13 "2020-03-06T10:46:53Z")
Hi @Anil_GUNAYDIN welcome to the forum! Please [introduce yourself here!](https://forum.getodk.org/t/introduce-yourself-here/) you need to use [regex](https://docs.opendatakit.org/form-regex/) here is a sample[uppercase.xlsx](https://forum.getodk.org/uploads/short-url/swuDfJlNzjirUKXuiXbwgpXbmdf.xlsx) (5.3 KB) form that should work for you: ---
**Author:** ![Anil\_GUNAYDIN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/anil_gunaydin/32/10687_2.png) [@Anil\_GUNAYDIN](https://forum.getodk.org/u/Anil_GUNAYDIN)\ **Post date:** [March 6, 2020, 12:44pm UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/14 "2020-03-06T12:44:15Z")
Hello @Grzesiek2010 thank you for your quick reply. this formula force users to enter upper case letter but I wanted to force them to enter both upper case letter and numbers . Could you please help for this question also ? Kind regards, ---
**Author:** ![danbjoseph](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/danbjoseph/32/21901_2.png) [@danbjoseph](https://forum.getodk.org/u/danbjoseph)\ **Post date:** [March 10, 2020, 5:24pm UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/15 "2020-03-10T17:24:18Z")
For 11 characters, and accepting either capital letters or numbers, change the regex expression to: `regex(.,'^[A-Z0-9]{11}$')` ---
**Author:** ![Anil\_GUNAYDIN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/anil_gunaydin/32/10687_2.png) [@Anil\_GUNAYDIN](https://forum.getodk.org/u/Anil_GUNAYDIN)\ **Post date:** [March 13, 2020, 7:18am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/16 "2020-03-13T07:18:22Z")
Thank you so much for your help and it works @danbjoseph ---
**Author:** ![Angelo\_Lazzari1](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/angelo_lazzari1/32/1684_2.png) [@Angelo\_Lazzari1](https://forum.getodk.org/u/Angelo_Lazzari1)\ **Post date:** [March 21, 2021, 6:27am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/17 "2021-03-21T06:27:38Z")
HI! thanks for the reply, but I was looking for something that converts to lowercase without bother the user during the form filling, telling him using only upper or lower case, for example, when filling an email field: I don't care how the user write it down but I want it in the database in lowercase... Is there an option to achieve this? thank you! ---
**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\ **Post date:** [March 22, 2021, 9:49am UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/18 "2021-03-22T09:49:26Z")
No, at this moment there is no function to do that automatically. ---
**Author:** ![CBatista](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/c/dbc845/32.png) [@CBatista](https://forum.getodk.org/u/CBatista)\ **Post date:** [September 2, 2023, 8:27pm UTC](https://forum.getodk.org/t/how-to-use-uppercase-text-only-in-odk/3420/19 "2023-09-02T20:27:19Z")
For posterity's sake... You can use translate in a calculate field, like this: `translate(${THE_FIELD},'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')`