How can I create a field to automatically insert a project ID number (sequence) to each project as they are added?

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
Photo of Emerson

Emerson

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
I suggest that you just use the Record ID# of the Project as it's sequence number.
Photo of Chris Smith

Chris Smith

  • 60 Points

What if you want to concatenate additional text onto the record ID.  It won't let you do that


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
No problem. Just make a new formula Text field to do that. The Key field will still be the [Record Id#] field, but you can use the other field wherever you like.
Photo of Blanca

Blanca

  • 258 Points 250 badge 2x thumb
What would this formula look like if I wanted the new record ID to be the first letter of a field plus the record ID? TIA
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
It would be a formula text field like

Left([Project Name],1) & ToText([Record ID#])
Photo of Blanca

Blanca

  • 258 Points 250 badge 2x thumb
Thank you!
Photo of Emerson

Emerson

  • 0 Points
Thank you!