Solved: Expression to set column or list all

Jerry_Hill · 12-09-2020 10:13 AM

How should I form an expression in an App Formula to set the value of a dropdown (ref) list based on the value of another column AND if the value does not match then list all of the values in the drop down. This expression works, with one problem I’d like to solve:

IF([TranType]=“TRANSFER”,“Cash Transfer” ,Items[Name])

This is set in the App Formula of the “Item” column, which is a dropdrown ref containing the list of values from the Items table. If the TranType column = “TRANSFER” set this col to “Cash Transfer” else List the Names from the Items table.

The problem is that it just sets the Item column to all of the values in a comma delimited list, instead of a dropdown format. Any help will be greatly appreciated by this newby.

Steve

Set Valid If to:

IF(
  ("TRANSFER" = [TranType]),
  LIST("Cash Transfer"),
  Items[Name]
)

Then set Initial value to:

IFS(
  ("TRANSFER" = [TranType]),
    "Cash Transfer"
)

Optionally set Editable? to:

("TRANSFER" <> [TranType])

See also:

View solution in original post

Steve

Set Valid If to:

IF(
  ("TRANSFER" = [TranType]),
  LIST("Cash Transfer"),
  Items[Name]
)

Then set Initial value to:

IFS(
  ("TRANSFER" = [TranType]),
    "Cash Transfer"
)

Optionally set Editable? to:

("TRANSFER" <> [TranType])