Hi there. I am trying to figure out how to prevent a user from entering duplicate records in an object defined by combined unique fields. For example, The "join" object is called SHOWS-TALENT: - connection to shows - connection to talent The uniqueness I need to create is the combinations of SHOW…

I also need help with making a combined field unique.

I also need a way to do something similar. I don't see a reason why many fields can't be set as "Must be unique"

I just posted a request for this exact same thing!

I too have a similar but simpler issue. I have a Products table with fields for Name and Version. The combination of these two fields needs to be unique but I cannot figure out how to set this up. Thanks for any help. Gordon

I have a similar issue. I thought I had the answer by attempting to use the Text Formula field, however, the Text Formula field is absent the "Must be Unique" Flag, as well as any advanced settings to set validations. Thank you, Jason

Exactly same issue here!!! We need to solve this as well. We have users entering dates (appointments) in a calendar which should not be duplicated.

I added one more nested If Else so that you can have 3 scenarios. I needed the ability to warn of duplicates but still allow for it if necessary. I removed the message on the Submit rule and instead added a custom message if the function comes back with just one record meaning there was no duplicat…

Really disappointed to find out that the one to one relationships don’t actually work like that. Isn’t this a really basic feature of a database?

Hi @Marlene - you could adapt the Integromat process described in my blog article: [image] Knack Multi-Field Uniqueness with Integromat A question asked often in the Knack forums and elsewhere is how to prevent a user from booking onto the same course twice - or in the case of the examp…

I also need help with making a combined field unique.

Preventing Duplicates (Uniqueness) on Combined Fields in an Object

Ask the Community Get Answers

AndrewBang54366 April 24, 2025, 1:44pm 45

I posted a JS solution to this issue here

Topic		Replies	Views
Multi Field uniqueness validation with Integromat Show & Tell	1	562	November 16, 2021
Preventing Duplicates in Combined Fields (Many-to-Many Records) Using JavaScript (Solved) Show & Tell	1	122	April 24, 2025
Duplicate Records Checker Get Answers	6	927	February 10, 2023
Add new data access level to Knack App Get Answers	4	677	November 23, 2021
Duplicate records Get Answers	6	1341	February 21, 2023

Preventing Duplicates (Uniqueness) on Combined Fields in an Object

Related topics