0

automatic numbering using any number column.

Hi, I have a column with unordered and null numbers/figures.

I would like to add the highest + 1 in a new record... How do I do that ?

 

Thank you

5 replies

null
    • John_Halls
    • 2 yrs ago
    • Reported - view

    Hi Chris

    Is this a number or a text field?

    Regards John

      • Chris
      • 2 yrs ago
      • Reported - view

      John Halls Hi John, it is a number field.

    • Fred
    • 2 yrs ago
    • Reported - view

    Here is a good post on auto numbering.

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    here is my script that I put into the form (trigger on new record) to ad the next higher number for my job dockets...

    let before := max((select JobDockets).'Job Bag');
    'Job Bag' := before + 1

    • Chris
    • 2 yrs ago
    • Reported - view

    Thank you very much Mel. : it works perfectly!

Login to reply

Content aside

  • 2 yrs agoLast active
  • 5Replies
  • 112Views
  • 4 Following