Incremental numbers (with letters)

Tap Forms Database Pro for Mac, iPhone, iPad and Apple Watch › Forums › Using Tap Forms 5 › Incremental numbers (with letters)

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
  • November 10, 2015 at 4:33 PM #15169

    Robert Strange
    Participant

    Hi Brendan –

    I know it’s possible to have numbers auto-increment, but is it possible to have a combination of letters and numbers auto-increment?

    I have imported a list of jobs into a form, and each job is numbered e.g. JN-1501, JN-1502, JN-1503, etc etc etc. When I add a new job I would like the job number to be the previous job number +1.

    Any ideas?

    Thanks,
    Rob

    November 11, 2015 at 6:16 PM #15173

    Brendan
    Keymaster

    The only way I could think of doing it would be to tie a Calculation field in with your auto-incrementing Number field into a formula. Something like this:

    “JN-” + [Job Number]

    Make sure that the Return Type is set to Text on the Formula.

    Thanks!

    Brendan

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.