General

Re: Repeating Section Count

Patrick Halstead — Fri, 20 Feb 2009 21:58:39 GMT

Hi Igor92128,

You can browser-enable a form with code but it requires an extra activation when publishing to SharePoint (due to security restrictions of adding code).

Re: Repeating Section Count

igor92128 — Fri, 20 Feb 2009 19:05:27 GMT

Jimmy,

Is there any way to do this in a browser-only enabled form? I'd like to create a 2nd version.

Igor

Re: Repeating Section Count

igor92128 — Thu, 19 Feb 2009 21:49:00 GMT

Thanks Jimmy, this works well.

Re: Repeating Section Count

Jimmy — Wed, 18 Feb 2009 01:25:53 GMT

Ok, please try putting this code in the event handler for a button. You will need to change the underlined parts. The first underlined part corresponds to the path of the field where the user will enter the count, and the second is the path of the repeating group on your form:

XPathNavigator mainDataNavigator = MainDataSource.CreateNavigator();
// select the field where the user is entering the number
XPathNavigator countField = mainDataNavigator.SelectSingleNode("/my:myFields/my:field1", NamespaceManager);
int requestedCount;
// check that the value of the field is a valid number and parse it if it is
if (Int32.TryParse(countField.Value, out requestedCount))
{
     // determine the number of rows already in the table
     int currentCount = mainDataNavigator.Select("/my:myFields/my:group1/my:group2", NamespaceManager).Count;
     // if the table already has as many as, or more rows than the user requested, show an error
     if (currentCount >= requestedCount)
     {
          MessageBox.Show(string.Format("The table already has {0} rows.", currentCount));
     }
     else
     {
          // add rows to the table until the total number of rows is the requested number
          for (; currentCount < requestedCount; currentCount++)
          {
               // The xmlToEdit value ("group2_1" here) can be found in the repeating
               // table's properties on the Advanced tab
               CurrentView.ExecuteAction(ActionType.XCollectionInsert, "group2_1");
          }
     }
}
else
{
     // If the entered number could not be parsed, show an error.
     MessageBox.Show("Please enter a valid number.");
}

Re: Repeating Section Count

igor92128 — Tue, 17 Feb 2009 20:45:07 GMT

Jimmy,

I would like to do this in C#.

Thanks,
Igor

Re: Repeating Section Count

Jimmy — Mon, 16 Feb 2009 06:37:31 GMT

Igor, there is no way to do what you described using rules, though it is easy enough if you use code.

Please let me know if you would like to go that route, and what type of code (JScript, C#, VB) you would like to use.

Re: Repeating Section Count

swathip — Mon, 16 Feb 2009 06:12:44 GMT

Hi,

Add the default value to the text box using the following steps. So that when the user inserts/deletes the row from the repeating section, it automatically updates the value.

1. Go to the text box properties.

2. Click on fx button beside the Value box.

3. Select the Count function.

4. In that enter the xpath of the repeating section.

The expression should look like

count(/my:myFields/my:group1/my:group2)

here /my:myFields/my:group1/my:group2 is the repeating section xpath.

Repeating Section Count

igor92128 — Sat, 14 Feb 2009 00:34:11 GMT

I have a repeating control and I would like the user to specify how many times the control should repeat. I just have a textbox and a button and I am trying to get the rule working for the button, but I can only set a field's value. Is there a way, using rules, that I could set the count(repeating_section) to what is typed in the textbox?

Thanks,
Igor