Lesson Category: Monthly Calendar Magic

See the Merge and Magic Miracle

In this lesson, the magic is about to unfold. We have our calendar prepared. We have our spreadsheet with dates. We’ve connected the two, and we’ve added fields that can be replaced with data from the spreadsheet. There’s only one thing left for us to do: merge the two and save the new file. (Oops, …

See the Merge and Magic Miracle Read More »

Why Are We Doing This?

In this module, we’re going to merge our calendar with our spreadsheet. This will allow all the dates to enter the calendar. Nice, right? This will have saved us a lot of work and typing. If you’ve gone through the Cute Calendar Printables course and did the exercises, you’ll know. When I made that course, …

Why Are We Doing This? Read More »

What Could Possibly Go Wrong?

It took me ten minutes to get started with this lesson… Reason: I browsed memes with the theme “what could possibly go wrong.” I couldn’t pick one because there were many good ones, so… no memes here. And back to the lesson: what could go wrong? Well, you may see no usable fields when you …

What Could Possibly Go Wrong? Read More »

This Is How to Do It

Right… We learn better when we stick our hands in and do it. So let’s add some field holders. You’ll see me do this step in the video further down. Start Affinity Publisher, and open the monthly calendar file you have prepared. Click the turret (little arrow) to view the master page and double-click it …

This Is How to Do It Read More »

Creating Place Holders

The way to tell Affinity Publisher where to add the name of the month and the dates is to mark all those places with place holders. It’s as easy to do as selecting a text and double-clicking a label. I’ll show you how to do it in the next lesson. For now, just think of …

Creating Place Holders Read More »

Why Are We Doing This Now?

Up until now, we have created an Affinity Publisher file with a master and one page. Both of these just say the word Month at the top and there are xx’s all over the place where there should be dates. We’ve created a spreadsheet that contains all 365 dates plus the name of the months. …

Why Are We Doing This Now? Read More »

Where Is It?

There is always steps that can go wrong. Here’s one way I can think of: you cannot find your spreadsheet. Do you remember what you called it? Or a few of the words? Then you can search for it on your computer. Or maybe check the folder you think you saved it in. Or you  …

Where Is It? Read More »

This Is What We Will Do Now

Will make a connection from our Affinity Publisher monthly calendar file to our spreadsheet. And we’ll do this inside Affinity Publisher. There we’re going to take advantage of a menu that allows us to connect with outside sources like our spreadsheet. Let me show you how to do this step…