Composite Index for Quick Base Table
Hello, I have a table named Certifications which has 2 parent tables: Publishers and Formats. I need to ensure there are no duplicate combinations between publishers and formats. So what I tried wa...
Forum Discussion
Are you using a formula rich text or formula text? Is it giving you an error? Do you see the checkbox Must be unique and does it check your existing entries, maybe you have some duplicates in the mix already?
It should work just fine on a formula text field.
------------------------------
Everett Patterson
------------------------------
It should work just fine on a formula text field.
------------------------------
Everett Patterson
------------------------------
I am using formula - text. I do see the checkbox. I do already have one duplicate.
I thought checking "check for duplicates" would take care of that, but instead the specific message I get is:
------------------------------
Rachel Rachel
------------------------------
I thought checking "check for duplicates" would take care of that, but instead the specific message I get is:
------------------------------
Rachel Rachel
------------------------------
- Update: I deleted the duplicate record and I still get the error.
------------------------------
Rachel Rachel
------------------------------- MarkShnier__You
Qrew Legend
Are either of those two fields actually lookup fields?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- Why, yes, now that you mention it! It looks like Related Ad Format was a lookup field. We had changed the key field for that table.
I changed my formula to reference the key field instead, and now it works! Thank you!
------------------------------
Rachel Rachel
------------------------------
