I'm having some trouble figuring out the data merge functionality for multiple page documents.
What I need to do:
Create a set of two sided cards, with text on both sides. I have an excel spreadsheet with a line for each card, with fields for the text for both sides (ie I don't have separate lines for side A and side B). The help guide explicitly mentions using the Record Origin for double sided sheets, so it seems that it should be possible to achieve.
I have tried to use the Data Merge Layout Tool, and have laid out four cards per page.
This works fine for the first side, and puts the correct data in subsequent cards.
However, when I add the Data Merge Layout Tool on the second page, it doesn't seem to work. I am able to get it to reverse the layout order for the card flip to work, but on the second page either none of my data is inserted, or it continues sequentially from the previous page (So I get the side B text for records 5-8, not the side B text for records 1-4).
To illustrate, what I need to get is:
Page 1
Record 1 Side A Text Record 2 Side A Text
Record 3 Side A Text Record 4 Side A Text
Page 2
Record 2 Side B Text. Record 1 Side B Text.
Record 4 Side B Text. Record 3 Side B Text.
Page 3
Record 5 Side A Text. Record 6 Side A Text
Record 7 Side A Text Record 8 Side A Text
etc
What I get is:
Page 1
Record 1 Side A Text Record 2 Side A Text
Record 3 Side A Text Record 4 Side A Text
Page 2
Record 6 Side B Text. Record 5 Side B Text.
Record 8 Side B Text. Record 7 Side B Text.
Page 3
Record 9 Side A Text Record 10 Side A Text
Record 11 Side A Text Record 12 Side A Text.
