Solved

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

Posted on 2011-02-15
5
830 Views
Last Modified: 2012-05-11
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
Comment
Question by:mylogo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34898979
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
 

Author Comment

by:mylogo
ID: 34900200
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
 
LVL 11

Expert Comment

by:FastFngrz
ID: 34902715
1 word-InfoPath!
0
 
LVL 43

Accepted Solution

by:
zephyr_hex (Megan) earned 500 total points
ID: 34908072
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
 

Author Comment

by:mylogo
ID: 34912187
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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question