Form Drop Down based on Refs to two different tables

AppSheet AppSheet Q&A
1

Hello,

Hoping for some help. I’ve got 3 tables relevant in this case. Contacts, Stores, and Store Visits. I have an action on all stores (from the Stores table) that launches a Store Visit which pre-populates the store name from the Store Table. While executing the Store Visit users can select a contact from a drop down from the Contacts table. The contacts are populated fine through a ref to the Contact table in the Store Visits table but it shows all contacts. I’m trying to have it show only the contacts associated with that store. The contact table has a ref to the Stores table.

2

In the reference column in the Store Visits table that reference Contacts table, please have an expression something like below in the valid_if setting.

SELECT( Contacts[Names], [Store Name in Contacts]=[_THISROW].[Store Name in Stores Visit])

[Store Name in Contacts] is the name of the column that has stores names or ID in the Contacts table. [Store Name in Stores Visit] is the column that contains Store ID or name in the Stores Visits table.

2 Likes
3

AMAZING. Thank you! I was SO close :S

2 Likes