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

asked 05 Feb '18, 14:58

Fehrmann's gravatar image

accept rate: 0%

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

OF%20Collect's gravatar image

OF Collect ♦♦
accept rate: 23%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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

Question tags:


question asked: 05 Feb '18, 14:58

question was seen: 1,084 times

last updated: 06 Feb '18, 09:53