General

Re: Skip steps in autonumbered rows - XPath question

Jimmy — Wed, 19 Dec 2012 07:07:19 GMT

Great to hear that. :-)

I hope I can be of assistance again in the future.

Re: Skip steps in autonumbered rows - XPath question

danlovejoy — Tue, 18 Dec 2012 21:40:41 GMT

Jimmy! You fixed it! The problem was the checkbox datatype. It wasn't a boolean. I switched it to a boolean and now it's FIXED! Hallelujah.

Re: Skip steps in autonumbered rows - XPath question

OKC_Dave — Tue, 18 Dec 2012 19:53:23 GMT

Jimmy,

May have found how to post the screen shot:

Re: Skip steps in autonumbered rows - XPath question

OKC_Dave — Tue, 18 Dec 2012 19:28:15 GMT

The expanded structure looks like this:

Steps

Step

HeaderRow

Op-seq

Operation

Location

etc.

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

Hope that helps. Dan should be back any time. We GREATLY appreciate your help!!

Re: Skip steps in autonumbered rows - XPath question

OKC_Dave — Tue, 18 Dec 2012 19:16:01 GMT

Jimmy,

I'm replying for Dan who had to step away for a minute. Let me know if this is not what you were looking for:

XXXXXXXXXXXXXXXXXXX I've been trying and cannot find a way to post the screenshot. Still trying...

Re: Skip steps in autonumbered rows - XPath question

Jimmy — Tue, 18 Dec 2012 18:38:05 GMT

In your form, is my:Steps the repeating group or is my:Step repeating (or both)? Could you post a screenshot of your data source taskpane with that part expanded?

Re: Skip steps in autonumbered rows - XPath question

danlovejoy — Tue, 18 Dec 2012 18:02:41 GMT

All right, one difference in the example form and in my form is the XPath location of Op-seq. (I used "Copy XPath" for both)

My Form Field Op-seq XPath

/my:myFields/my:Steps/my:Step/my:Op-seq

Example Field Op-seq Xpath:

/my:myFields/my:Step/my:Op-seq

Should this affect the XPath rule? I don't know enough about the syntax to tell what is root and what is relative.

Re: Skip steps in autonumbered rows - XPath question

danlovejoy — Tue, 18 Dec 2012 17:31:36 GMT

OK - it works perfectly in your example form. EXCELLENT. THANK YOU!! Unfortunately, it's still broken in the actual form. I'm afraid I shouldn't post the actual form here, so I will try to puzzle out the difference, like a monkey with a phaser. -d

Re: Skip steps in autonumbered rows - XPath question

danlovejoy — Tue, 18 Dec 2012 17:27:49 GMT

Going to the trouble? Are you kidding me? You are helping me out BIG TIME here. I'm going to send you a present.

Here's the code I have attached to the Op-seq field:

substring(count(../preceding-sibling::my:Step[my:HeaderRow != "true"]/my:Op-seq) + 1, 1, 5 * (../my:HeaderRow != "true"))

I'll take a look at the example form now. THANK YOU.

Re: Skip steps in autonumbered rows - XPath question

Jimmy — Tue, 18 Dec 2012 17:21:48 GMT

Thank you for going to the trouble of uploading those videos. I do have the functionality working in your sample form and am attaching it here.

Could you post the formula you have in its current form? (make sure to check Edit XPath first)

Re: Skip steps in autonumbered rows - XPath question

danlovejoy — Tue, 18 Dec 2012 17:09:38 GMT

Thank you so much. I do not have them repeating in the actual form, but in the test form I sent you.

I'm linking to a video that shows the behavior of the formula you specified. There are a couple of variances:

1.) It does not renumber correclty after the blank space. (e.g. 1, 2, 3, (BLANK), 4, 5 (BLANK), 6)
2.) It still renumbers blank spaces when a step is inserted anywhere before the blank spaces.

Form_Autonumber_Misbehavior

I'm also linking to a video that shows the correct behavior of the renumbering. It would be perfect, but it does not retain the blank spaces after the user inserts a row before. This is in an older version that doesn't have the "HeaderRow" checkbox. This is the problem. I can get it to number perfectly, until the user inserts a row before, then everything blows up, regardless.

Form_Correct_Behavior_-_without_insert_above

Re: Skip steps in autonumbered rows - XPath question

Jimmy — Tue, 18 Dec 2012 16:51:55 GMT

If you expand the XPath for the formula, you'll see that you have ../my:HeaderRow inside the square brackets, but it should just be my:HeaderRow there. That will fix the issue where all the values are 1.

There was also a mistake in my formula. It should be this:

substring(count(../preceding-sibling::my:Step[my:HeaderField != "true"]/my:Op-seq) + 1, 1, 5 * (../my:HeaderField != "true"))

with the added parentheses around ../my:HeaderField != "true"

As a side note, there isn't a need to put each of the controls into its own repeating section. You can just place the controls directly into the repeating table and that should work.

Re: Skip steps in autonumbered rows - XPath question

danlovejoy — Tue, 18 Dec 2012 16:08:31 GMT

I'm not sure I can post the actual form, so I have made a copy of the section in question and applied the formula. It works in this form exactly as it works in my form. In other words, it inserts a "1" into every field regardless, and it allows for the blank spaces to be overwritten when you add a row above. I am so grateful for your help!

Re: Skip steps in autonumbered rows - XPath question

Jimmy — Tue, 18 Dec 2012 14:48:27 GMT

Have you tried my formula yet? If you have and it didn't work, would you be able to post your form template here?

Re: Skip steps in autonumbered rows - XPath question

danlovejoy — Tue, 18 Dec 2012 14:19:50 GMT

Thanks! I have changed it to lower-case "true," but I'm still seeing the incorrect behavior. It's not numbering. (every row is "1") and it's still overwriting when I re-order the steps.