Project Number Autofill

I want to create a form so that when someone adds a new project it will autofill the project number field with the next number from a list. The project number format is 22-XXX. Where XXX starts at 001 and keeps going. The numbers can’t repeat and only the next available number can be used. How would I go about doing this?

Have a look here…

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Generating-Sequential-Numbering-Using-App-Script-Tasks/td-p/451776

1 Like