In this article
Note: CAPI Administrator is deprecated. Please use CAPI Supervisor instead.
For offline long list lookups within a survey in the CAPI app, use a SmartHub Custom Data Table. Custom data tables from SmartHub can be used as answer lists in surveys, making it easy to centrally manage lists that can be used across numerous surveys and Studio dashboards.
1: Adding the Data Table
To download the data table with the survey, add a “Table lookup/hierarchy” question to the survey. If you do not want the question to be displayed to the participant/interviewer, as in the case of a scripted lookup, set the “Table lookup/hierarchy” question to hidden.
To perform scripted lookups within a data table (instead of using the data table in a visible question), see GetHubCustomTableColumnValues. By using scripted lookups, you can have a very large dataset to perform any type of data lookup (postal codes, drug list, address list, etc).
2: Limits and Considerations
For best results, keep the table lookup under 100,000 rows.
To download or update custom data tables, you must tap the Sync button.
3: FAQs
What is the maximum table size that is supported?
Although the existing custom data table AUP is 1 million rows, testing has revealed that it is suggested to keep table lookup support to under 100 thousand rows.
If a custom table is referenced by more than one survey assigned to a CAPI user, will the table be downloaded and stored separately for each survey?
No, only a single copy of the table will be downloaded / stored. It is able to be referenced by more than one survey.
How much time does it take to download a large table?
Initial download is fast compared to the entire CAPI sync.
Can I change the table schema (add another column) once the survey is live?
Yes, if a schema change is detected, the entire table is redownloaded.
What happens if I add/remove rows from the table or update data in an existing row?
The CAPI App only downloads the changed records unless there are a large number of changes (which causes the entire table to redownload, similar to a schema change).
When are custom data tables downloaded/updated?
Only during a normal “full” Sync (tapping the sync button).