How Do I Validate a Composite Key Before the Submit is Executed?

[Kathleen Janiszewski]

I've create a ConfiForm Rule fore Field Definition.  I've already created a composite key called "uniqueId" which consists of CONCAT("[entry.recordOwner]","[entry.userType]").

When I try to "Validate uniqueness" on this field, it will give an error message if the recordOwner (userId) is in there.  It seems to not make any distinction for the composite key.

I need this because each user can have an entry of each of 2 types.

What am I doing incorrectly?

[Alex Medved _ConfiForms_]

Hi @Kathleen Janiszewski 

The parameter "Field names to be used to construct unique key" expects a comma separated list of field names (you must be using some old version of ConfiForms where the description of the field was still missing - sorry about that)

So just put

recordOwner,userType

No need for any extra field or any other parameters in this macro

Alex

[Kathleen Janiszewski]

Alex,

Thank you for your reply.  It turned out not to be this complicated.  I only needed a Validation Rule of [unique] on my field, uniqueId.

Thank you.

-Kathleen

[Alex Medved _ConfiForms_]

That is an alternative way of doing this, but the Validate uniqueness rule is even easier in my opinion... but that is for you to decide and pick what is best for you