Thu, 24 Sep 2026
Login

unique columns

Confluence User - 19 Feb, 2020

Hi,

I have a form with several fields. Is it possible to have a combination of 2 fields in the form to be unique? I know I can do it directly on the database , but in this case I think I would get an error when the user tries to enter a non unique value, but in this case it should show a message(not error) to the user.


Thanks!


forms;database

3

Confluence User •
19 Feb, 2020 •
confluenceUser •
•
confluenceUser •

Maybe you can try using the Duplicate Value Validator plugin in your form.

Confluence User •
20 Feb, 2020 •
confluenceUser •
•
confluenceUser •

Yes of course, but if I use Duplicate value validator it allows me to put only one column to be unique, but I want a combination of 2 columns or form fields.

Confluence User •
20 Feb, 2020 •
confluenceUser •
•
confluenceUser •

I think you have to write your own custom plugin to perform a multi-field duplicate validator, see Developing Plugins and extend the plugin via the source code.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
How can I set dedicated datasource for each app ?
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
Issue Saving AJAX Subform Data to Datalist in Joget
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print