choose a table based on input

[giwpydotcom]

Is there a way to choose a table to filter based on the response of a user?

So I have tables that are named after states, and each state has different polling units. The entire data is too long for AppSheet, so I thought I should break it into multiple tables for different states showing the polling units in each state. Now, how can I set the formula so that when a user selects a state, only polling units that are applicable in that state will be drop-down options in the polling unit question?

[Aurelien]

Hi @giwpydotcom 

I would suggest using a IFS() syntax:

IFS() - AppSheet Help