Skip to main content
Question

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

  • June 1, 2018
  • 0 replies
  • 12 views
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
    This topic has been closed for replies.

    no problem

    Make a field with the formula

    "DOC-
    &
    Right("000" & totext([Record ID#]),4)
    • ChrisS
    • Author
    • Registered
    • June 1, 2018
    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)
    • ChrisS
    • Author
    • Registered
    • June 1, 2018
    Ah, I thought that may have been it...thank you for the support!!!
    Terms & ConditionsAccessibility statement