Validation, if record already exists?

[Former Member]

Hello,

is it possible to use a validation to check if a record already exists?

Best Regards

Olof

[Former Member]

Hi,

You can simply make the Product Number as a Unique field by setting the unique = true for the field product number. Whenever the new record gets created or imported with the existing product number, it will throw an error (unique constraint violated).

We cannot achieve this using Validation expressions since we cannot loop into the records.

Regards,

Jitesh Talreja

[Former Member]

Hi Jitesh,

thanks for the answer.

Regards

Olof

[Former Member]

Hi Olof,

maybe that helps you: When you create a record, launch a workflow with a matching step (wf against all) on product number. If the record exists, you can rollback the record (check-out upon launch of workflow) or merge and check-in.

Best regards

Christian

[Former Member]

To clarify,

Let's say I want to know if the product number of the records already exist.

/ Olof