heyfletch

Ok, sounds good. I'll probably start with a TOC for future projects now that I understand more, but will attempt to just manually do the hyperlinks for this smaller one since it's just a couple I need to update. I'll be on the lookout for the hyperlink issues you mentioned. Thanks Hangman!

Actually, this is what I'm already doing. I have one XLSX, but added twice to the Data Merge Manager (I've also done it with 2 different files, but one file seems more stable). In my main Publisher doc, I have 2 data merge grids. So, one Generate does all the data merging I need. Would that change your recommendation? I read the TOC guide per your suggestion, and that's a lot more work formatting headings, etc. than what I current have... which is just 4 simple hyperlinks to where I need to go... I just would like a way to automatically update the page numbers.

Hey thanks, for your response. Just so I understand, are you saying I would need to first do the Data Merge which creates a new file, and THEN insert a TOC? Or, can I create the TOC in the main Publisher doc, run the data merge, and then UPDATE the TOC? Because the former doesn't seem easier than me just going into the data-merged document and just updating the #s. If I'm understanding correctly.

First-time Affinity Publisher user here. I am creating a custom table of contents that links "Page 3" to page 3, etc. But some of the pages I need to link to will only be created after Data Merge. I have 2 different data merges in the same file. Specifically, I want to link to "House Bills". House Bills is page 7 in my Publisher file, but there is a data merge before that, so after data merge, it becomes page 15. If there's a way to link to "House Bills" regardless of what page number it is, that would be great. In addition, but not as important, I would like a placeholder field that automatically updates upon data merge with actual page numbers. I.e., in my table of contents, I am hard-coding the # 15 because as of now, that's where House Bills ends up. But that could change, and I would like the data-merged document to automatically update to whatever the page is. However, if this is too tricky, please don't hesitate in answering the rest of the question. Since I am new, I don't know the differences between hyperlinks, bookmarks, cross-references, anchors, etc., so if you could kindly respond assuming I know nothing, that would be great!