• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 851
  • Last Modified:

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?
0
mylogo
Asked:
mylogo
  • 2
  • 2
1 Solution
 
zephyr_hex (Megan)DeveloperCommented:
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)
0
 
mylogoAuthor Commented:
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
0
 
FastFngrzCommented:
1 word-InfoPath!
0
 
zephyr_hex (Megan)DeveloperCommented:
from what you have in your .docx, you are not looking for cascading drop downs.  cascading drop downs are when you select an item in one drop down, it determines the options in a second drop down.

in your case, you want certain fields to show on a form when a particular option is selected from a drop down.

FastFngrz is right... Infopath is probably your easiest option here, perhaps with conditional formatting to show or hide fields.

if you don't have Infopath, you could create a custom solution using something similar to this:
http://sharepointjavascript.wordpress.com/2009/09/10/dynamic-expandcollapse-fields-or-array-of-fields/

or these:
http://sharepointgypsy.blogspot.com/2010/12/sharepoint-dynamic-field-hide-or-reveal.html

http://www.codeproject.com/KB/sharepoint/SharepointMultipleForm.aspx
0
 
mylogoAuthor Commented:
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.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now