My table name is purchase_order
the column is po_no but there is option of date_time_now with intial
–“po”.datetime_now()-- it through o/p → po2023:11:00:20
then i need to customize the sequence of po_no
Like this “format - P0- 0023 (with auto increment)”
kindly anyone help me to customize the column
thanks to help
You need to add another custom field on your list product
Next up is you have to do the query
After that you may try publish the project.
Also you can check this out if what is the LPAD means
Have a nice day ^_^.
very big help to me , Thank you very much , lot of thanks