Hello
I have been tasked with determining a way to track bylaws. This would include assign the next bylaw number when requested by a user, update the spreadsheet with readings and resolutions.
I would to create a form that staff can do two things
- provide staff with the next number in a sequence 2020-022
- update information in the form as the bylaw passes through the process from first reading to being approved by council
-multiple staff members updating the form
if a form won't work can an excel spreadsheet be embedded into a form that would fulfill the same function