George86 Posted December 7, 2023 Share Posted December 7, 2023 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: 6 pages in total the first, second and third page will have a list of 3 elements 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? Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted December 7, 2023 Share Posted December 7, 2023 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). George86 1 Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro, version 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro, version 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. iPad: iPad Pro M1, 12.9": iPadOS 17.4.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sonoma 14.4.1 Link to comment Share on other sites More sharing options...
firstdefence Posted December 7, 2023 Share Posted December 7, 2023 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? Quote iMac 27" 2019 Somona 14.4.1, iMac 27" Affinity Designer, Photo & Publisher V1 & V2, Adobe, Inkscape, Vectorstyler, Blender, C4D, Sketchup + more... XP-Pen Artist-22E, - iPad Pro 12.9 (Please refrain from licking the screen while using this forum) Affinity Help - Affinity Desktop Tutorials - Feedback - FAQ - most asked questions Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.