Update Enum column values based on a column value change

AppSheet AppSheet Q&A
1

Hi friends,

In my appsheet app ,I want to get my enum column named Ecart1 to be updated with either TypeA column values or TypeB values from “Ecart” table based on the value of Column Etat checklist in my table “checklist”.

eldderri_0-1722776750123.png
eldderri_0-1722776750123.png537×295 10.3 KB

So ,if Etat checklist = “Non Conforme” ,I want to get the values from column Type A ,table “Ecart”

and if Etat checklist = “Maintenance à programmer” ,I want to get the values from column Type B ,table “Ecart”.

How to do so?

2

Assuming the column [Ecart1] is in the “Checklist” table, in the valid_If of the [Ecart1] column, you can write an expression something like

SWITCH([Etat checklist], ““Non Conforme”, Ecart[Type A], “Maintenance à programmer” , Ecart[Type B] , LIST(”"))

3

Thank you so much.It worked!