Kind request for demonstration - Data Merge

[George86]

Hello

as much as I look around I cannot find proper solution to my problem. 

Just for the demonstration could some1 show me how to use Data merge with hyperlinks and anchors correctly?

 

In my dummy demonstration I am looking for:

1. 6 pages in total
2. the first, second and third page will have a list of 3 elements
3. each element would link to the other 3 pages (1. element would take me to 4th page, 2. element to 5th & 3. to the last 6th page)

(Adding a picture for better understanding)

How I would utilize .xlsx files in the example to the maximum potential?

[walt.farrell]

I don't think you can do that. As I understand it, the hyperlinks in the .xlsx file would be URLs to external web-sites or email addresses, not internal document links to anchors within the document. But I will admit some uncertainty, as the Help file does mention anchors as targets, though it does not say how (and in the "how" section it does not consider anchors, only URLs, email addresses, and file-names).

[firstdefence]

Could the Hyperlink be written in an .xlsx file as an Anchor so instead of it being Http:// it's #Page 6 or however Anchors are formatted in Affinity?