How to Display User Information Based on Code Selection in ODK?

Support
1

Hola everyone,

I'm developing a survey where users identify themselves with a code, and I want the user information (name, state, village) to automatically display once the code is selected. For example:

Nombre: xxx
Village: xxxx
State: xxxx

I have tried using a calculation with "lookup" and an external file, but according to ODK, it doesn’t support lookup. I don’t want to use the "if" condition either, as it would be too complicated with around 2000 users. How can I achieve this? Any insight will be great! I appreciate any help! Thanks :slight_smile:

2

ODK supports lookups.

See https://docs.getodk.org/form-datasets/#looking-up-values-in-datasets to learn how to select from a list and then lookup values associated with that selection.

If you want to do the lookup without a select (e.g., with a barcode scan or direct entry), then https://docs.getodk.org/form-datasets/#attaching-csvs-for-lookups-without-a-select has an example.

1 Like