Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Repeat date same as the repeating row above

Avatar

Level 9

I created a Travel Expense Report.

The user enters receipt information on each row.

They click a button to add another row and another receipt.

The first cell (Column A Row 1) is a auto-generated row number (1,2,3, etc...) based on the instanceManager count.

I would like to make this numbered cell a button that the user can click to add the same date they entered in the row above.

I know how to number it by using the caption, but cannot figure out how to do the rest of the script.

FormScreenPrint.JPG

1 Accepted Solution

Avatar

Correct answer by
Level 10

Assuming the row is named 'Row' and the date field 'DateField' the script in FormCalc will be:

DateField = Row[-1].DateField

In JavaScript it will be a bit more complex:

DateField.rawValue = Table.resolveNode("Row[" + (this.parent.index - 1) + "]").DateField.rawValue;

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Assuming the row is named 'Row' and the date field 'DateField' the script in FormCalc will be:

DateField = Row[-1].DateField

In JavaScript it will be a bit more complex:

DateField.rawValue = Table.resolveNode("Row[" + (this.parent.index - 1) + "]").DateField.rawValue;