Select from a list conditioned by a select

Luis_Gomes_Mac1 · 02-03-2020 09:46 AM

I need help with the following expression:

I have a table of contacts which column B is a enum with 2 possible choices (Client and Employee) and Column D = to list of companies which is a REF to another table (where our company “Ecolgroup” is also listed).
I would like that one someone is editing or inserting a new contact and select “Employee” as the enum choice of column B, our company is automatically selected for column D.
How should I write the expression and where?

thanx

Steve

For the Valid if expression for the Column D column, try:

IF(
  ("Employee" = [Column B]),
  LIST("Ecolgroup"),
  ref-table[key-column]
)

replacing ref-table with the name of the the other table containing the list of companies, and key-column with the name of the key column in that other table.

Then, set the Initial value expression for that same column to:

IFS(
  ("Employee" = [Column B]),
    "Ecolgroup"
)