Page Comparison

...

1. Login to CommCare HQ
2. Click the Data link on the Dashboard
   Image Added
3. In the Lookup Tables section, click Manage Tables 
   Image Added
   
4. Click the Add Table button
   Image Added
5. Specify the Table ID (unique name that describes the table's contents)
   Note: Special characters and spaces cannot be included in a Table ID.
6. Include Fields (information to be stored in a table) by clicking the Add Field button
7. Click Save when finished
   Image Added

Note: The Visible to all users? selection determines whether a table is public or assigned to individual users. This is especially helpful when users should only see those items that are related to them. Applications deployed in multiple languages require more than one Field for a given property (i.e., state name, state abbreviation) 📖Learn more Advanced Lookup Tables.

Viewing Table Data

After a table(s) is created, the view tables option can be used to see its data.

To view a table:

...

1. Login to CommCare HQ
2. Click the Data link on the Dashboard
   Image Added
3. In the Lookup Tables section, click View Tables
   Image Added
   

Note: Tables can also be viewed in the Manage Tables window by clicking View Table next to the table ID of interest.

 

Downloading or Uploading Tables for Editing

...

1. Navigate to the lookup table of interest
2. From the Manage Tables section, click the Include in Download checkbox next to each table of interest
   Note: The all or none buttons can be used to select or deselect multiple tables.
3. Click the Download Lookup Tables button. Download time will vary by connection speed.
   Image Added

Note: The downloaded Microsoft Excel file includes a sheet titled Types, a sheet for each table with collected data, user ID columns, and Delete (Y/N) columns. The Types sheet is necessary when defining advanced lookup tables. 📖Learn more Advanced Lookup Tables.

...

1. Navigate to the lookup table of interest
2. From the Upload Lookup Tables section, click the Replace Existing Tables checkbox
   Note: The Replace Existing Tables option will replace any existing tables with new data from the uploaded Microsoft Excel file. If not selected, existing data will be updated with new rows added to the sheet.
3. Click the Upload Tables button
   Image Added

Editing Table Data in MS Excel

...

Example: "District" table download

Types sheet
Image Added

District (table) sheet
Image Added

Note: If a table requires rows assigned to users (i.e., user 1, group 1), these columns should be added manually. 📖Learn more about Mobile Worker Groups.

...

1. Complete steps 1-3 from "To download tables"
2. Open the download file ("Sheet 1" in this example)
3. Create a second sheet in MS Excel ("Sheet 2" in this example)
4. Copy and paste all of the fields from the Types tab of "Sheet 1" into "Sheet 2"
   Image Added
5. Rename the "Sheet 2" tab
6. From the "Sheet 2" tab, change the table_id to a title of choice (ex: "hypertension_2")
7. In "Sheet 1", copy the table headers (i.e., UID, Delete, etc.) in row 1 from the tab that contains the lookup table name ("hypertension" in this example)
   Image Added
8. In "Sheet 2", create a new tab and assign a name of choice for the lookup table
9. Copy the headers into row 1 of "hypertension_2" (or the name you chose in step 6)
10. Transfer the cells from "Sheet 1" that should be included "Sheet 2"
11. Complete steps 1-2 of "To upload data"

Note: After all steps above have been completed, the lookup table references should be updated or a second question can be added to a Form to reference the new lookup table instead.
The result is a second lookup table that contains file that was split. Below is an example.

Image AddedImage Added