Solved: Unique dropdown on Ref Column - Page 2

Austin · 06-01-2020 08:35 AM

I have a list of jobs that I am referencing from an interview scheduling table. We might have more than one opening for the exact same job ie Full Time cashier at store 1. I need my drop down to only show me one result for FT cashier store 1. Since this is a reference column a unique select won’t work since the ID is different for the 2 jobs. My current solution uses a view in database to bring in only the oldest job record where X,Y, and Z column match. There are issues with this so I was hoping to just filter down my dropdown list in appsheet.

Steve

The first Jobs row of each distinct Job Title column value:

FILTER(
  "Jobs",
  (
    [_ROWNUMBER]
    = MIN(
      SELECT(
        Jobs[_ROWNUMBER],
        ([_THISROW-1].[Job Title] = [Job Title])
      )
    )
  )
)

View solution in original post