Thu, 24 Sep 2026
Login

Multiple Field Unique Values

Confluence User - 20 Jul, 2015

Hi,

 

Is there a way to prevent insertion of values with unique constraints.

as an example i have 2 fields name and location

and name = abc location = test already exist

it should prevent insertion of name=abc location=test if inserted again, but should allow if any of the field value is different.

I have tried to achieve it using database unique constraint but that shows unfriendly message at user end.

 

Thanks in advance for your help.

forms

2

Confluence User •
24 Jul, 2015 •
confluenceUser •
•
confluenceUser •

Hi Jahan,

we have some thought.
in the past to solve this, i've made two form with different table name..
first form for field name and location in table A.
second form for the other field in table B.

so, id (primary key) in table A will become foreign key in table B (make some column).

That's it.

any other solution?

Confluence User •
27 Jul, 2015 •
confluenceUser •
1 •
confluenceUser •

Actually it won't work in my case as i have composite key.

The solution i have adopted was added a unique constraint on DB side; when some one tries to insert duplicate row; joget show some weird duplicate message, so using Jquery i changed that message to my own needed one.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print