General

Re: Repeating Table Preceding Sibling

Hilary Stoupa — Tue, 08 Mar 2016 15:48:05 GMT

I replied to your original post here: http://www.infopathdev.com/forums/p/31006/105705.aspx#105705

Re: Repeating Table Preceding Sibling

iengineer86 — Tue, 08 Mar 2016 15:41:30 GMT

my problem is same I am trying to use the preceding-sibling formula but it is not working keep saying "preceding-sibling::Vacatoin_Info/Used_Vac_Hrs" does not point to a valid location path of a field or group. MY Xpath whos default value i want to set basaed on the previous field (Used_Vac_Hrs) : /dfs:myFields/dfs:dataFields/d:Employee_Info/d:Vacation_Info/@Temp_Vac Xpath for Used_Vac_Hrs is : /dfs:myFields/dfs:dataFields/d:Employee_Info/d:Vacation_Info/@Used_Vac_Hrs

Re: Repeating Table Preceding Sibling

Hilary Stoupa — Tue, 13 Oct 2015 14:32:49 GMT

No, you haven't wasted my time at all! We all sometimes just need to write out what we are trying to do in order to find the issue. :-)

Re: Repeating Table Preceding Sibling

glennyboi — Tue, 13 Oct 2015 07:18:55 GMT

So it has just dawned on me that the rules where pointing to a hidden field and i had infact left out the field i needed. Im extremeyl grateful for your time and offer to help.

I am deeply embarrassed that i also wasted your time

Re: Repeating Table Preceding Sibling

Hilary Stoupa — Mon, 12 Oct 2015 19:41:24 GMT

Thanks for the sample - But I'm not sure where preceding-sibling needs to come into play here? Were you wanting to check the preceding row in your form rule conditions? Or set values to the preceding row?

Re: Repeating Table Preceding Sibling

glennyboi — Mon, 12 Oct 2015 15:37:47 GMT

Thanks for a quick response. Im using this with an access database - when the user inserts a new case record, i want the form type to be the same every time, but only when certain rules apply Thanks

Re: Repeating Table Preceding Sibling

Hilary Stoupa — Mon, 12 Oct 2015 15:26:43 GMT

Where are you trying to use the formula? Want to attach a sample form under the Options tab and I can give you a hand?

Re: Repeating Table Preceding Sibling

glennyboi — Mon, 12 Oct 2015 15:21:31 GMT

I have been having a night mare of a time. I have been trying to get the preceding sibling working but i can't My xpath is showing as /dfs:myFields/dfs:dataFields/d:Client/d:Record/@FormType Im not sure how i convert that into the preceding-sibling, the tutorial is useful if you understand what is meant as a node. Any clues? Thanks in advance

Re: Repeating Table Preceding Sibling

Hilary Stoupa — Fri, 02 Oct 2015 14:40:02 GMT

Here's a sample - save it locally, right click and select Design to open in Design mode. There is a formula on field2 that returns the value from field1 in the row immediately preceding.

Here's a blog post by Greg Collins that I found helpful for understanding this better: http://www.infopathdev.com/blogs/greg/archive/2005/06/13/Using-XPath_2700_s-_2700_preceding_2D00_sibling_2700_-Axis-Correctly.aspx

Repeating Table Preceding Sibling

barrymurphy — Fri, 02 Oct 2015 14:20:00 GMT

I have a repeating table where I enter a value. When I insert a new row and enter another value, I want the value of the previous row to be taken-away from the current row. Currently I have it working for the first 2 rows, but when I insert a third row it is taking the first rows value and taking it away from the third row when really I want the second row to be taken-away from the third row.