$().SPServices.SPDisplayRelatedInfo

Feb 22, 2012 at 9:09 PM

Hi Marc

I am adding a new discussion with my problem.

I have 2 lists:

ListB name-->Quote Term Type--->  columns: Title,        Description(single line of Text)

                                                                 ----------     -----------------------------

                                                                  Term1           terms and conditions related to term1..................

                                                                  Term2            terms and conditions related to term2.................

ListA name--->Terms---> columns:  

                Terms( lookup to ListB:Title) , Description(Multiple lines of text)  

 

so when user select some value in ddl in ListA(ex: Term1) , related text should display in ListA: Description.

Its is displaying If I use ListA: Description as Single line of text, but I need the description column as Multiple lines of text.  ( not working with multiple lines of text column).

 

My Code:

 

<script language="javascript" type="text/javascript"  src="/testsite/SiteAssets/jquery-1.7.1.min.js"></script>

<script language="javascript" type="text/javascript" src="/testsite/SiteAssets/jquery.SPServices-0.7.1.min.js"></script>

<script language="javascript" type="text/javascript">$(document).ready(function() {
$().SPServices.SPDisplayRelatedInfo({ 

columnName: "Terms", 

relatedList: "Quote Term Type", 

relatedListColumn: "Title", 

relatedColumns: ["Description"], 

displayFormat: "list", 

//Hide Column Headers and the data output from original function, not using the function as originally designed 

//headerCSSClass: "ms-hidden", 

//rowCSSClass:"ms-hidden", 

completefunc: SetFields,

debug: true

  });

}); 

function SetFields(){ 

          var srcDivId = "SPDisplayRelatedInfo_Terms";

          var tds = document.getElementById(srcDivId).getElementsByTagName("td");

          var Column1Data = tds[0].innerHTML; 

          var theDropDown = getTagFromIdentifierAndTitle("select","","Terms");  

           var theTextBox = getTagFromIdentifierAndTitle("input","","Description"); 

           //This is what prevents it from being changed every time the page flips.

            if (theTextBox.value==""){ 

              theTextBox.value = Column1Data;  

                         } 

          else if (theTextBox.value!==Column1Data){          

                     theDropDown.parentElement.onclick = function(){   

                      theTextBox.value = Column1Data;

                           }; 

          }     

              };

 function getTagFromIdentifierAndTitle(tagName, identifier, title) { 

          var len = identifier.length;   

        var tags =   document.getElementsByTagName(tagName);     

      for (var i=0; i <   tags.length; i++) {   

        var tempString = tags[i].id;           

    if (tags[i].title == title && (identifier == "" ||   tempString.indexOf(identifier) == tempString.length - len)) {   

            return tags[i];       

         }           

 }         

  return null;         

          };

</script>

 

Any ideas

 

Cheers