asked on

Display group of fields when option chosen on New form in SharePoint 2007

I have a basic Add, Transfer, Delete employee custom list in SharePoint. HR wants to be able to have available the group of 5 Transfer fields that would be triggered when "Transfer Service" option is chosen from the Request Status choice field.
Can this be done where a group of fields are made visible?

zephyr_hex (Megan)

are you asking for how to do a cascading drop down?
http://www.wareprise.com/2009/08/05/how-to-create-a-cascading-drop-down-list-in-sharepoint/

if that's not what you're looking for, please give an example in order to further describe what you need
(i.e. user selects a value from such and such a place, and then XYZ happens)

mylogo

ASKER

I've never tried a cascading drop down but when reading about it, it looks like it might work but just not sure if it can bring in all my fields. Looks to me like it'd be linking to another list?
I've attached a couple of screenshots of what I need to accomplish from the New form. Service type has 3 options: New Service, Delete Service and Transfer Service. By default, I have the transfer fields hidden when opening a New form. However, if "Transfer Service" is chosen, I need the form to display those transfer fields which are prefaced with "New" like: New Department, New Job Title, etc...
Trying to keep the custom list as simple as possible.
New-Service-Form.docx

Daryl Sirota

1 word-InfoPath!

ASKER CERTIFIED SOLUTION

zephyr_hex (Megan)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mylogo

ASKER

Thank you. I agree with FastFngrz in using InfoPath but that wasn't an option for this very quick and dirty project. Was supposed to be a very (VERY) simple list. Of course, now that they've seen what SP can do for them, it's grown. InfoPath will most likely be the Phase 2 of this but for now, i think the custom solution might work.
Thank you for your help.