SharePoint 2013 not hiding Fields

 

After a SharePoiint Foundation 2010 to SharePoint Foundation 2013 upgrade, hidden fields were showing up again UNTIL the JavaScript line was added into the Edit Page via SharePoint Designer 2013.

<asp:Content ContentPlaceHolderId="PlaceHolderMain" runat="server">
<script type="text/javascript" src="/sites/lng/Style%20Library/jquery/jquery-3.6.0.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("nobr:contains('Project Registration Date')").closest('tr').hide();
$("nobr:contains('Drawing Review Date')").closest('tr').hide();
$("nobr:contains('Design Contractor')").closest('tr').hide();
$("nobr:contains('Project Initiation Date')").closest('tr').hide();
$("nobr:contains('Installed By')").closest('tr').hide();
$("nobr:contains('Cat.')").closest('tr').hide();
$("input[title*='B defs. (Initial)']").closest('tr').hide();
$("input[title*='B defs. (Remaining)']").closest('tr').hide();
$("input[title*='A defs. (Initial)']").closest('tr').hide();
$("input[title*='A defs. (Remaining)']").closest('tr').hide();
$("nobr:contains('C.R.s')").closest('tr').hide();
});
</script>

 

 

Publish Web App to Azure

Log onto the Azure Portal, go to the App Services and select the App that you need to publish from Visual Studio to Azure.

Click on Get publish Profile. This downloads a Settings file.

In Visual Studio go to Publish and selete the "Import Profile" option.

Then import the Profile that you just exported from Azure. Done!

Restore local SQL database to Azure SQL

On local SQL Server database right-click on the database, Tasks, then Export Data-Tier Application to create a *.bacpac file.

Connect to the Azure database server via SSMS. Right-Click on the Azure Databases node. The Database cannot currently exist, so if it does it needs to be deleted first!

Select Import Data-tier Application and select the *.bacpac files that was created in the first step. This creates the database in Azure!

Don't forget to select the Edition of Microsoft Azure SQL Database before you complete the process.

Visual Studio compiles fine, but it still shows red lines

More Info Here: https://stackoverflow.com/questions/21098333/visual-studio-compiles-fine-but-it-still-shows-red-lines Visual Studio 2019 is showing red underline all the time, even when it compiles fine!

Closing Visual Studio and removing the .vs folder located in the solution directory worked for me.

This folder has a hidden attribute. You may need to change settings in folder options to show hidden files.

MVC display moves if there is a scrollbar.

Use this in the _layouts view to prevent the annoying left twitch if the content is longed than can fit on the display. The scrollbar moved the display to the left unless you put this in the _layouts View.

       /* prevent layout shifting and hide horizontal scroll */
        html {
            width: 100vw;
        }

        body {
            overflow-x: hidden;
        }

MVC Blank Space Above Navbar

I recently came across a very annoying "feature" when developing an MVC5 site, and it took a few hours to resolve.

The white/blank above the navbar is the issue. To resolve this I added a margin-top: -50px in the Header of the _layouts view and all other _layouts that I had developed. Now it looks like this.

<style>
        body {
            margin-top: -50px;
        }
</style>

SharePoint 2013 Calculated Column

I just migrated a SharePoint side from 2010 Foundation to SharePoint 2013 Foundation and discovered that the most important column in my Libraries was no longer rendering the HTML it needed. Instead, it was just displaying the HTML. It should be displaying an image in the 15 Hive based on the Date Today and the Report Status. I discovered that Calculated Columns were now disabled by default in SharePoint 2013 and up and that I had to disable this by default. Using the PowerShell below I was able to disable it, however it still would not render the image. I then discoved that the Calculated Column MUST be a Number Data Type and NOT a Single Line of Text that it was in SharePoint 2010.

Just to add to the pain, I was using the Today trick for a column that is referenced in the formula. This is where you create a column that defaults to Today's Date, apply the formula and then delete the Today Column. I accomplished this using some PowerShell and at the same time changed the Data Type to a Number.

Switch if OFF - The Calculated Column Must be a Number output type
$webApp = Get-SPWebApplication https://mySPSite.com
$webApp.CustomMarkupInCalculatedFieldDisabled = $false
$webApp.Update()
Script for updating the Calculated column to a Number Data Type and with the Today Column Added and Deleted after the formula was updated.
if($doesTodayFieldExist -eq $false)
{	
	Write-Host "Creating Today Field" -ForegroundColor DarkBlue
	$dateTimeFieldType = [Microsoft.SharePoint.SPFieldType]::DateTime
	$fieldName = $list.Fields.Add("Today", $dateTimeFieldType, $false)
	$list.Fields[$fieldName].DefaultValue = "[Today]"
	Write-Host "Updating List"  -ForegroundColor DarkBlue
	$list.Update()
}

$field = $list.Fields["Status"]
if($field.Title -eq "Status" -and $field.Type -eq "Calculated")
{ 
	Write-Host "Updating Calculated Column" -ForegroundColor DarkBlue
	$field.Formula = "=Formula Goes here!"

	# For SharePoint 2013 and up this must be a number field
	$field.OutputType = [Microsoft.SharePoint.SPFieldType]::Number
	Write-Host "Updating Field" -ForegroundColor DarkBlue
	$field.Update()
	Write-host "Updating List" -ForegroundColor DarkBlue
	$list.Update()
}			

$field = $list.Fields["Today"]
if($field -ne $null)
{
	Write-host "Deleting Today Field" -ForegroundColor DarkBlue
	$field.Delete()	
	Write-host "Updating List" -ForegroundColor DarkBlue
	$list.Update()
}