0

I want to validate column by Type of employee.

Type of Employee: - Contact - Full Time

I want to validate a column for "Hire Date"(Type: Date) by "Employee Type" column.

I want the date to Null/Blank/Not selectable if "Employee Type" column is Contact. The option must be available only if the "Employee Type" column is Full Time.

I tried =IF([Employee Type]="Contract Employee", "Null") not worked.

Please assist

0

Yes it is possible using Javascript.
Please try the below format.

Put it in the JS file and add this code to the List's "New/Edit" forms using "Content Editor Web Part".


$(document).ready(function() {
decideFunc();

$('select[id*="EmployeeType"]').on('change',function(e){
decideFunc();
})
});

function decideFunc(){

if($('select[id*="EmployeeType"] option:selected').val()!="Contact")
{
hideColumn();
}
else
{
showColumn();
}
}//decideFunc ends
function hideColumn(){

$('input[id*="HireDate"]').closest("tr").hide();

$('input[id*="HireDate"]').val("");//clear the value while hide

}//hideColumn ends
function showColumn(){

$('input[id*="HireDate"]').closest("tr").show();

if(!$('input[id*="HireDate"]' ).val().trim().length){

$('input[id*="HireDate"]').val("");}
}//showColumn ends

0

did You consider using JSLink? this is a kind of Javascript attached to a column which will be 'visible' in all forms (list view, edit form, add from, display form) where the column is present.

  • You can add JSLink to column Via Powershell

Add-PSSnapin "Microsoft.SharePoint.PowerShell"
$web = Get-SPWeb "url" 
$list = $web.Lists["listName"];
$field = $list.Fields.GetField("fieldName");
$field.JSLink = "/_layouts/15/examplefile.js" 
$field.Update(true)
  • or via c# which will be executed on feature active (very similar code to powershell)

please be aware that the JSlink may be stored under _layouts, or _catalogs or style library like


~sitecollection/Style Library/JSFiles/File.js

other referent types are

  • ~site – reference to the current SharePoint site (or “Web”)
  • ~sitecollection – reference to the current SharePoint site collection (or “Site”)
  • ~layouts – version specific reference to the web application Layouts folder (so it will automatically swap out /_layouts/14 or /_layouts/15 for you)
  • ~sitecollectionlayouts – reference to the layouts folder in the current site collection (e.g. /sites/team/_layouts/15)
  • ~sitelayouts – reference to the layouts folder in the current site (e.g. /sites/teams/subsite/_layouts/15)

then in this JSLink in on edit form You could add custom Javascript logic to make field readonly based on value from other column. The code should look like:


(function () {
    'use strict';

    var ctx = {};

    function init() {
        ctx.Templates = {};
        ctx.Templates.Fields = {
            'fieldName': {
                'EditForm': ReadOnly
            }
        };
        SPClientTemplates.TemplateManager.RegisterTemplateOverrides(ctx);
    }

    function ReadOnly(ctx) {
            //console.log(ctx);
            var val = ctx.CurrentFieldValue;
            return "" + val + "";
        }

    init();

})();

I hope this will help :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.