Slice built from User Email and Ref Table

AppSheet AppSheet Q&A
,
1

I’m trying to show rows of sales data based on a user’s login email. There are 3 tables involved. 1 is the AppUser table which has [UserEmail] and [SalespersonID]. The next is the Salesperson table which has a list of [SalespersonID] 's. The table I’m trying to slice is the SalesLog table which has a [SalespersonID] on every row. I’m trying to build a slice that let’s specific users see specific rows of the SalesLog. What formula would I use to build a slice? I need to select SalespersonID’s from the Saleslog table based on USEREMAIL()

2

Try as the slice row filter expression:

IN(
  [SalespersonID],
  SELECT(
    AppUser[SalespersonID],
    AND(
      ISNOTBLANK([UserEmail]),
      ([UserEmail] = USEREMAIL())
    )
  )
)

Note that the Salesperson table isn’t used at all because both the AppUser and the SalesLog table share a common reference: SalespersonID.

3

Thanks! Looks like that worked

1 Like