Solved: Trying to set a security filter 'Orders Table' : w... - Page 2

Rurrea · 04-07-2021 01:08 PM

and(ANY(SELECT(AOD[Salesperson ID], ([Email] = useremail())))=[SalesPerson],[Order Date]>=today()-12)
Above formula works perfect and shows each user all their orders.

However i need it to show their Splitsale too:: So at the end of the day, if the users name pops up in either field as [salesperson] or [splitsale], then i need that user to have access to it.
[Salesperson], [Splitsale] : Both are fields in Orders Table that chooses reps name.

I wrote it several ways but doesnt seem to work. Any ideas

Steve

AND(
  ([Order Date] >= (TODAY() - 12)),
  ISNOTBLANK(
    INTERSECT(
      LIST(
        [Salesperson],
        [SplitSale]
      ),
      SELECT(
        AOD[Salesperson ID],
        (USEREMAIL() = [Email])
      )
    )
  )
)

View solution in original post

Trying to set a security filter 'Orders Table' : where it only shows each users their orders