Asked by:
Hide / show columns with conditioned options (yes/ no)

Question
-
Hi there,
I have created a form with 14 colums. Out of which last 3 columns needs to show up only column 11 is yes; or else I like those to be hidden.
It would be great if I can get through it with conditional formatting in colums with calculated formula conditioning
Thanks
DMlv
- Edited by Lavish0610 Wednesday, March 19, 2014 6:45 PM
Wednesday, March 19, 2014 6:36 PM
All replies
-
Hi DMlv,
Do you mean you've created a "View" with 14 columns? If that is correct, then there's no way to conditionally hide View columns based on a particular column value.
Think of a situation where you have 20 records and 10 of them qualify for the last 3 columns to be shown while the others don't. How to plan to show them altogether then? This is the reason why it's not available.
What you could do, is design two separate Views, apply filter criteria for column 11 value and have the last 3 columns displayed/not displayed in those separate views accordingly.
Wednesday, March 19, 2014 7:04 PM -
If you have information that is not relevant for all records you could add this information to the name field to allow visibility in the list view without having lots of additional columns.
Using N52's formula manager would allow you to create a calculated name field that includes the optional information - http://support.north52.com/
Hope this helps,
Scott Durow
Blog www.develop1.netFollow Me
Rockstar365
If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"- Proposed as answer by Scott Durow (MVP)MVP, Editor Wednesday, March 19, 2014 9:05 PM
Wednesday, March 19, 2014 9:05 PMAnswerer -
Hi there,
I think I should have been much clearer in my question.
The condition I'm looking for in a new form display {NewForm.aspx) not in the views.
Hoping I could hide the remaing 3 questions [columns] based on the response on the 11th conditioned question [or 11th column] and continue to finish the rest without going for a whole new different form and all the datas can be stored in the same library and we can sort and filter to show up in different views.
Guessing I have explained much better now and will have some solid way to go through it.
Thanks
DMlv
Thursday, March 20, 2014 8:04 PM -
It seems you are created survey like form.
and want to hide/show fields based on answer other question.
To do so make use javascript or bussiness rule in crm 2013.
Hope this helps. ----------------------------------------------------------------------- Santosh Bhagat If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"
- Proposed as answer by Mr. Santosh Bhagat Friday, March 21, 2014 5:14 AM
Friday, March 21, 2014 5:14 AM -
Hi Lavish,
You have to use Javascript for CRM 2011. For it you are refer to this blog post.
And If you've to do it in CRM 2013 you must go for business rules. for this you are referred to this blog post.
Friday, March 21, 2014 6:16 AM