Thu, 24 Sep 2026
Login

Duplicate Value Validator for Database

Confluence User - 21 Sep, 2016

Hi,

 

Is there any way to validate a text field to prevent the same entry from being entered into the database for the second time?

For example:

 

PO Number: ________

if PO number 123 has been previously entered, the user should get a prompt that that PO number already exists and cannot be entered again.

 

Thanks

forms;server

6

Confluence User •
21 Sep, 2016 •
confluenceUser •
1 •
confluenceUser •

Hi there,

Try this https://dev.joget.org/community/display/KBv5/Duplicate+Value+Validator

Thanks!

Confluence User •
21 Sep, 2016 •
confluenceUser •
•
confluenceUser •

I'm trying to make it check the field value in the database rather than it coming from another form.

Confluence User •
21 Sep, 2016 •
confluenceUser •
•
confluenceUser •

It'd be the same thing. Let me explain, say you have a form1 with a field with ID field1 on which you want the duplicate value validator to work. So, you'd need to configure the field1 to use a duplicate value validator configured to use the same form form1 and the same field field1. By doing this, you would create a check that once the form is submitted with value val1, the same field cannot be assigned val1 on resubmission. Let me know if you need more clarification.

Confluence User •
21 Sep, 2016 •
confluenceUser •
•
confluenceUser •

Thanks a lot for the clarification. Just tested it and it works now.

Confluence User •
21 Sep, 2016 •
confluenceUser •
•
confluenceUser •

Glad that it helped. :)

Confluence User •
18 Mar, 2019 •
confluenceUser •
•
confluenceUser •

okay how about if this in different table ? how can i use this validator Ashutosh Tripathi ?

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
i am building an app, and for some reason i am not able to open it anymore. All apps --> my app --> system error
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print