using lookup tables in Collect (-Mobile)

  • Asked
  • Active
  • Viewed 3747 times
0

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

0

Accepted answer

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

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Tip: type a few words from the error message, or put a tag in [brackets] to look only there.

Menu

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.