Quick question on Cascading

. Can anybody help me on the following issue in cascading:

I want my location information displayed with its names on the mobile device
so that the user understands it but the values that are saved in the
database are actually its PCodes.

For example:

Question No

Question Label

Displayed on mobile device as

(First interview answers)

Saved in Database as PCodes:

Q.1

GOVERNORATE Mohafaza (Admin 1)

Quneitra

SY14

Q.2

DISTRICT Mantika (Admin 2)

Al Fiq

SY1402

Q.3

SUB-DISTRICT (Nahya) (Admin 3)

Fiq

SY140200

Q.4

COMMUNITIES (Admin 4)

Sayda

C6302

Q.5

CITY DISTRICT (Admin 5)

Thanks

Irum

Irum Jamshed | Manager - Data Management
International Rescue Committee
mailto:Irum.Jamshed@pakistan.the Irum.Jamshed@pakistan.theirc.org | +92
91 5703310 (Ext-105) | rescue.org

12345

image

Hi Irum,
Assuming you're using an xlsform, the "name" column sets the underlying
values stored in the database (i.e. your PCodes), and the label column sets
the value displayed to users. Check out this form for an
example: http://opendatakit.org/wp-content/uploads/2012/07/new_cascading_select.xls
Regards,
-Nathan

ยทยทยท On Thursday, February 14, 2013 2:32:38 AM UTC-8, irum.jamshed wrote: > > . Can anybody help me on the following issue in cascading: > > > > I want my location information displayed with its names on the mobile > device so that the user understands it but the values that are saved in the > database are actually its PCodes. > > > > For example: > > > > *Question No* > > *Question Label * > > *Displayed on mobile device as* > > *(First interview answers)* > > *Saved in Database as PCodes: * > > Q.1 > > GOVERNORATE Mohafaza (Admin 1) > > Quneitra > > SY14 > > Q.2 > > DISTRICT Mantika (Admin 2) > > Al Fiq > > SY1402 > > Q.3 > > SUB-DISTRICT (Nahya) (Admin 3) > > Fiq > > SY140200 > > Q.4 > > COMMUNITIES (Admin 4) > > Sayda > > C6302 > > Q.5 > > CITY DISTRICT (Admin 5) > > > > > > > > > > Thanks > > Irum > > > > *Irum Jamshed | Manager - Data Management > *International Rescue Committee > Irum.Jamshed@pakistan.the *irc.org* | +92 91 5703310 > (Ext-105) | rescue.org > > [image: 12345] > > >