How to make the data entered in a form view filter data from the rest of the views, for example: In my first form view, I select “route 1”. I want my customer view to only show those customers in my database who have “route 1” in the route column
Please take a look at the sample app “Slice based on user inputs”
Slice based on user input - AppSheet
from the help article Get started by using the feature samples - AppSheet Help
Please note the above sample app is useful for simultaneous filtering by one user. You will need to approaches such as a different Users table to store the different selections of different users.