Need help with a formula

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

Firstly I am totally new at this so need help to write a formula.

Need to create a field that has a letters and numbers that auto increment:

LDM1001, LDM1002 etc.

Text = LDM - Prefix# 100 + Record ID#

Please help. 

Thank you in advance.

Sandra

Photo of Bronwyn

Bronwyn

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
This would be a field type of formula text

"LDM100" & ToText([Record ID#])



Are you OK with that format at higher numbers.  for example where you get to 1000 records it will read LDM1001000.  is that what you want?


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
A better way to go would probably be to import a bunch of records using excel and delete them to run the number wheel up to 100.  Then just use

"LDM & ToText([Record ID#])