using lookup tables in Collect (-Mobile)

Dear all, Just a general question: in the idm documentation there is a reference to the use of lookup tables (idm:lookup), which ca be used to retrive values from my_custom_table (a table that is referenced). This seems to work similar to the sampling point list, from which we can query information for each sampling point. Question: where do I put my_custom_table to acesss it? AND: is it possible to use lookup tables with Collect Mobile?

Thanks, Lutz

collectmobile

asked 05 Feb '18, 14:58

Fehrmann
77●3●19●35
accept rate: 0%

One Answer:

active answers oldest answers newest answers popular answers

Dear Lutz,
Using the lookup tables in Collect Mobile is possible but it's a bit tricky, you should modify the file .collect-mobile exported from the Survey Designer and include the lookup table in the SQLite database file included in that file.
Usually it's not necessary to use external tables in the 99% of cases; you should be able to put all the reference data into code lists. What do you need them for?
If you want we can provide you our support in this, we will contact you to your private email.
Many thanks,
Open Foris Team

permanent link

answered 06 Feb '18, 09:53

Stefano (OF) ♦♦
4.8k●1●1●9
accept rate: 19%

Your answer

toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

collectmobile ×171

question asked: 05 Feb '18, 14:58

question was seen: 2,354 times

last updated: 06 Feb '18, 09:53

using lookup tables in Collect (-Mobile)

Follow this question

Related questions