Dictionary unique items

0

Hi Andree,

I would either do it directly in Excel or add a check whenever an instance is saved/the save path is executed.

The validate form action would be something like this:

select
case
when (Select Count(*) from WFElements where WFD_DTYPEID = XYZ and WFD_ID <> CurrentInstanceId and WFD_AttText1 = 'FormValue') = 0 then 1
else 0 end as ValueIsUnique

This would cause an error during the import or whenever the unique value stored in AttText1 would be used by another workflow instance using the same document type.

Best regards,
Daniel