Multiple Lookup in ODK

Dear all,

I need to write syntax in XLS form to lookup two variables from pre-loaded .csv file. But, I did only one variable. I mean how to search data from pre-loaded file with match two specific criteria. Please help me with your best.

To call something from the .CSV file you need to use the calculate data type, in the calculation column add the pulldata function, for each variable that you want to call from the .CSV file you need one calculation
2 variables = 2 calculations

··· On Tuesday, February 21, 2017 at 7:15:45 AM UTC+2, July Ko Ko wrote: > Dear all, > > I need to write syntax in XLS form to lookup two variables from pre-loaded .csv file. But, I did only one variable. I mean how to search data from pre-loaded file with match two specific criteria. Please help me with your best.

And just to add on,
https://opendatakit.org/help/form-design/data-preloading/ has more on
the search() syntax.

Yaw

··· On Tue, Feb 21, 2017 at 8:42 PM, wrote: > On Tuesday, February 21, 2017 at 7:15:45 AM UTC+2, July Ko Ko wrote: >> Dear all, >> >> I need to write syntax in XLS form to lookup two variables from pre-loaded .csv file. But, I did only one variable. I mean how to search data from pre-loaded file with match two specific criteria. Please help me with your best. > > To call something from the .CSV file you need to use the calculate data type, in the calculation column add the pulldata function, for each variable that you want to call from the .CSV file you need one calculation > 2 variables = 2 calculations > > -- > -- > 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.