0

Automatic incremental numbers (modifiable)

Hi,
How to auto-complete a field on a newly created record with a number incrementaly +1 than the previous record (starting on 1), but still bee able to modify it manually later ?

Looking forward to hear from you,  Thanks in advance.

Regards,

3 replies

null
    • Mel_Charles
    • 7 mths ago
    • Reported - view

    In edit mode of the table form

    put in the trigger on new record section

    this script 

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

     

    change jobdockets for the name of your table

    and 'Job Bag' for the name of your number field

    • Mel_Charles
    • 7 mths ago
    • Reported - view

    I would also advise you to put the number field say on another tab on the form and have a formula field on the front form to point to it for reading purposes. That way you might not accidentally catch the number and change it, but you can go back to the tabbed field and alter as required.

    Or have the field lock and then use a button or yes no/field to unlock it.

    there are several options 

      • Julien.1
      • 7 mths ago
      • Reported - view

       Thanks for all these advices 🙏

Login to reply

Content aside

  • 7 mths agoLast active
  • 3Replies
  • 66Views
  • 2 Following