Unable to create a Unique formula with UserToEmail([Record Owner])& "-" &[Quarter]& " -" &[Type]

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Formula:

UserToEmail([Record Owner])& "-" &[Quarter]& " -" &[Type]

Sample Value: 

Sadasiva_Pandava@intuit.com-FY16Q2 (Nov,Dec,Jan)-QE

QB Link: https://intuitcorp.quickbase.com/db/bkii6n8hu

Table Name: 

Stars

Key Name: 

UK

Photo of Vijayan

Vijayan

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
Formula's can only be Unique if you use the Record ID# field as part of the formula. For what you're trying to accomplish, it sounds like you would want to have a Formula that calculated the key value and a Text field that would actually be the key field, with a Form Rule that moved the value of the Formula to the Text field when the record is saved.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
Certain field types are not allowed to be used in the formula which is being marked as Unique, [Record owner] is not allowed. If you you only want one record per quarter per person, you will need to find another method.

For example, to have the user sect their name off a drop down list.