Skip to main content ↑ ↓
Topic: Invoice Number generation with prefix or suffix (Read 1309 times) previous topic - next topic

Invoice Number generation with prefix or suffix

i am trying to build an app the require unique invoice numbers to be generated when the record is added to the table. I have tried many methods but doesnt seem to work, any ideas?
 

Re: Invoice Number generation with prefix or suffix

Reply #2 –
Thank you for the quick response.
I used the video, was generating fine, however when you edited a record the invoice number changed.
I would like to ask whether the action before update, is it required for what I require to work flawlessly?

Apart from dynamic invoice numbers, I am trying to generate unique patient numbers formatted either ("hospital Initials".00000+Id field in patient table") or ("hospital initials"."unique numbers-auto increamented")