Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a xslt list form view. I have 3 drop down on the form - Area , Geo Market , Country for which i want to implement cascading functionality.

Data saved in list is of type Single line of text.(Cannot change the list column type)

But after cascading is implemented, data saved in list is the value of the selected option not the display text.(Geomarket selected is "ABC" , then value of "ABC" i.e. 2 is saved.)

How can i save the display text instead of Value?

my xslt data :
Area :

<SharePoint:DVDropDownList runat="server" id="ff13{$Pos}" selectedvalue="{@Area}" __designer:bind="{ddwrt:DataBind('u',concat('ff13',$Pos),'SelectedValue','SelectedIndexChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Area')}" datasourceid="spdatasource1{generate-id()}" datatextfield="Title" datavaluefield="Title" title="Area"/>

Geomarket

<SharePoint:DVDropDownList runat="server" id="ff13{$Pos}" selectedvalue="{@Area}" __designer:bind="{ddwrt:DataBind('u',concat('ff13',$Pos),'SelectedValue','SelectedIndexChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Area')}" datasourceid="spdatasource1{generate-id()}" datatextfield="Title" datavaluefield="Title" title="Area"/>

Country :

<SharePoint:FormField runat="server" id="ff12{$Pos}" ControlMode="Edit" FieldName="City" __designer:bind="{ddwrt:DataBind('u',concat('ff12',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@City')}" /><SharePoint:FieldDescription runat="server" id="ff12description{$Pos}" FieldName="City" ControlMode="Edit" />

Cascade is implemented using :

$(document).ready(function()
{  
  $().SPServices.SPCascadeDropdowns({
    relationshipList: "GM",
    relationshipListParentColumn:"Areas",
    relationshipListChildColumn:"Title",
        parentColumn:"Area",
        childColumn:"ddlGeoMarket",
        promptText: "Select GeoMarket",
        debug:true
    }); 

    $().SPServices.SPCascadeDropdowns({
    relationshipList: "Country",
    relationshipListParentColumn:"GeoMarkets",
    relationshipListChildColumn:"Title",
        parentColumn:"ddlGeoMarket",
        childColumn:"ddlCountry",
        promptText: "Select Country",
        debug:true
    });

  });
share|improve this question

1 Answer 1

If you've customized the form, then SPServices may not work as well with it. You may need to make some adjustments to your XSL so that SPCascadeDropdowns understands what you've got going on in the DOM.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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