I have preloaded csv data from another form and I was able to return data with one loookup value. I'm wandering how to return data with two lookup value from the available csv columns?

You could also merge the keys in a calculation before sending it off to the lookup file. So instead of sending "Sally" as the key, send "Sallyred", "Bobred", "Sallygreen", etc. If you are differentiating on two factors, then the key is really the combination of those two factors. Jason

Have you read through the preloading documentation here ? For each value that you need to pull out of your csv data, you should be able to create a calculate field in your XLSForm that makes a call on pulldata. If that doesn't answer your question, please provide more information on what you are tr…

Given a single id, you can retrieve single values from the CSV and use that in the form. Let's say you have a CSV like this. +----------+------------+-----------------+ | child_id | child_name | child_fav_color | +----------+------------+-----------------+ | 1 | Bob | red …

Hi Yaw, Let's say I want to target Sally that has favourite red color, how we do that in pulldata? child_name child_fav_color Bob red Sally green Jose yellow Sally red

This is currently not possible. And if you'd like to see it added to ODK, please file a feature request .

[image] yanokwa: red I've been doing this by giving two pulldata requests in succession to filter the results. The first would be to pick the color from a list of all the colors (eg. red) and store that in a variable, and then get a list of all the names corresponding to the picked color in t…

Can you give me a sample of your work for this? Or anyone else?

Good day; I am just struggling to get the pulldata fulfilled. I have a file for Identification Information for Enumeration Areas, I am just failing to link it to the form. pulldata(‘neussl’, ‘str_no’, ‘district’, 'loc_type', 'ea_code', 'sr_no', ${sr_no}) This is the error I am getting " FormLogic…

@tebok , pulldata only works with 4 parameters. Those parameters are, in order: CSV file, column with value, column with key, lookup variable. In your example, you have 7 parameters. Try to get the examples here working first: http://xlsform.org/en/#pre-loading-csv-data https://blog.ona.io/general…

got that sorted, thanks. now i got a massive error on indexed repeat - see the attached sectione.xlsx (13.8 KB)

Check it and let us know if it works sectione.xlsx (18.9 KB)

ODK Forum

Pulldata with two lookup values

Support

odk-xlsform

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled

Looking for a better way? Try ODK Cloud, the official managed hosting service from the creators of ODK.