I work for the HR department for my local city. Currently, we use a personnel action form to document new hires, pay changes, terminations, etc......
As of right now, everything is printed off and handwritten.
For the process of the document:
An administrative assistant completes the document, takes it to their department head for signature, and then, it is sent to us (HR) for final signature. We then store the document in the employee's personnel action form.
I am wanting to simplify/digitize the process.
What am I am wanting to do, if possible:
Add a drop-down list for the admin to choose their department (I know how to do this).
Add a second drop-down list where the form has asked for the grade and pay of the employee.
Based on what they choose the drop-down selection, I would like it to give the grade and pay options based on the department.
Again, based on the first drop-down, I would like to add a submit button that send's the form to the department head based on the selected department.
The department head could add his electric signature.
There would then be a "submit to HR" button, where it would be emailed to my boss and me.
I've attached the document we use for reference.