How do i generate a unique reference or file # when keying in new information into a table?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

An example would be if i was keying in a customer complaint into a table, i want a file # or reference # to auto generate and have a unique ID. this number would be used by other users to look up information on the complaint.

Photo of Talon


  • 0 Points

Posted 3 years ago

  • 0
  • 1
No problemo.

Every record saved by QuickBase has a field called [Record ID#] which is a unique number.  That is the perfect number to use!  If you like you can rename it t to be a word that makes sense in your organization. Ticket#, Complaint #, Issue# 

you will not break anything by renaming the field.  The number is assigned as soon as the record is saved.