Solved: Option elimination in enumlist - Page 2

Mayank_G · 06-26-2019 08:30 AM

Hi All,
Background:
This is about the Construction Daily Reports sample app.
In the Foreman daily report view (this is a form view wherein a daily report is entered) the Crew on site field appears.
What I want:
Once a foreman fills out a daily report and selects the individuals on their site, I don’t want those individuals to appear in the enumlist to other foreman while they are filling their report for the same day.
Why I want this:
To eliminate the possibility of a foreman making a mistake by selecting individuals who were otherwise on another site & not on his.
Thanks !

Steve

Your expression, reformatted for clarity:

COUNT(
  SPLIT(
    SELECT(
      Foreman Daily Report[Crew_On_Site],
      (
        AND(
          ([Date] <= TODAY()),
          ([ProjectID] = [_THISROW].[Job_Name])
        )
      )
    ),
    ","
  )
)

Note that the parentheses around the AND() expression are unneeded.

Try this instead:

COUNT(
  SPLIT(
    (
      ""
      & SELECT(
        Foreman Daily Report[Crew_On_Site],
        AND(
          ([Date] <= TODAY()),
          ([ProjectID] = [_THISROW].[Job_Name])
        )
      )
    ),
    " , "
  )
)

View solution in original post