Skip to main content
Question

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

  • October 26, 2020
  • 0 replies
  • 39 views

Forum|alt.badge.img+8
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------