You are viewing limited content. For full access, please sign in.

Question

Question

Duplicate the dataset from different table field into one consolidated table field.

asked on October 11

Hi all,

 

I'd like to know if there's posiblity to duplicate the dataset from different table field into one consolidated table field within a form?

 

Currently, I'm using Forms v10.4, when I try to populate the dataset back to the consolidated table field, it'll generally populate all the dataset on each row. 

 

However, I'm looking for each row for each row, not all row from other table field populate into just one field.

 

For better understanding, I'll attach the screenshot below for kind reference.

dataset.png
Standard Outcome.png
all row populate into one row.png
dataset.png (40.58 KB)
0 0

Answer

SELECTED ANSWER
replied on October 13

Hi Chan

You would need to call the ROW to capture only that line of data into the table.

Add a field such as ROWID into your consolidated Report, you can hide this later. In that field put the calculation =ROW(). This will populate the field with the ROW number in your consolidateReport.

Then in your BU1, 2 and 3 fields, use the following formula based on the BU table you are calling

=INDEX(BUtablename,BUfieldname,ROWID)

ie: =INDEX(BU_1,Month,ROWID)

ie: =INDEX(BU_2,Month,ROWID)

ie: =INDEX(BU_3,Month,ROWID)

As you add additional Rows to the Consolidated Report it will pull those ROW values from the BU Tables.

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.