EatMoreBacon

Attached find templates for a birthday \ appointment calendar... A very simple basic one done only with Excel \ Libreoffice Extremely deluxe calendars designed with a data merge into Affinity Publisher. Attached are templates for monthly calendar Monthly Planner six months on one page twelve months on a large page Would be glad to hear suggestions for improvement. Thanks! DIY Birthday and Appointment Calendars.pdf Monthly Calendar template.afpub Monthly Planner template.afpub six month template.afpub twelve month template.afpub Calendar Worksheet, legacy.xlsx Calendar Worksheet, libreoffice.ods Calendar Worksheet.xlsx

Check your data merge layout settings. i suspect there are two data merges. One is going to need a -(number) in the offset to merge properly. Also check out this option...

I also found that doing a Lookup and returning actual text works. So I wonder if it has something to do with the custom formatting.

Viel Dank! That makes things clearer! Thanks a lot!

What confuses me is how does Affinity decide which Data Merge to do first? If there is more than one Data Merge Layout, the record offset has to be set to -n If i put the heading in a separate data merge (not data merge layout) can I set a record offset on that as well?

I'm frustrated. In template4, I have two data merge Layout. One is working as expected giving me the info for each date cell. The other is giving wrong values. Instead of the month and year as shown on spreadsheet, it gives 0000 2024 Instead of the Day of Week as shown on the spreadsheet, it moves all my days by one. I can find no reason for why it acts the way it does. I've double checked my formulas. I've tried pasting values (file attached). Any suggestions? Birthday Calendar template4.afpub Birthday Calendar trial.afpub Book1_exp.xlsx

If I have a Data Merge Layout for the main body of the page, can I use a separate data Merge for the heading on the page? I need 7 instances of the data Merge for the main body so I use data Merge layout. But I only want one instance of the heading...

So in any case, till the powers that be change something, I will need to use codes that I find and replace after the merge? Or is Alt 010 something that can be inserted in Excel?

When I'm doing a mail merge, Affinity doesn't seem to recognize Char 10 (line break). I also tried Char 13 which some say works on Mac (I'm on Windows), but that didn't work any better. What do I input in my spreadsheet to indicate a line break that Affinity Publisher will recognize?

Right, but each cell in excel will only go to one style in Publisher. So if I have several different styles for each N, I will need to have the same number of cells x 6 in each row of the spreadsheet. Thanks for that suggestion. I will have to think through my layout and decide what will work best. I guess it isn't possible to display a two page spread minus the margins so that the layout tool would ignore the gutter?

Ok, so basically I have to rework my spreadsheet to have all the data values for one row in my merge to be in one row in my spreadsheet. Will seem like lots of repeat cause I'm merging about 8 values to n and each value gets a different placement or different paragraph style in Publisher. But it can be done! Thanks!

but that gutter will apply to each row and column. i want three columns on the first page then a wide gutter and then three columns on the next page

When using the Data Merge layout tool - can my n-up layout span two pages? At the page gutter I need a little more space between the columns than I do otherwise. I want the merge to go row by row straight across the page break. So it would do 123 in first row on page 1, then 456 on first row on page 2, then 789 on 2nd row on page 1, etc

Thanks!

When using the data merge layout tool, I want to have a bounding box, except when certain fields are missing, I want no bounding box to appear. Is this possible?

Thanks for pointing those out. Either of those two, you need to manually change the number of rows if there are too many. I can do that. I was just wishing it were possible to do it automatically based on a value in the excel file.

I was looking to do a 12 month calendar. Most months need 5 rows. Some need six rows and if February starts on Sunday, it needs four rows. It would be relatively easy for Excel to figure out how many rows I need for each month. But I'm not clear if there is a way to pass that info along to Publisher when I do the data merge (with holidays, etc)?

Can I create multiple data merge layouts for a single document? (For example a catalog with varied page layouts or a calendar with varied number of week layouts) Can I then choose which layout I want to use for each page of the document based on a value in the CSV file?

Text styles works great But can I have text frame styles? Like for insets, borders, etc

I am having trouble understanding the Styles panel. I can save a new style or delete a style, but I'm not sure how to edit a style. Somehow it seems like a poor excuse beside Indesign's Object Styles. Thanks for the tip on Paste Style. Not a preferred method by any means, but will work for this project.

Can I set a text frame style to include a certain inset and fill? Then apply that style to multiple existing text boxes, so that they all have the same inset and fill?

Can I switch my numbered lists to plain text? So that what was 1. My text 2. More of the same now has the numbers 1 and 2 as editable text rather than a numbered list?

Is there any way to assign a keyboard shortcut to that middle handle?

I'd bite the bullet and be inclined to start from scratch. Thanks! I guess my biggest question is how do I avoid having it happen again. Near as I can tell, you have Superscript turned on for the default in the Character style [No Style]. Ok, that would be a problem. How do I change defaults in the No Style? Imported the text styles from the old document. How do you import text styles and be certain that you don't get any junk along with it? you have chosen an already used Keyboard Shortcut Yea, its one of the things I'm needing to relearn. With Indesign, you had to use the NumPad for text shortcuts. With AfPub that don't work, so I need to change my shortcuts and I didn't get to all of them yet. Sorry, I'm not sure how to quote other posts....

Here is the file I think I tried everything except starting completely from scratch. Minutes 2023-01-18 MCFL meeting correction copy.afpub