Solved: Edit if not working with context function - Page 2

Henrique_Vieir2 · 09-30-2021 06:14 PM

In a column I put an expression in the edit if (if the column is filled, it is not possible to edit). Now I want this rule to be ignored if the person is in a specific view (edit form system view). I tried a simple if (if CONTEXT returns the system view, edit if = true). It just doesn’t work, has anyone ever done something like that?

Expression before: ISBLANK([_THISROW_BEFORE].[Date])

I tried: IF(IN(View name, CONTEXT(“View”), TRUE, ISBLANK([_THISROW_BEFORE].[Date])) and also IF(CONTEXT(“View”) = View name, TRUE, ISBLANK([_THISROW_BEFORE].[Date]))

Marc_Dillon

IN() is for comparing a single item to a List of items.

This expression should be working for the situation you described. The following expression is also equivalent:

OR(
  CONTEXT("View") = x ,
  ISBLANK(...)
)

View solution in original post