General

Re: Set field in repeating table from other repeating table

Hilary Stoupa — Wed, 21 Mar 2018 21:31:14 GMT

Glad that worked for you. The current() function is very useful - it always refers to the current context node, so if you had a rule on a button, for example, current() is the node the section the button is in is bound to. :)

Re: Set field in repeating table from other repeating table

joubin — Wed, 21 Mar 2018 12:14:15 GMT

Hilary, you're a genius!!

Amazingly simple how you used the .=current()/ function

Thanks a lot

Re: Set field in repeating table from other repeating table

Hilary Stoupa — Tue, 20 Mar 2018 15:09:32 GMT

Here's your form using a calculated default.

Re: Set field in repeating table from other repeating table

joubin — Tue, 20 Mar 2018 12:02:38 GMT

I think this was a leftover of a previous design, but should not interfere with functionality.

the default value does not work for consecutive cars unfortunately!

I tried something in code behind, but it doesn't update the field properly:

try

{

XPathNavigator myForm = MainDataSource.CreateNavigator();

XPathNavigator field0 = myForm.SelectSingleNode("/my:myFields/my:Invoices_List/my:group6/my:VehicleNo", NamespaceManager);

XPathNavigator field1 = myForm.SelectSingleNode("/my:myFields/my:Invoices_List/my:group6/my:Liters", NamespaceManager);

XPathNavigator field2 = myForm.SelectSingleNode("/my:myFields/my:group10/my:group11/my:car1/@my:car1_liters", NamespaceManager);

String P0 = field0.Value;

String P1 = field1.Value;

String P2 = field2.Value;

MessageBox.Show(P0 + " " + P1 + " " + P2, "Warning", MessageBoxButtons.YesNo);

field2.SetValue(P1);

}

catch (Exception ex)

Re: Set field in repeating table from other repeating table

Hilary Stoupa — Mon, 19 Mar 2018 18:57:06 GMT

I think a default value would do this then, but I'm confused by your nested repeating data. Can you help me understand why both the group and the field are repeating?

Re: Set field in repeating table from other repeating table

joubin — Mon, 19 Mar 2018 17:25:45 GMT

Hilary Stoupa:
Will there be any starting data in the liters in the table on the settings page? Or will it always just be the total from the other table when the user fills up the car?

initially the liters will be empty, just gradually filling up for every invoice (i.e. to track gas usage per quarter)

Re: Set field in repeating table from other repeating table

Hilary Stoupa — Mon, 19 Mar 2018 16:07:03 GMT

Will there be any starting data in the liters in the table on the settings page? Or will it always just be the total from the other table when the user fills up the car?

Re: Set field in repeating table from other repeating table

joubin — Mon, 19 Mar 2018 15:51:11 GMT

Hilary Stoupa:
So - you want to update this when the "OK" button is clicked?

exactly, so every time user fills up the car the value of liters shall increase. Seems to be tricky how to point to the car currently chosen from drop-down...

Re: Set field in repeating table from other repeating table

Hilary Stoupa — Mon, 19 Mar 2018 14:50:35 GMT

So - you want to update this when the "OK" button is clicked?

Re: Set field in repeating table from other repeating table

joubin — Mon, 19 Mar 2018 13:37:15 GMT

here we go...

I managed to set the default value, but it only works for the very first item in table 'cars'.

Re: Set field in repeating table from other repeating table

Hilary Stoupa — Fri, 16 Mar 2018 15:09:41 GMT

Can I see your form? You can attach it under the Options tab in a reply.

Set field in repeating table from other repeating table

joubin — Thu, 15 Mar 2018 15:25:40 GMT

In an offline form (not browser-enabled) I have a repeating table (Master) for vehicle license plates (field my:car) and fuel amount (my:car_liters).

From another view, in second repeating table (Invoices) users select a vehicle from drop-down column (my:VehicleNo) and put the liters of fuel they filled on a given date (my:Liters).

A button accepts the value and should update the fuel field of (my:car_liters) in the master table.

I tried to set a filtered Action Rule to the button using the current() function as suggested by Hilary Stoupa in my xPath:

<xsf:assignmentAction>targetField="../../my:group/my:car/@my:car_liters[../@my:car=current()/../my:VehicleNo]" expression="my:Liters"></xsf:assignmentAction>

but it does not work.

How can I assign current row's fuel value?