General

Re: How do I create an alphabetized lists in a repeating section?

jack eagly — Wed, 11 Feb 2015 21:11:26 GMT

Good news, I can do it... It took me several tries but I got it. Thank you so so much.

Re: How do I create an alphabetized lists in a repeating section?

Hilary Stoupa — Wed, 11 Feb 2015 20:04:32 GMT

Set it to Use formula and type in count(current()/preceding-sibling::my:group6) +1

Replacing group6 with the correct XPath for your form's schema.

Re: How do I create an alphabetized lists in a repeating section?

jack eagly — Wed, 11 Feb 2015 19:52:33 GMT

so If I click fx, then type concat(

Then Click Insert Field or Group and select secondary data source and field: Name and click ok

Then Insert Field or Group and select Filter Data, Add, select Field or Group, secondary data source and field: Number

Do I set that is equal to (or another parameter) Group6 or equal to Use formula and insert count(current()/preceding-sibling) +1?

Please walk me through this so I can do it.

Thanks.

Re: How do I create an alphabetized lists in a repeating section?

Hilary Stoupa — Wed, 11 Feb 2015 15:11:29 GMT

Actually, that's the thing - I used the insert field or group button to select the field from the data source, then manually created the filter (the stuff in the square brackets) - which I know is not a lot of help when you are learning this stuff. :)

Re: How do I create an alphabetized lists in a repeating section?

jack eagly — Wed, 11 Feb 2015 14:24:19 GMT

Thank you very much. I had built the formula using XPath and just moved it to text so you could see what I had done. Can you provide the steps to inserting the formula, is it something like:

Type concat(
select insert Field or Group
Select Name from secondary source
enter [
then click insert button again and select Number from secondary source
insert function and select count and type in current()/preceding-sibling::
then click insert button again and insert group6 close parenthesis +1,".")

That's how I was doing it but I could get group6 to populate.

Thanks Again.

Re: How do I create an alphabetized lists in a repeating section?

Hilary Stoupa — Wed, 11 Feb 2015 02:26:30 GMT

In your calculated values you had the formula entered as text (but you may have done that to show me where you wanted things) - try this one. I fixed up the XPaths to point to the group the calculated value was in....

Re: How do I create an alphabetized lists in a repeating section?

jack eagly — Wed, 11 Feb 2015 02:15:47 GMT

It looks something like this. I tried again establishing the relationship of the groups 6 and 12 to their respective functions but I guess I don't understand the logic. Thank You.

Re: How do I create an alphabetized lists in a repeating section?

Hilary Stoupa — Tue, 10 Feb 2015 22:39:15 GMT

Attach your form to a reply under the Options tab & I'll give you a hand. What you'll need is the path to the group - usually it has to be manually entered in a more complex formula. :)

Re: How do I create an alphabetized lists in a repeating section?

jack eagly — Tue, 10 Feb 2015 22:32:18 GMT

Thank you very much, I can see your solution. I tried to recreate it using your fx but I can't just copy and past your formula. So I after creating the link from InfoPath to .xml file, I selected and inserted the name type from Letters.xml and then Number but when I select the group from main data source, instead of group2 appearing I get .. with an underline and when I hit okay, I get the formula contains errors....

preceding-sibling::-->..<--).

After I get this to work I'll need to think about auto populating the second field based on each letter in the first field.

Thanks.

Re: How do I create an alphabetized lists in a repeating section?

Hilary Stoupa — Tue, 10 Feb 2015 17:20:37 GMT

Here's the sample again in IP 2007. In my sample XML I've got the numbers & letters then am using a filter to get the right one.

Re: How do I create an alphabetized lists in a repeating section?

jack eagly — Tue, 10 Feb 2015 16:34:27 GMT

I'm using 2007. I've saved example forms before and have been able to open them with no issues, this is the first one. I've done some searching and have come up with the following xml code and linked to a read only text box inside of a repeating table....

<?xml version="1.0"?>
<outline>
<type>a.</type>
<type>b.</type>
<type>c.</type>

</outline>

but when I insert a new row into my table, all I get is a. b. .... for each new row rather than...

etc.

Thanks.

Re: How do I create an alphabetized lists in a repeating section?

Hilary Stoupa — Tue, 10 Feb 2015 00:46:09 GMT

What version of IP are you using? 2007? I think the template I saved was 2010, I'm happy to change the compatibility setting and repost it. Be sure you are saving locally and right clicking to select Design to open in design mode....

Re: How do I create an alphabetized lists in a repeating section?

jack eagly — Tue, 10 Feb 2015 00:28:28 GMT

Thanks for the response, I'd like to see your solution. I couldn't open it at work because policies won't let me open a form downloaded from the internet. I came home and tried it but cannot open it because your form was created with a newer version than mine. I vaguely remember using .xml to do something similar but its' been 7 or 8 years ago.

Re: How do I create an alphabetized lists in a repeating section?

Hilary Stoupa — Mon, 09 Feb 2015 19:52:18 GMT

I'd use an XML file in the form as a secondary data source for this - see attached sample. Save the file locally, right click and select design to open in design mode.

Re: How do I create an alphabetized lists in a repeating section?

jack eagly — Mon, 09 Feb 2015 19:36:31 GMT

Okay, I learned if I insert the fx control and use position() I can concat with parenthesis to get (1), (2), (3), etc. So I'm half way there. Now I need help figuring out how to increment a., b., c., etc. along with (a), (b), (c) and so on in two seperate repeating tables. I've searched to the end of the internet but haven't found a good solution. I can't be the only one that has ever needed to be able to do this. InfoPath 2007.

Thanks.