Unique Identifier on Multiple Fields
Hi, Is there a way to set up your Unique Identifier (key) based on multiple field combination? i.e., If I have fields User and Date, I want to restrict to have a specific user on a specific date only once. Same user should only have one record with same date in that table. In most databases, that's pretty much standard feature to define your own Key based on combination of fields, but could not figure out how to handle this in QB. Any thoughts? Thanks in advance. ------------------------------ Muhammad Ghazali ------------------------------5Views1like1CommentCustom Error Message For Unique Formula Fields
I have a table called Clients. In this table I have a formula field called Unique Identifier which concatenates a client's first name, last name, and email into a single string. Unique Identifier is also a unique field to prevent duplicate Client entries into the system. When I try to save a duplicate client record a Quickbase message pops up saying "Fields which are marked unique must contain unique values for all the records. You have entered a duplicate value for the unique field "Unique Identifier" Please check your data and try again. (The client was not saved)_" Is there a way to modify/customize this message? I would like for it to say something like "This Client Already Exists" ------------------------------ Abhishek Kumar ------------------------------30Views1like0Comments