Hello Nintex community,
I am trying to validate a form on the click of the save button, that will determine if a field in the form exists inside a column from another list.
Here is my rule: not(isNullOrEmpty(lookup("_form237", "EquipmentID", CentrifugeID, "ID")))
- EquipmentID is the column field inside the other list(_form237).
- CentrifugeID is a field used on the form that I'd like to check exists inside _forms237 list at column EquipmentID.
- ID is being used because all values have an ID column.
Am I going about this incorrectly?
Is it possible to check if a form text value is present inside of a column in another list?
Thanks for any help offered!