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

  • 1
  • 1
  • Question
  • Updated 1 year 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 1 year ago

  • 1
  • 1
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...
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!!!