Solved: App expression for [survey_status] not working as ... - Page 2

Jake_Naude · 06-29-2020 03:08 PM

Evening all,

I have an app expression in [survey_status] to force an “Abort” status in certain “No” states.

The Expression Assistant tests as OK but only the “Abort” part of it works in the form.

And, in an “Else” state all of the status buttons are missing in the form.

Any pointers please?

IF(
OR(
[Enough_Space_For_Cabinet]=“No”,
[Enough_Space_For_HPR]=“No”,
[DB_Q1]=“No”,
[FOSE_Q1]=“No”,
[LPR_Q1]=“No”,
[Jum_Con_Q1]=“No”,
[Enough_Space_For_Cable]=“No”
),
“Aborted”,
SPLIT(
LIST(“Completed”, “In Progress”, “On Hold”, “Aborted”),
“,”
)
)

Steve

Set Editable? to:

NOT(
  AND(
    OR(
      [DB_Q1] = “No”,
      [Enough_Space_For_Cabinet] = “No”,
      [Enough_Space_For_Cable] = “No”,
      [Enough_Space_For_HPR] = “No”,
      [FOSE_Q1] = “No”,
      [LPR_Q1] = “No”,
      [Jum_Con_Q1] = “No”
    ),
    [Survey Status?] = "Aborted"
  )
)

View solution in original post

App expression for [survey_status] not working as expected