Solved: Initial value expression - Page 2

Phong_Lam1 · 12-09-2021 07:16 AM

Hi all, in a form, I have a column [Exclusivity duration] type Enum with 3 options as below

I want to put an expression that if [status] (in the same table) = A or= B or= C than [Exclusivity duration] will be “Always”, if not , user can choose “6 months” or “No exclusivity”. I try this expression but not work

IF(OR([Status]=“A”,[Status]=“B”,[Status]=“C”),[Exclusivity duration]=“Always”,"")

Thanks

Aurelien

Hi @Phong_Lam

In the Valid_If of the column [Exclusivity duration]:

IF(
  OR([Status]="A",
    [Status]="B",
    [Status]="C"
  ),
  LIST("Always"),
  LIST("6 months","No exclusivity")
)

In the Initial_Value:

IF(
  OR([Status]="A",
    [Status]="B",
    [Status]="C"
  ),
  "Always",
  ""
)

View solution in original post