Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 849
  • 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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