Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
5 years ago

Generate ID on Project - Can't mark as unique field?

Hey Quick Base,

So I used the below formula in a formula field on my project table called "Project name ID"

Simple formula that is working - combine the four things below to make a unique Project Name/ID -easy

[Region Name]
&"-"
& [City]
& "-"
&[Review Date]
& "-"
& [Record ID#]

the problem is when I go to check the box to make the field "must be unique" - it gives me the attached error - how do I make the field comply with this rule? the field type is just a simple Formula text field (not rich text)

Thank you,

------------------------------
Jack Woods
------------------------------
Formulas and functions
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Since your formula already contains the Record ID, it must already be unique as Record IDs are unique,  so no need to try to mark as unique.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JackWoods's avatar
      JackWoods
      Qrew Trainee
      5 years ago
      Can I use this as a Unique ID when uploading into the system?

      ------------------------------
      Jack Woods
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        I think I need the bigger picture of what you are trying to do here.  A formula field is not allowed to be the Key field of a table, if that is your question.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------