Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am trying to autogenerate serial numbers for a form in Microsoft forms which will have multiple unique responses. Is there any way that I can autofill the serial number into the form or autogenerate it for every new entry ?

What I have tried:

The only way I have currently seen to be possible is generate the number and manually fill it into the form before asking the respondent to fill it up
Posted
Updated 23-Oct-20 6:00am

1 solution

Basically, don't.
If you've got multiple users (and your "will have multiple unique responses" implies you will) then preallocating serial numbers ia a very bad idea.

Instead, use a DB and an IDENTITY field to let the DB system allocate unique values when data is INSERTed and use that unique value afterwards to generate your serial number according to your rules for such.

Preallocating numbers leads to some really nasty intermittent problems that can take days of human intervention to tidy up when they are finally noticed weeks or months later.
 
Share this answer
 
Comments
Maanoj Kumar 24-Oct-20 0:50am    
I see. But is there a way to automatically insert a value into a online microsoft form field ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900