I have a Customer management appsheet - there...

AppSheet AppSheet Q&A
1

I have a Customer management appsheet - there’s Organizations, people and locations, a table for each.

In my app, when I go to an Organization, and then add a location, I would like to select the person who corresponds with a given location.

My problem is the list of people is showing ALL people from ALL organizations.

I would like to drop down a list of ONLY the people who belong to the selected organization.

Is SHOWIF what I should use?

I keep tripping on this one.

2

Put this in the Valid_If for the column: SELECT(People[keyCol],AND([Organization]=[_THISROW].[Organization], [Location]=[_THISROW].[Location]))