Hey all, I’m working on a basic cad system for our EMS agency. I have a basic system in place importing calls via an email parser, however I’m a little stumped on generating incremental CAD numbers for each incident. We format our CAD numbers in the format of 2023-xxxx. I’d like to be able to start…

I would store the Year (as a number) and ID separately and display them together. When you create a new incident ID, you want to do a search for Incidents CAD YEAR filtered by current year, sort by CAD ID Ascending First Item, then add 1 . Create your seed CAD incident with the 2023-3205 ID and crea…

@nfisher nice solution! Can you improve on it to prevent (or repair) duplicate IDs being created by different users at almost the same time? (Assuming duplicates are undesirable in this app)

Could be of interest here… [image] How to achieve Unique, Sequential Numbers Reliably? Database boom A WORD OF WARNING THAT SOME OF THE SOLUTIONS PEOPLE OFFERED ABOVE ARE NOT RELIABLE AND YOU MAY, IN FACT, GET DUPLICATES OR WORSE UNLESS YOU USE THE FOLLOWING METHOD AS - I…

Creating a CAD system for EMS agency; sequential CAD number solution?

Questions

mikeloc August 28, 2023, 12:06am 4

Could be of interest here…

Topic		Replies	Views
Unique ID generation going wrong Database	3	75	January 10, 2025
Create New Order ID Need help	5	783	June 22, 2023
How to achieve Unique, Sequential Numbers Reliably? Database	92	19043	February 18, 2024
How to generate sequential numbers for each new record in the database? Need help	3	427	March 25, 2024
How can I generate an exact sequential number with consistency when many users request at the same time? Questions	0	244	July 29, 2021

Creating a CAD system for EMS agency; sequential CAD number solution?

Related topics