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

- John_Halls
- 1 yr ago
- Reported - view
Hi Chris

Is this a number or a text field?

Regards John
- Chris
  
  1 yr ago
  
  Reported - view
  John Halls Hi John, it is a number field.
- Fred
- 1 yr ago
- Reported - view
Here is a good post on auto numbering.
- Mel_Charles
- 1 yr 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
- 1 yr ago
- Reported - view
Thank you very much Mel. : it works perfectly!

Content aside