Hide Calculated columns from a list's New/Edit form?

2014-10-30

Question

_{Thursday, October 30, 2014 6:03 PM}

So our list has a number of columns that are used in the 'background' and shouldn't be visible to users on the Add or Edit form. No problem, right? Just enable Content Types and then go into the column properties to set them to Hidden.

Except....

Some of these columns are of the Calculated type, and the visibility options are grayed out for those.

We definitely don't want to be showing these calculation columns to users; and we do NOT have access to SharePoint Designer. (I'm a site owner, not a site-collection admin.)

I don't honestly expect there to be any simple way to set these columns to hidden, but I'd like to know if there's a reason that Calculated columns are singled out to be always visible, when that column type is actually MOST likely to be set up for background-only use.

All replies (15)

_{Friday, October 31, 2014 4:21 PM ✅Answered}

I've gone through the permissions here and it seems so. Can you ask the site collection admin?

http://technet.microsoft.com/en-gb/library/ee721992(v=office.14).aspx

Steven Andrews
SharePoint Business Analyst: LiveNation Entertainment
Blog: baron72.wordpress.com
Twitter: Follow @backpackerd00d
My Wiki Articles: CodePlex Corner Series
Please remember to mark your question as "answered" if this solves (or helps) your problem.

_{Sunday, November 2, 2014 4:43 PM ✅Answered}

Hi,

Open the "Default View" page in edit mode.

Add the Content Editor WebPart and refer the .javascript file inside content link property.

In javascript find the "Calculated Column's row id using IE Developer tool and hide through javascript.

may be this line could do the trick

document.getElementById("calculatedColumnRowId").style.display="none"

Murugesa Pandian.,SharePoint 2010 | MCPD | MCTS - Configure

_{Monday, November 3, 2014 4:06 AM ✅Answered}

Hello Calybos,

Please use below mentioned powershell to hide the column from required view:

$list = (Get-SPWeb "http://siteurl").Lists |? {$_.Title -eq "ListName"}

$field = $list.Fields["Reply"]

$field.ShowInNewForm = $false

$field.Update()

This will hide specific column from New from display. Use the same to hide from Edit and display form page.

$field.ShowInEditForm = $false

$field.ShowInDisplayForm = $false

*********************************************************************************

$list = (Get-SPWeb "http://yoursite").Lists |? {$_.Title -eq "yourlist"}

$field = $list.Fields["yourfield"]

$field.ShowInNewForm = $false

$field.ShowInEditForm = $false

$field.ShowInDisplayForm = $false

$field.Update()

Thank You, Pallav S. Srivastav If this helped you resolve your issue, please mark it Answered.

_{Thursday, October 30, 2014 6:22 PM}

Well, I'm confused. Because they don't show up. Do you have a capture of the Form ? What else has been configured on those Content Types ?

_{Thursday, October 30, 2014 6:24 PM}

Hi Calybos,

Please browse the below Blog It also has the same issue

https://social.technet.microsoft.com/Forums/sharepoint/en-US/5244fab7-ef46-4d29-9d6a-83dd792248bb/unable-to-set-column-settings-of-yesno-check-box-values-required-optional-hidden-of-content?forum=sharepointadminprevious

Thanks and Regards Rahul Dagar

_{Thursday, October 30, 2014 6:58 PM}

The blog article is interesting, but none of its workarounds will work for me. The columns must remain as Calculated (that's why we created them), and PowerShell isn't available to us. And of course, the "workspace" solution isn't an option because we can't use SP Designer.

_{Thursday, October 30, 2014 8:21 PM}

Every SharePoint column has some hidden properties, a few of which can help here. I'm thinking of

Hidden: This sets whether a field can be displayed in the list
Read Only: This controls whether a field can be modified by the users
Show in Display Form: This controls if a field is displayed in the DisplayForm.aspx
Show in Edit Form: This controls whether a field is displayed in the EditForm.aspx
Show in New Form: This controls whether a field is displayed in the NewForm.aspx
Show in List Settings: This controls whether a field can be modified via List Settings
Show in Views: This controls if a field is visible within List Views
Allow Deletion: This controls whether a field can be deleted or not
Show in Version History: This controls whether a field is displayed within an items Version History

There are a few free solutions that'll help you manipulate these, such as these. They'll be able to help you achieve what you want to with the Calculated Columns as specified

SharePoint Manager 2010 - https://spm.codeplex.com/releases/view/35932
List Field Manager - https://listfieldmanager.codeplex.com/ (I've written about this product here)

_{Friday, October 31, 2014 5:54 AM}

Hello,

Calculated column does not show in newform/editform by default, even if you enable the content type still they should not be visible. I am wondering how they are visible if there is no additional customization in list. Please verify

Calculated columns are only visible in view page, which can be hidden by modifying the view.

Hemendra:Yesterday is just a memory,Tomorrow we may never see<br/> Please remember to mark the replies as answers if they help and unmark them if they provide no help

_{Friday, October 31, 2014 10:44 AM}

You may be able to edit the Newform/editform, then add the javascript code in content editor web part to hide the particular field.

I have hid the content type field in editform with js before, you can take a look.

Thanks

Daniel Yang
TechNet Community Support

_{Friday, October 31, 2014 12:35 PM}

You're right; the calculated columns don't show in New or Edit versions of the form, but they DO show up in the View version of the form. This is not the same as a List View, so I don't know of any way to modify it.

_{Friday, October 31, 2014 1:23 PM}

Those tools sound interesting, but the Download page doesn't provide an .EXE file; instead, it points to something called a .wsp, which my system can't open or run. Is there an EXE setup file for List Field Manager, for example?

_{Friday, October 31, 2014 1:39 PM}

If you can't do any of the code or javascript, the only option is to try what one person reported in that other thread: use Single Line of Text. Somehow someone said that worked while other types didn't, but I'm not sure if that will work for calculated columns.

Of course that may mean more work if you already have processes that look at that field.

_{Friday, October 31, 2014 3:03 PM}

The List Field Manager is a localised solution, which means you can upload the package to your site collection if you've got site collection admin rights?

_{Friday, October 31, 2014 3:22 PM}

Ah, that explains it. I'm not a site-collection admin, just a site owner. So I guess those tools aren't available to me.

_{Friday, September 1, 2017 2:06 PM}

I had this same issue... and finally found the solution.

What you have to do is go into the content type (as you show above) and remove the column from the content type. This will NOT remove the column from the list, only from the type which means it won't show on all the other forms... :)

Hope this reply isn't too late!!!

Cheers!

Also, if anyone reads this, please up-check this so that it gets higher so people don't have to read all the comments to get to the solution - and so they don't have to try all of the coding to do this easy solution... :)

Share via

Hide Calculated columns from a list's New/Edit form?

Question

All replies (15)

Additional resources