Filter the values on a Ref list based on a value on current form

The title says most of it but here are the details:

Table 1- I have table of customers each with there own equipment listings.
Table 2 - I have a second table where I can log corrective action items for customers and their equipment

  • I have Table 2 set up so it references back to Table 1 for the full list of equipment (all equipment in the list regardless of customer).

  • I wan to be able to filter the equipment list on table 2 based on the customer that I pick. only showing the equipment for that customer.

How do I do this in APPSHEET? I know 100 ways to do it in excel/googlesheets, but itโ€™s not helping me here.

Solved Solved
0 5 294
1 ACCEPTED SOLUTION

Here is an AppSheet video on how to do exactly what I needed. Super simple.

View solution in original post

5 REPLIES 5
Top Labels in this Space