Discussions

Expand all | Collapse all

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

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

     
    Posted 05-31-2018 23:38
    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


  • 2.  RE: Can Quickbase auto-name a new entry based on the name of the previous?

    Posted 05-31-2018 23:56
    no problem

    Make a field with the formula

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


  • 3.  RE: Can Quickbase auto-name a new entry based on the name of the previous?

     
    Posted 06-01-2018 00:13
    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...


  • 4.  RE: Can Quickbase auto-name a new entry based on the name of the previous?

    Posted 06-01-2018 00:17
    sorry, my mistake

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


  • 5.  RE: Can Quickbase auto-name a new entry based on the name of the previous?

     
    Posted 06-01-2018 00:22
    Ah, I thought that may have been it...thank you for the support!!!