In this video, we revisit and improve our Google Apps Script for automatic serial number generation in Google Sheets! If you watched the previous tutorial, you'll know we generated sequential codes every time a new name was added, but there were some issues when the list was unordered or when editing and deleting names. Today, we fix these limitations:
- Ensure serial numbers are always unique and sequential, regardless of order
- Prevent number changes when editing existing names
- Handle deletions correctly
You'll learn how to transform arrays, use the map function, and apply Math.max for robust serial generation. Perfect for case tracking, sales, or any scenario needing unique codes!
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
https://practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: https://practicalsheets.com/patreon
➤Webpage: https://practicalsheets.com
➤Newsletter: https://practicalsheets.com/newsletter
➤Telegram: https://practicalsheets.com/telegram
➤Facebook: https://practicalsheets.com/facebook
➤Twitter: https://practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
