Hello, so I’m making a planner and I want to add dynamic dates, so what I did is customizing a paragraph style with a numbering list, it works fine until I start the second column, apparently, it's giving the priority to the first page (the right one), and I want it to continue across the spread, is it possible to do that in paragraph style? Or in any other way? I tried data merge, but it doesn’t seem suitable to my kind of planner nor does the text variables. Thanks in advance
I don't think that you can do it they way you are attempting. you can however do a data merge with the correct spreadsheet. I do a lot of calendars and I set this up a few years ago. I can set you up with the excel file and instructions for how to update it if you are interested. The setup that I have merges the entire month per record with extra fields for the little calendars and other extras.
It is slightly tedious to set up the original excel and data merge, but once it's established, it's VERY easy to update for future versions. Doing a couple find/replace updates the year and for the Gregorian calendar (with the exception of leap year) the days only shift forward one day Monday -> Tuesday every year so you can grab the whole block and shift it over, and the weeks that go back to "1" you just shift those.
For the little bit of adjustment to the sheet every year, it guarantees that you won't have any days entered wrong.
Couple other important things, set up all your pieces for the main calendar as separate text boxes for each day, add how you are going to add in the 6th week row, and then after you do the data merge you can just delete from the months that don't have it. If you are doing the little calendars, set them up as a paragraph block with tabs, if you set up the block and tabs correctly, you don't have to figure in any carriage returns. Finally, use character and paragraph styles, it makes changing things after your merge so much easier.