Skip to main content
Question

Custom Error Message According Unique Fields

  • April 3, 2017
  • 0 replies
  • 57 views
I have a table called "Clients"
In this table I have a formula field called "Validation ID" which concatenates a client's first name, last name, and phone number into a single string.
Validation ID 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 "Validation ID" 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"




_
      This topic has been closed for replies.

      No problem. Sort of. The one thing you csn control is your field name. So experiment with a longer user friendly field name such as [This client already exists]
      • DanPark1
      • Author
      • Registered
      • April 3, 2017
      My renaming the field the new message that would come up is... 

      "Fields which are marked unique must contain unique values for all the records. You have entered a duplicate value for the unique field "This Client Already Exists" Please check your data and try again.
      (The client was not saved)      "?
      • anomDiebolt
      • Registered
      • April 3, 2017
      Using the IOL technique you can modify the message to suit your needs (but I don't think this is a great idea). See screenshot of manually applying the following script:

      Pastie Database
      https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=569

      • DanPark1
      • Author
      • Registered
      • April 3, 2017
      Thanks. Why do you not think its a good idea?
      • anomDiebolt
      • Registered
      • April 3, 2017
      It works but it is a bit invasive of QuickBase's authored page (I am modifying their standard error message after the fact).

      Also, there might be other unique fields that should generate the same error message or other error messages associated with the same form submission and these possibilities would have to be explored.
      Terms & ConditionsAccessibility statement