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
-
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 + 1change jobdockets for the name of your table
and 'Job Bag' for the name of your number field
-
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
-
Thanks for all these advices
-
Content aside
- 1 yr agoLast active
- 3Replies
- 98Views
-
2
Following