Select_multiple (with search() option) pulling only one member of roster from pre-populated data

Support
1

Hi all,

I am pulling roster from pre-populated datasets that include name,
fathersname, gender (C3RP3) and CARDNO (you can find all these variables in
attached csv file "names").

To pull roster of members within LSO "local support organization" I have
used select_multiple (type) with search option (see the code in attached
file "latest"). The code i wrote seems perfectly fine to pull the full
roster (name of all members in LSO) from pre-populated dataset "names",
however it is just pulling name of only one member (first one in the
preopulated datasets) in LSO.

Could anyone check whether there is an issue with code or something else
I'm missing?

Please find attachment to see code and pre-populated dataset.

Thanks,
Abbas

latest.xlsx (8.78 KB)

names.csv (1.69 KB)

2

Abbas,

On the choices sheet, B3 should be CARDNO or name or something unique.
You can't use LSOCODE because it's not unique across the rows.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Thu, Apr 21, 2016 at 1:05 AM, abbasr725@gmail.com wrote:

Hi all,

I am pulling roster from pre-populated datasets that include name,
fathersname, gender (C3RP3) and CARDNO (you can find all these variables in
attached csv file "names").

To pull roster of members within LSO "local support organization" I have
used select_multiple (type) with search option (see the code in attached
file "latest"). The code i wrote seems perfectly fine to pull the full
roster (name of all members in LSO) from pre-populated dataset "names",
however it is just pulling name of only one member (first one in the
preopulated datasets) in LSO.

Could anyone check whether there is an issue with code or something else I'm
missing?

Please find attachment to see code and pre-populated dataset.

Thanks,
Abbas

--

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.

3

All,
I have a similar problem I am trying to solve. I recreated this example
from Abbas with Yaw's fix and it worked fine. What I am looking to do
however is have a note field showing the retrieved columns from specific
line's data. What it would look like on ODK collect is something like this.

The next question will be patient 6543's weight. The last measures were
2017-01-06 65 2016-12-25 62 2016-12-01 61
What is patient 6543's current weight? _______

I tried to create a calculate var to get a string of the various weights
without dates (using search and match) for a specific id but calculate
won't take the search function.
Curtis Broderick

··· Le mercredi 4 mai 2016 18:12:00 UTC+2, Yaw Anokwa a écrit : > > Abbas, > > On the choices sheet, B3 should be CARDNO or name or something unique. > You can't use LSOCODE because it's not unique across the rows. > > Yaw > -- > Need ODK consultants? Nafundi provides form design, server setup, > in-field training, and software development for ODK. Go to > https://nafundi.com to get started. > > On Thu, Apr 21, 2016 at 1:05 AM, <abba...@gmail.com > wrote: > > Hi all, > > > > I am pulling roster from pre-populated datasets that include name, > > fathersname, gender (C3RP3) and CARDNO (you can find all these variables > in > > attached csv file "names"). > > > > To pull roster of members within LSO "local support organization" I have > > used select_multiple (type) with search option (see the code in attached > > file "latest"). The code i wrote seems perfectly fine to pull the full > > roster (name of all members in LSO) from pre-populated dataset "names", > > however it is just pulling name of only one member (first one in the > > preopulated datasets) in LSO. > > > > Could anyone check whether there is an issue with code or something else > I'm > > missing? > > > > Please find attachment to see code and pre-populated dataset. > > > > Thanks, > > Abbas > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@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...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >
4

Hi Curtis,

It sounds like you have an ID that matches a row and you want to get
some of the columns from that row.

If that's the case, I've attached a sample lookup form and
http://xlsform.org/#how-to-pull-data-from-csv has more instructions on
how to do lookups.

If that's not the case, perhaps you can provide more detail about the problem.

Yaw

data.csv (98 Bytes)

lookup.xlsx (36.1 KB)

··· On Tue, Feb 21, 2017 at 9:10 AM, Curtis Broderick wrote: > All, > I have a similar problem I am trying to solve. I recreated this example from > Abbas with Yaw's fix and it worked fine. What I am looking to do however is > have a note field showing the retrieved columns from specific line's data. > What it would look like on ODK collect is something like this. > > The next question will be patient 6543's weight. The last measures were > 2017-01-06 65 2016-12-25 62 2016-12-01 61 > What is patient 6543's current weight? _______ > > I tried to create a calculate var to get a string of the various weights > without dates (using search and match) for a specific id but calculate won't > take the search function. > Curtis Broderick > > Le mercredi 4 mai 2016 18:12:00 UTC+2, Yaw Anokwa a écrit : >> >> Abbas, >> >> On the choices sheet, B3 should be CARDNO or name or something unique. >> You can't use LSOCODE because it's not unique across the rows. >> >> Yaw >> -- >> Need ODK consultants? Nafundi provides form design, server setup, >> in-field training, and software development for ODK. Go to >> https://nafundi.com to get started. >> >> On Thu, Apr 21, 2016 at 1:05 AM, wrote: >> > Hi all, >> > >> > I am pulling roster from pre-populated datasets that include name, >> > fathersname, gender (C3RP3) and CARDNO (you can find all these variables >> > in >> > attached csv file "names"). >> > >> > To pull roster of members within LSO "local support organization" I have >> > used select_multiple (type) with search option (see the code in attached >> > file "latest"). The code i wrote seems perfectly fine to pull the full >> > roster (name of all members in LSO) from pre-populated dataset "names", >> > however it is just pulling name of only one member (first one in the >> > preopulated datasets) in LSO. >> > >> > Could anyone check whether there is an issue with code or something else >> > I'm >> > missing? >> > >> > Please find attachment to see code and pre-populated dataset. >> > >> > Thanks, >> > Abbas >> > >> > -- >> > -- >> > Post: opend...@googlegroups.com >> > Unsubscribe: opendatakit...@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...@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.