I want to generate serial numbers like PP0012020, PP0022020, PP0032020 and store them on the database. Must know The serial number will change year-wise like for the year 2020 the serial number will be like PP0012020, PP0022020, PP0032020. But, For the year 2021, the serial number will be like P…

Like this. [image] sorry, there is a mistake in the picture. "PP = CONSTANT’’

How to generate serial numbers and store the same in database?

npvelokarthi December 22, 2021, 6:03am 5

how generate alphanumeric random number

Topic		Replies	Views
can we Customize wix database unique id ccc629b6-461b-4be7-96d5- to 657-123-564 Ask the community code , question	1	121	November 20, 2019
generated contract number Ask the community code , question	1	92	July 15, 2018
How to create serial nos in db, before insert. Can you help me with hooks? Ask the community code , question	0	61	May 31, 2021
Auto Update Serial Number in Database Ask the community code , wix-stores , question	0	218	October 9, 2020
Wix Exp-How to generate the Random Alphabet on Wix database Ask the community code , question	4	715	April 8, 2018