Show all rows based on customers

This should be an easy one.

I have a spreadsheet where I put in all new sales transactions. In the app, if I click on one of the transactions it shows me the details. Within this details view, I’d like to also see the other transactions with this same customer.

I’ve done this with a query in Google sheets. I created a drop-down menu, and it shows all transactions depending on the customer I choose.

Please help!

Welcome to the AppSheet community.

One simple approach if it helps could be to group the transactions table by customer name in summary views such as table or deck views.

Please post back with more details if you are specifically looking for something else the way you have mentioned.

You may also find the below post useful with various relevant references useful for the app creation.