Forum Discussion

EmersonEmerson's avatar
EmersonEmerson
Qrew Member
9 years ago

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

Tables and fields

7 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    I suggest that you just use the Record ID# of the Project as it's sequence number.
    • ChristopherSmi1's avatar
      ChristopherSmi1
      Qrew Member
      7 years ago

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


    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      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.
    • BlancaAnderson's avatar
      BlancaAnderson
      Qrew Assistant Captain
      6 years ago
      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