I have a single library to upload documents to. All the documents need a Department, Group, Category and Type field selected. However, based on the Category, there are other fields that need to be filled out (or omitted). I would like for those fields
that are to be omitted to not show up as a drop down.
Using SPServices, there are lists setup so when you select a department, only those groups associated with that department show up. The same is setup for category's and type's.
Department | Group | Category | Type | Month | Year | Owner
Dep 1 | Grp 1 | Report | Report 1 | Jan | 2013 |
Dep 1 | Grp 1 | Report | Report 2 | Jan | 2013 |
Dep 2 | Grp 3 | Report | Report 1 | Feb | 2013 |
Dep 2 | Grp 3 | Report | Report 2 | Feb | 2013 |
Dep 1 | Grp 2 | Documentation | Doc 1 | | | Columbus
Dep 1 | Grp 2 | Documentation | Doc 2 | | | Genghis
Dep 1 | Grp 2 | Documentation | Doc 2 | | | Sheldon
Select department and associating group then select Report, Report 1, and be prompted to select a month and year. Owner will be omitted or hidden from selection view.
Select department and associating group then select documentation and doc 1, and be prompted to select an owner. Month and Year should be omitted or hidden from selection view.
I would appreciate any direction or advice on how to make this happen?