anto Posted March 7 Share Posted March 7 Similar topics have already been discussed here. Maybe this is a little different. Objectives. An A4 book consists of photos and captions and is created by merging data. There are 2 photos and captions on one page. How to number the photo captions? I tried to create a style right before the merge, but it doesn't work. After the merge, all captions are numbered 1. If I create a style and try to change it to numbered after the merge, it doesn't work either. All captions are numbered 1. Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted March 7 Share Posted March 7 In the Bullets & Numbering section of the Paragraph Text Style there's a Name field, and a Global box. You need to specify a name, and mark it Global. That provides a counter that covers more than the current text frame. I can't provide a desktop screenshot at the moment. Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1 Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 3 hours ago, walt.farrell said: In the Bullets & Numbering section of the Paragraph Text Style there's a Name field, and a Global box. You need to specify a name, and mark it Global. That provides a counter that covers more than the current text frame. I can't provide a desktop screenshot at the moment. This does not work 2024-03-07 17-36-44.mp4 Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted March 7 Share Posted March 7 What are the Text Styles that are assigned to each of those fields where it's not working? A sample document showing the problem would be useful (before, and after the data merge operation). Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1 Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 3 minutes ago, walt.farrell said: What are the Text Styles that are assigned to each of those fields where it's not working? A sample document showing the problem would be useful (before, and after the data merge operation). I showed it in the video. After the merger, all numbering is 1. Westerwälder 1 Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted March 7 Share Posted March 7 1 minute ago, anto said: I showed it in the video. After the merger, all numbering is 1. You did not show what text style is assigned to each entry. You would need to put the cursor in an entry to demonstrate that. You did not even have continuous numbering before the data merge, which should indicate that the two fields shown before the merge did not have the proper text styles assigned. Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1 Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 6 minutes ago, walt.farrell said: You did not show what text style is assigned to each entry Style is "Style". It shown in video. Westerwälder 1 Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted March 7 Share Posted March 7 12 minutes ago, anto said: Style is "Style". It shown in video. Yes, you have a text style named Style. I am not questioning that. You have not shown that the Style text style is assigned to the captions in your document (before the merge), nor have you shown what text style is assigned to the captions after the merge. Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1 Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 7 minutes ago, walt.farrell said: You have not shown that the Style text style is assigned to the captions in your document (before the merge), nor have you shown what text style is assigned to the captions after the merge. I did not understand anything. There is one text field that is assigned to this style. This text frame should be numbered. The captions are taken from the excel file. Quote Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 9 minutes ago, walt.farrell said: what text style is assigned to the captions after the merge. Does it change during the merger process? The same "Style" Quote Link to comment Share on other sites More sharing options...
MikeTO Posted March 7 Share Posted March 7 Anto, try changing "Restart Numbering" to "Manual Only". You can find instructions on how to use named lists in my manual. Page 105 (PDF page 113) in the section titled "To create a named list for global numbering". Cheers, Mike bbrother 1 Quote Download a free PDF manual for Affinity Publisher 2.5 Download a quick reference chart for Affinity's Special Characters Affinity 2.5 for macOS Sequoia 15.1, MacBook Pro 14" (M4 Pro) Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 16 minutes ago, MikeTO said: Anto, try changing "Restart Numbering" to "Manual Only". This is does not work. Quote Link to comment Share on other sites More sharing options...
MikeTO Posted March 7 Share Posted March 7 3 minutes ago, anto said: This is does not work. I think we'll need more information - can you share a test document? Here's a demonstration of how to do it. Named lists.afpub anto 1 Quote Download a free PDF manual for Affinity Publisher 2.5 Download a quick reference chart for Affinity's Special Characters Affinity 2.5 for macOS Sequoia 15.1, MacBook Pro 14" (M4 Pro) Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 From Affinity help: "The Name setting lets you name your new list format and set it as a global format which can be used across the document" What is this name for, where is it stored, how can it be selected in the document? The help does not say anything. Why name a format and where to use it later? This is one problem. The other is that it doesn't work with data merging, or I'm doing something wrong. Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted March 7 Share Posted March 7 1 minute ago, anto said: What is this name for, where is it stored, how can it be selected in the document? The help does not say anything. Why name a format and where to use it later? You define the name in the text style definition (or in the paragraph panel) and it is used to link one usage of that text style to another usage of it, and thus to enable continuous numbering across paragraphs. You do not use it later, except indirectly by using that text style again. Please, give us a sample document, and we will probably be able to tell you what the problem is and how to solve it. Communicating solely via videos is very inefficient. anto 1 Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1 Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 1 minute ago, walt.farrell said: You define the name in the text style definition (or in the paragraph panel) and it is used to link one usage of that text style to another usage of it, and thus to enable continuous numbering across paragraphs. You do not use it later, except indirectly by using that text style again. But where saved all names of formats? Quote Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 4 minutes ago, walt.farrell said: Please, give us a sample document This is just schematic data. capt.afpub caption.xlsx Quote Link to comment Share on other sites More sharing options...
bbrother Posted March 7 Share Posted March 7 40 minutes ago, MikeTO said: Anto, try changing "Restart Numbering" to "Manual Only". @MikeTO this solves the problem. I had no problems with numbering the captions after data merge. APub_adding_numbers_after_merge.mp4 anto 1 Quote Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 It worked when I unchecked Restart numbering now in the Paragraph panel. But I don't understand one thing. If you select No list in the paragraph panel and add numbering in the text style, it does not work. And if you select numbering on the Paragraph panel, the style can be No list. How is it related? Something is very confusing. Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted March 7 Share Posted March 7 6 minutes ago, anto said: It worked when I unchecked Restart numbering now in the Paragraph panel. But I don't understand one thing. If you select No list in the paragraph panel and add numbering in the text style, it does not work. And if you select numbering on the Paragraph panel, the style can be No list. How is it related? Something is very confusing. If you are using a Text Style, you can override aspects of it in the Paragraph panel. It sounds like that's what you did. bbrother 1 Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1 Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 It seems that problem was in Restart numbering now. If you check Restart numbering now in Text style, Publisher automatically check it on Paragraph panel. When you uncheck it on Paragraph panel it does not unckeck it in Text style. I don't know if it affects anything. Quote Link to comment Share on other sites More sharing options...
bbrother Posted March 7 Share Posted March 7 7 minutes ago, anto said: But I don't understand one thing. If you select No list in the paragraph panel and add numbering in the text style, it does not work. And if you select numbering on the Paragraph panel, the style can be No list. How is it related? Walt is right. When you apply a style with numbering first and then make change to nonlist in a paragraph panel youre overriding the text style. You can verify this while checking if you see an + in the "Current formatting" box that displays the formatting applied to the selected text or at the current caret's position. It's that box↓ Quote Link to comment Share on other sites More sharing options...
Old Bruce Posted March 7 Share Posted March 7 Just now, anto said: When you uncheck it on Paragraph panel it does not unckeck it in Text style. I don't know if it affects anything. The Paragraph Panel is for overrides. Meaning a change there will not change the Paragraph Style, just that one paragraph, or as many as you have selected in the text flow. Quote Mac Pro (Late 2013) Mac OS 12.7.6 Affinity Designer 2.5.5 | Affinity Photo 2.5.5 | Affinity Publisher 2.5.5 | Beta versions as they appear. I have never mastered color management, period, so I cannot help with that. Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 Thank you all. Cool that it worked. Now you can begin the most difficult work of arrangement. walt.farrell 1 Quote Link to comment Share on other sites More sharing options...
anto Posted March 7 Author Share Posted March 7 I have one more question. The book should have vertical headers on the outer sides. Is it better to first merge the data without spreads, and then make spreads in the combined document and assign the corresponding master pages to even and odd pages? Is there an easier way? Quote 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.