I have a unique field that contains letters and numbers. How do I set up an error message - warning, so that an entry is not duplicated?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Photo of Noel

Noel

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
The only way really is to use the Field Property setting to flag the field as being Unique.  Then the record will not be allowed to save.  Its not clear from your post if this is a data entry field or a text formula field.  If the latter, certain field types may not be used in the formula, especially lookup fields and formulas involving the Today() function.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb