Lookup Tables - Filter

Hi all,

I cannot seem to figure this out. I want to have options so mobile users
can choose first a District, then Village, etc. They would only see
Villages in the District selected. I have read the help page for Lookup
Table Filters but am having trouble. I have attached the spreadsheet I am
using, and a screenshot. The table uploads, but I think I’m having trouble
with the Filter expression…

Basically… If i am doing the table right… I can upload 1 excel doc with
all of my breakdowns (District, TA, Village, etc.), right? Then just need
to make sure the expressions are correct?


lookup_table_test.xlsx (10.8 KB)