Solved: Editable_if expression based on value from another...

DPM_reports · 04-21-2020 10:07 AM

Hi,

I want to know how could to achieve the following,

I have a table where in a particular cell i want to add a editable_if expression…here i want it to be editable on when the value of another column in another table is for instance “Pending”. If its “Completed”, i want it to not be editable.

The common info for both rows in both the tables is Order No

How to do this ???

Steve

Sure! If only one user:

AND(
  (USEREMAIL() = "abc@gmail.com"),
  (
    "Completed"
    <> LOOKUP(
      [_THISROW].[Order ID],
      "Anther Table",
      "Order ID",
      "Another Column"
    )
  )
)

If more than one user:

AND(
  IN(
    USEREMAIL(),
    LIST(
      "abc@gmail.com",
      "def@gmail.com"
    )
  ),
  (
    "Completed"
    <> LOOKUP(
      [_THISROW].[Order ID],
      "Anther Table",
      "Order ID",
      "Another Column"
    )
  )
)

In both of the above, I made the assumption that you only want the column value editable if the user is one of the designated ones and the other table’s column is not Completed. If instead you want the column editable if one of the designated users or Completed, change the initial AND to OR.

See also:

DPM_reports

can i also add a particular user who can edit this like useremail()=“abc@gmail.com” to the above expression

Steve

Sure! If only one user:

AND(
  (USEREMAIL() = "abc@gmail.com"),
  (
    "Completed"
    <> LOOKUP(
      [_THISROW].[Order ID],
      "Anther Table",
      "Order ID",
      "Another Column"
    )
  )
)

If more than one user:

AND(
  IN(
    USEREMAIL(),
    LIST(
      "abc@gmail.com",
      "def@gmail.com"
    )
  ),
  (
    "Completed"
    <> LOOKUP(
      [_THISROW].[Order ID],
      "Anther Table",
      "Order ID",
      "Another Column"
    )
  )
)

In both of the above, I made the assumption that you only want the column value editable if the user is one of the designated ones and the other table’s column is not Completed. If instead you want the column editable if one of the designated users or Completed, change the initial AND to OR.

Editable_if expression based on value from another table