Can Quickbase auto-name a new entry based on the name of the previous?

  • 1
  • 1
  • Question
  • Updated 6 months ago
  • Answered
I want to make it so if someone opens a new entry they don't have to name it...I'd like it to auto generate the field with the next sequential name, i.e. "DOC-0001" is made, the next entry auto names it to "DOC-0002"
Photo of Chris S

Chris S

  • 110 Points 100 badge 2x thumb

Posted 6 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
no problem

Make a field with the formula

"DOC-
&
Right("000" & totext([Record ID#]),4)
Photo of Chris S

Chris S

  • 110 Points 100 badge 2x thumb
Thank you for the quick reply! Completely new to QB so still struggling a bit. When I use that formula I get an error that states "There are extra characters beyond the end of the formula."

Any clues? I've tried moving parentheses around, but have not had any luck...
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
sorry, my mistake

"DOC-"
&
Right("000" & totext([Record ID#]),4)
Photo of Chris S

Chris S

  • 110 Points 100 badge 2x thumb
Ah, I thought that may have been it...thank you for the support!!!