Text combo field does not accept unique nature. This will give different combo to filter in the related records

Hi 8933998927, this sounds very interesting. Did it work for you? If yes, can you please share the code you usedd?

I see this is from 2016 but it would still be useful for us as well.

A little late to this conversation, but in case others are looking for a solution to this (as I am now), I'm thinking of doing the following: Create the text formula field on your object to combine multiple fields. In my case it will be a product code and language. Use custom JS on the input form,…

Yep, this feature we be really good.

I have a need for similar functionality. We track three fields, keyword, city & state. The combo of the three fields needs to be unique and I haven't been able to figure out how to make that happen in Knack.

I agree this would be very helpful.

Tried similar but it is not working. Just guessing, but appears that the populating condition must fire after the record is written, meaning the field is still null when written to db thus falling through the uniqueness check. I can write duplicate records all day with this set up, unfortunately. …

I ended up solving this with an extra field. Fields: Part Number Short Text Customer Short Text Combo Text Formula {Part Number}:{Customer} Unique Short Text Conditional Rule set to just make Unique = Combo. Then set this to Must be Unique. …

Yes, this would solve the Unique on only 1 field issue.

This would be a helpful feature. An example is I would like thePart Number and Customer combo to be unique. I can have the same part number but never the same part and customer. Not sure how to handle this, as it is a big problem if there are 2 in the system.

Text combo field as a unique

Feature Requests

Sunny_Singla October 9, 2022, 8:45am 14

check there

Topic		Replies	Views
Combine fields to make a unique record Get Answers	18	1318	November 10, 2022
Enforce Uniqueness/Prevent Duplicates Get Answers	1	477	April 7, 2020
Preventing Duplicates (Uniqueness) on Combined Fields in an Object Get Answers	44	3667	April 24, 2025
Duplicate Records Checker Get Answers	6	934	February 10, 2023
Applying the Unique Value Rule to a Text Formula Field Feature Requests	2	641	March 10, 2022

Text combo field as a unique

Related topics