Controls

Re: Repeating Table

Greg Collins — Mon, 25 Jun 2007 16:32:21 GMT

Glad you got it working! Thanks for sharing this.

Re: Repeating Table

murphyadam — Thu, 21 Jun 2007 21:54:22 GMT

This is what worked for me. Notice the switch statment to prevent event bubbling.

function msoxd_my_Location::OnAfterChange(eventObj)
{
if (eventObj.IsUndoRedo)
{
return;
}

switch(eventObj.Operation)
{
  case "Delete":
   restoreRepeatingTable("group2_297");
   break;
  case "Insert":
   if (eventObj.NewValue != "")
   {
    fillPlantNotificationList();
   }
   break;
  default:
   break;
}
}

function restoreRepeatingTable(cXmlToEdit)
{
XDocument.View.ExecuteAction("xCollection::removeAll", cXmlToEdit);
XDocument.View.ExecuteAction("xCollection::insert", cXmlToEdit);
}

function fillPlantNotificationList()
{
var oPnlItem = me.selectSingleNode("//my:PnlItem");
var oPnl = me.selectSingleNode("//my:PlantNotificationList");
var cLocation = me.selectSingleNode("//my:Location").text;

var oContacts = XDocument.DataObjects("Workflow").DOM.selectNodes("//dfs:Workflow[@Location='" + cLocation + "']");

if (oContacts)
{
  for (var i = 0; i < oContacts.length; i++)
  {
   var oNewItem = oPnlItem.cloneNode(true);
   oNewItem.selectSingleNode("my:PnlName").text = oContacts.item(i).selectSingleNode("@First_Name").text + " " + oContacts.item(i).selectSingleNode("@Last_Name").text + "";
   oNewItem.selectSingleNode("my:PnlEmail").text = (address = oContacts.item(i).selectSingleNode("@E-mail_Address"))? address.text: "";
   oNewItem.selectSingleNode("my:PnlPhone").text = (phone = oContacts.item(i).selectSingleNode("@Business_Phone"))? phone.text: "";
   oPnl.insertBefore(oNewItem, oPnlItem);
  }
}
}

Re: Repeating Table

Greg Collins — Wed, 25 Apr 2007 17:35:07 GMT

2DS is my abbreviation for Secondary Data Source. Repeating tables bound to a 2DS are basically 2nd class citizens in InfoPath (unfortunately)--there are a lot of features turned off for them (as you've seen, inserting rows, filtering, etc).

Modifying the DOM of a 2DS is the same as working with your main DOM. If you are using the InfoPath 2003 object model, you'd be using thing like selectSingleNode() and appendChild() to add a new row. If you are using the InfoPath 2007 object model, then you'd be using the XmlNode, etc objects to do the same thing. Sorry I don't have any links to point you to... but it is basic XML DOM manipulation, and there should be plenty of sources that explain how to do this.

Re: Repeating Table

murphyadam — Wed, 25 Apr 2007 13:51:54 GMT

I've not been able to find any examples on reading a secondary data source and writing the data to a repeating table. Can you point me in the correct direction?

Also, what is 2DS limitation?

Re: Repeating Table

Greg Collins — Tue, 24 Apr 2007 21:23:51 GMT

While you can set values with rules, the most useful method is using code. This will allow you to properly pinpoint the correct row and fields.

Using code you can also get by the limitation about adding/removing rows in a 2DS repeating table. In code you can simply insert a new row node, or remove one. Set up buttons that call into the code to accomplish this (i.e. an "Insert New Row" button, etc).

Re: Repeating Table

murphyadam — Tue, 24 Apr 2007 19:50:40 GMT

I've just discovered that if I bind it to a secondary data source then a user can't insert new items.

The most desirable solution is to set the repeating table values through a rule or code using the secondary datasource. Is this possible?

Re: Repeating Table

Greg Collins — Tue, 24 Apr 2007 19:32:50 GMT

Unfortunately filtering isn't available on secondary data sources. However, you can use conditional formatting which can accomplish the same thing.

Repeating Table

murphyadam — Tue, 24 Apr 2007 19:13:27 GMT

I have a drop-down control where the user selects a location. I need to populate a repeating table based on their selection.

So, I pick Kanas City and then the repeating table gives me Name, Email, Phone of each person in Kansas City. All of my datasources are in Sharepoint lists.

I tried the Binding options of the repeating table but it doesn't allow for filtering based on another field, that I could find.