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 Projec...
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
      ------------------------------