Skip to main content

SP service code to Get the value from SharePoint List and and display another value based on drop down value selection




/ Function for getting commnets on page load  from Photographer lis
$(document).ready(function() {

// Photographer #1
$('select[title="Photographer1"]').change(function(e) {
var selectedValue = $('select[title="Photographer1"] :selected').text();

$().SPServices({
        operation: "GetListItems",
        listName: "Photographers",
        CAMLViewFields: "<ViewFields><FieldRef Name='Comments' /></ViewFields>",
               
        CAMLQuery: "<Query><Where><Eq><FieldRef Name='Name'/><Value Type='Text'>"+selectedValue+"</Value></Eq></Where></Query>",
        completefunc: function (xData, Status) {
         //alert(Status);
            $(xData.responseXML).SPFilterNode("z:row").each(function() {
             //PremiereDate = $(this).attr("ows_PremiereDate");

                var comments= $(this).attr("ows_Comments");
                if(comments!= null)
             {               
              document.getElementById('Label1').innerHTML = comments;
                }
                else
                {
                 document.getElementById('Label1').innerHTML = "";
                }

                
});
  }
});
});
//2nd Photographer
$('select[title="Photographer2"]').change(function(e) {
var ph2= $('select[title="Photographer2"] :selected').text();

$().SPServices({
        operation: "GetListItems",
        listName: "Photographers",
        CAMLViewFields: "<ViewFields><FieldRef Name='Comments' /></ViewFields>",
               
        CAMLQuery: "<Query><Where><Eq><FieldRef Name='Name'/><Value Type='Text'>"+ph2+"</Value></Eq></Where></Query>",
        completefunc: function (xData, Status) {
         //alert(Status);
            $(xData.responseXML).SPFilterNode("z:row").each(function() {
             //PremiereDate = $(this).attr("ows_PremiereDate");

                var comments2= $(this).attr("ows_Comments");
                if(comments2!= null)
             {               
              document.getElementById('Label2').innerHTML = comments2;
                }
                else
                {
                 document.getElementById('Label2').innerHTML = "";
                }

                
});
  }
});
});

Comments

Popular posts from this blog

Build and Deploy a custom theme in SharePoint 2019: Using C# and Site features

Custom Theme and Branding are common to use cases and all kinds of business users like to have the personalized team and collaboration sites. today I am posting C# code that will help to build custom features for SharePoint 2019 site.   If need any assistance, I would be happy to help: kamal_pandey@outlook.com  ----------------------------- Code to build  custom features---------- using System; using System.Collections.Generic; using System.Globalization; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.SharePoint; using Microsoft.SharePoint.Utilities; namespace SharePointBranding.Code {     public class BrandingManager     {         public SPWeb Web { get; set; }         public BrandingManager(SPWeb web)         {             Web = web;         }         public void SetMasterPage(stri...

PowerShell For create Sub site in office 365

#Add references to SharePoint client assemblies and authenticate to Office 365 site Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.dll" Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.Runtime.dll" $Username = Read-Host -Prompt "Please enter your username" $Password = Read-Host -Prompt "Please enter your password" -AsSecureString $Site = "https://XXXXXXX.sharepoint.com/sites/Test2/" $Context = New-Object Microsoft.SharePoint.Client.ClientContext($Site) $Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username,$Password) $Context.Credentials = $Creds $csvLocation = "C:\Users\PS_SiteCollectionsToCreate.csv" $csv = Import-Csv $csvLocation #List Custom Templates $Templates = $Context.Site.GetWebTemplates("1033","0") $Context.Load($Templates) $Context.ExecuteQuery() $Templates | Whe...