I am reaching out for assistance with an issue I am experiencing when using lookup tables in my form.
Despite uploading my lookup table Excel file (with the types sheet and the data sheet correctly configured), I continue to receive the following error in my form:
Unable to find lookup table: jr://fixture/item-list:departamentos
What I have tried so far:
Created the types sheet with table_id = departamentos.
Named the data sheet departamentos.
Verified that the table uploads correctly under Data → Lookup Tables → Manage Tables.
Added filter expressions in my form to show municipio = "" for departments and departamento = #form/departamento for municipalities.
Synced the application after upload.
However, the error persists, and the form does not seem to recognize the lookup table.
Could anyone kindly guide me on what I might be missing, or suggest steps to resolve this issue?
I said you have filters for both questions but with my experience you need just a filter.
Eg. I have two look up tables ie. Region and districts. A region consist of many districts.
So what I did was I left the filter for my region look up table empty and in the district look up table I added a filter referencing the region question (region=regionis).
Unable to find lookup table: jr://fixture/item-list:departamentos
Means that that lookup table wasn’t found on the user’s phone. When you say you synced the application, do you mean you clicked the “sync” button, or that you updated the application itself? You’d need to do both for this action to work. Assuming you did both, you might also ensure there are no constraints on the lookup table preventing it from being synced to this user - is the visible to all users box checked?
Another good thing to check is to try clearing user data on the device. This shouldn’t be necessary, but it doesn’t hurt to check. Could you let us know if that resolves the issue, please?
