Check conditions

[Excelaser_Gmbh]

Hello,

I want to check if the scaned “labelnumber” already existing in table “receiving” column “labelnumber” and the column “material movement type” in table “receiving” in the same row than the labelnumber is out. If both is true the data is valid.

Please can you help me?

Thank you in advance,
Kai

[WillowMobileSys]

You don’t mention WHEN/WHERE you want to check if valid. Since you said LabelNumber already exists, I’ll assume it is upon updating the Material Movement Type column to “Out”.

So, in the Material Movement Type Column:

Valid_IF = AND(ISNOTBLANK([LabelNumber]), [Material Movement Type] = “Out”)