Text or number

Dear All,
I have a text field that I want to restrict to data entry to certain
numbers/chracters e.g data entrant should in put their EMPID and valid
figures include 555, 666, md5n mg89 888 e.tc
I have put in constraint .=555 or .=666 or md5n or mg89 or .=888
it work fine with the integers but when data entrant inputs the
alphanumeric e.g md5n it refuses
Any help is much appreciated
Ayoub

··· -- **In sun set years education is not associated with standard of living and medical care access; it is the the financial myosin and actin!!!

**** Don't give me fish, teach me how to fish

Kayoub K
0772656158 / 0703516660
Data Manager
Mujhu Research Collaboration
Mulago Hosp
Msc Enterprise Architecture

Hi Ayoub,

You can use regular expressions for such constraints. See here
https://confluence.dimagi.com/display/commcarepublic/Advanced+Validation+Conditionsfor
examples

Sam

··· On Wednesday, 7 December 2016 15:07:10 UTC+2, Ayoub Kakande wrote: > > Dear All, > I have a text field that I want to restrict to data entry to certain > numbers/chracters e.g data entrant should in put their EMPID and valid > figures include 555, 666, md5n mg89 888 e.tc > I have put in constraint .=555 or .=666 or md5n or mg89 or .=888 > it work fine with the integers but when data entrant inputs the > alphanumeric e.g md5n it refuses > Any help is much appreciated > Ayoub > -- > **In sun set years education is not associated with standard of living and > medical care access; it is the the financial myosin and actin!!! > > **** Don't give me fish, teach me how to fish > > Kayoub K > 0772656158 / 0703516660 > Data Manager > Mujhu Research Collaboration > Mulago Hosp > Msc Enterprise Architecture >

Thanks Sam,
However most of the help from link about is about restraining input (input
mask) however in my case I already have specific 50 possible
characters/numbers that entrants can use then tablet pops up user name
depending on id they have entered

Any more help is needed

··· On 8 December 2016 at 12:21, Sam Phiri wrote:

Hi Ayoub,

You can use regular expressions for such constraints. See here
https://confluence.dimagi.com/display/commcarepublic/Advanced+Validation+Conditionsfor
examples

Sam

On Wednesday, 7 December 2016 15:07:10 UTC+2, Ayoub Kakande wrote:

Dear All,
I have a text field that I want to restrict to data entry to certain
numbers/chracters e.g data entrant should in put their EMPID and valid
figures include 555, 666, md5n mg89 888 e.tc
I have put in constraint .=555 or .=666 or md5n or mg89 or .=888
it work fine with the integers but when data entrant inputs the
alphanumeric e.g md5n it refuses
Any help is much appreciated
Ayoub

**In sun set years education is not associated with standard of living
and medical care access; it is the the financial myosin and actin!!!

**** Don't give me fish, teach me how to fish

Kayoub K
0772656158 <0772%20656158> / 0703516660 <0703%20516660>
Data Manager
Mujhu Research Collaboration
Mulago Hosp
Msc Enterprise Architecture

--

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.

--
**In sun set years education is not associated with standard of living and
medical care access; it is the the financial myosin and actin!!!

**** Don't give me fish, teach me how to fish

Kayoub K
0772656158 / 0703516660
Data Manager
Mujhu Research Collaboration
Mulago Hosp
Msc Enterprise Architecture

1 Like

Ayoub,

What might work best for your use-case is a lookup using an external
CSV. I've attached an example. The data.csv should be in
/sdcard/odk/forms/lookup-media/

Yaw

data.csv (87 Bytes)

lookup.xlsx (38 KB)

··· On Wed, Dec 14, 2016 at 7:06 AM, Ayoub Kakande wrote: > Thanks Sam, > However most of the help from link about is about restraining input (input > mask) however in my case I already have specific 50 possible > characters/numbers that entrants can use then tablet pops up user name > depending on id they have entered > > Any more help is needed > > On 8 December 2016 at 12:21, Sam Phiri wrote: >> >> Hi Ayoub, >> >> You can use regular expressions for such constraints. See here for >> examples >> >> Sam >> >> >> On Wednesday, 7 December 2016 15:07:10 UTC+2, Ayoub Kakande wrote: >>> >>> Dear All, >>> I have a text field that I want to restrict to data entry to certain >>> numbers/chracters e.g data entrant should in put their EMPID and valid >>> figures include 555, 666, md5n mg89 888 e.tc >>> I have put in constraint .=555 or .=666 or md5n or mg89 or .=888 >>> it work fine with the integers but when data entrant inputs the >>> alphanumeric e.g md5n it refuses >>> Any help is much appreciated >>> Ayoub >>> -- >>> **In sun set years education is not associated with standard of living >>> and medical care access; it is the the financial myosin and actin!!! >>> >>> **** Don't give me fish, teach me how to fish >>> >>> Kayoub K >>> 0772656158 / 0703516660 >>> Data Manager >>> Mujhu Research Collaboration >>> Mulago Hosp >>> Msc Enterprise Architecture >> >> -- >> -- >> 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. > > > > > -- > **In sun set years education is not associated with standard of living and > medical care access; it is the the financial myosin and actin!!! > > **** Don't give me fish, teach me how to fish > > Kayoub K > 0772656158 / 0703516660 > Data Manager > Mujhu Research Collaboration > Mulago Hosp > Msc Enterprise Architecture > > -- > -- > 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.
1 Like

Thanks Yaw,
It helps a lot
One question,
if later on I get other entrants can I just update the data.csv and reload
it without replacing the XML form

Thanks again
Ayoub

··· On 25 December 2016 at 04:54, Yaw Anokwa wrote:

Ayoub,

What might work best for your use-case is a lookup using an external
CSV. I've attached an example. The data.csv should be in
/sdcard/odk/forms/lookup-media/

Yaw

On Wed, Dec 14, 2016 at 7:06 AM, Ayoub Kakande akakande@gmail.com wrote:

Thanks Sam,
However most of the help from link about is about restraining input
(input
mask) however in my case I already have specific 50 possible
characters/numbers that entrants can use then tablet pops up user name
depending on id they have entered

Any more help is needed

On 8 December 2016 at 12:21, Sam Phiri mitoworks21@gmail.com wrote:

Hi Ayoub,

You can use regular expressions for such constraints. See here for
examples

Sam

On Wednesday, 7 December 2016 15:07:10 UTC+2, Ayoub Kakande wrote:

Dear All,
I have a text field that I want to restrict to data entry to certain
numbers/chracters e.g data entrant should in put their EMPID and valid
figures include 555, 666, md5n mg89 888 e.tc
I have put in constraint .=555 or .=666 or md5n or mg89 or .=888
it work fine with the integers but when data entrant inputs the
alphanumeric e.g md5n it refuses
Any help is much appreciated
Ayoub

**In sun set years education is not associated with standard of living
and medical care access; it is the the financial myosin and actin!!!

**** Don't give me fish, teach me how to fish

Kayoub K
0772656158 / 0703516660
Data Manager
Mujhu Research Collaboration
Mulago Hosp
Msc Enterprise Architecture

--

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.

--
**In sun set years education is not associated with standard of living
and
medical care access; it is the the financial myosin and actin!!!

**** Don't give me fish, teach me how to fish

Kayoub K
0772656158 / 0703516660
Data Manager
Mujhu Research Collaboration
Mulago Hosp
Msc Enterprise Architecture

--

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 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.

--
**In sun set years education is not associated with standard of living and
medical care access; it is the the financial myosin and actin!!!

**** Don't give me fish, teach me how to fish

Kayoub K
0772656158 / 0703516660
Data Manager
Mujhu Research Collaboration
Mulago Hosp
Msc Enterprise Architecture

1 Like

Ayoub,

You can manually replace the data.csv on the SD card and that should
work. It's been a while since I looked at that code, so please check
first.

Yaw

··· On Thu, Dec 29, 2016 at 1:10 AM, Ayoub Kakande wrote: > Thanks Yaw, > It helps a lot > One question, > if later on I get other entrants can I just update the data.csv and reload > it without replacing the XML form > > Thanks again > Ayoub > > On 25 December 2016 at 04:54, Yaw Anokwa wrote: >> >> Ayoub, >> >> What might work best for your use-case is a lookup using an external >> CSV. I've attached an example. The data.csv should be in >> /sdcard/odk/forms/lookup-media/ >> >> Yaw >> >> On Wed, Dec 14, 2016 at 7:06 AM, Ayoub Kakande wrote: >> > Thanks Sam, >> > However most of the help from link about is about restraining input >> > (input >> > mask) however in my case I already have specific 50 possible >> > characters/numbers that entrants can use then tablet pops up user name >> > depending on id they have entered >> > >> > Any more help is needed >> > >> > On 8 December 2016 at 12:21, Sam Phiri wrote: >> >> >> >> Hi Ayoub, >> >> >> >> You can use regular expressions for such constraints. See here for >> >> examples >> >> >> >> Sam >> >> >> >> >> >> On Wednesday, 7 December 2016 15:07:10 UTC+2, Ayoub Kakande wrote: >> >>> >> >>> Dear All, >> >>> I have a text field that I want to restrict to data entry to certain >> >>> numbers/chracters e.g data entrant should in put their EMPID and valid >> >>> figures include 555, 666, md5n mg89 888 e.tc >> >>> I have put in constraint .=555 or .=666 or md5n or mg89 or .=888 >> >>> it work fine with the integers but when data entrant inputs the >> >>> alphanumeric e.g md5n it refuses >> >>> Any help is much appreciated >> >>> Ayoub >> >>> -- >> >>> **In sun set years education is not associated with standard of living >> >>> and medical care access; it is the the financial myosin and actin!!! >> >>> >> >>> **** Don't give me fish, teach me how to fish >> >>> >> >>> Kayoub K >> >>> 0772656158 / 0703516660 >> >>> Data Manager >> >>> Mujhu Research Collaboration >> >>> Mulago Hosp >> >>> Msc Enterprise Architecture >> >> >> >> -- >> >> -- >> >> 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. >> > >> > >> > >> > >> > -- >> > **In sun set years education is not associated with standard of living >> > and >> > medical care access; it is the the financial myosin and actin!!! >> > >> > **** Don't give me fish, teach me how to fish >> > >> > Kayoub K >> > 0772656158 / 0703516660 >> > Data Manager >> > Mujhu Research Collaboration >> > Mulago Hosp >> > Msc Enterprise Architecture >> > >> > -- >> > -- >> > 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 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. > > > > > -- > **In sun set years education is not associated with standard of living and > medical care access; it is the the financial myosin and actin!!! > > **** Don't give me fish, teach me how to fish > > Kayoub K > 0772656158 / 0703516660 > Data Manager > Mujhu Research Collaboration > Mulago Hosp > Msc Enterprise Architecture > > -- > -- > 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.
1 Like