A
Art
This forum has been great and I want to thank all those that have helped.
I have been tasked with designing a form for Human Resources dealing with
employee Moves, Add's and Changes.
It gets initiated by one of many people and then the routing can go to up to
7 different departments.
I have a design in my head that says when the form is initiated, store the
data in a SQL database.
As each of the 7 different departments do their thing, I want them to be
able to open a form, update their fields and re-save it for all to see their
entries.
In our current environment, the paper form gets routed in sequence to the 7
departments but that is not a necessary sequence of events. C may be able to
complete before A but B may need to wait for A.
If the initiator's form gets stored in a SP library, how can I alert the 7
departments that the form is there for them to review? Also Department B may
need to wait for Department A to finish. And when its all done, how do I flag
it as complete?
I was thinking of SQL triggers send an email that something needs to be done
but that doesn't provide a link to the form.
Plus I want to do this as much out-of-the-box as possible.
Am I crazy to think this can be done out of the box?
I have been tasked with designing a form for Human Resources dealing with
employee Moves, Add's and Changes.
It gets initiated by one of many people and then the routing can go to up to
7 different departments.
I have a design in my head that says when the form is initiated, store the
data in a SQL database.
As each of the 7 different departments do their thing, I want them to be
able to open a form, update their fields and re-save it for all to see their
entries.
In our current environment, the paper form gets routed in sequence to the 7
departments but that is not a necessary sequence of events. C may be able to
complete before A but B may need to wait for A.
If the initiator's form gets stored in a SP library, how can I alert the 7
departments that the form is there for them to review? Also Department B may
need to wait for Department A to finish. And when its all done, how do I flag
it as complete?
I was thinking of SQL triggers send an email that something needs to be done
but that doesn't provide a link to the form.
Plus I want to do this as much out-of-the-box as possible.
Am I crazy to think this can be done out of the box?