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
- 
  
Hi Chris
Is this a number or a text field?
Regards John
 - 
  
Here is a good post on auto numbering.
 - 
  
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 - 
  
Thank you very much Mel. : it works perfectly!
 
Content aside
- 3 yrs agoLast active
 - 5Replies
 - 146Views
 - 
    4
    Following
    
 
