Data Merge Weekly Planner Pages in Affinity Publisher



*** CLICKABLE CONTENT INDEX BELOW ***
This time we’re Data Merging Weekly Layouts in Affinity Publisher. I’ll share two completely different ways to use Data Merge and explain when to use each method. Design a weekly spread once and use Data Merge to generate hundreds or even thousands of pages based on that design and custom information from your data source.

⏰ TIMINGS
00:00:00 – Start
00:00:38 – Introduction
00:06:20 – Examining the Redesigned Data Source
00:10:30 – Using the Data Merge Layout Tool to Add 4 Columns of Data on the Left Page
00:22:00 – Using the Data Merge Layout Tool to Add 3 Columns of Data on the Right Page
00:29:35 – Using the Data Merge Layout Tool to Add 7 Columns of Data Across 2 x 2 Page Spreads
00:37:20 – Using the Data Merge Layout Tool to Create a 7 Block Layout
00:44:00 – Understanding Data Flow Using the Data Merge Layout Control
00:51:32 – Using a Weekly Data Source to Create a 7 Block Layout
00:55:35 – Using the ISOWEEKNUM Function in Excel
00:56:43 – Concatenating 2 Dates in Text Format in Excel
00:57:43 – Creating a 7 Block Layout
01:07:30 – Wrap Up
01:14:20 – Q & A

💌 Want more free training? Check out: https://elainegiles.com/vip

❤️ Connect with me, I love to hear from you!

✍️ Blog: https://elainegiles.co.uk
🎬 YouTube: https://www.youtube.com/ElaineGiles?sub_confirmation=1
🐦 Twitter: https://twitter.com/elainegiles
📸 Instagram: https://www.instagram.com/elainegiles
🔗 LinkedIn: https://uk.linkedin.com/in/elainegiles
🟦 Facebook: https://facebook.com/elainegiles

#affinitypublisher #planner #datamerge

If you want to learn more about Affinity Publisher check out the recordings below:

💎 Affinity Publisher (FULL TUTORIAL): https://youtu.be/98cWyoStN_Q
💎 Mastering Page Layouts in Affinity Publisher: https://youtu.be/yqNwxPKMGcE
💎 Mastering Master Pages in Affinity Publisher: https://youtu.be/Kr5je_swyJU
💎 Mastering Text Styles in Affinity Publisher: https://youtu.be/b952gAxVnT0
💎 Working with Images in Affinity Publisher: https://youtu.be/FhpYQC5X2Cc
💎 Create Creative Tables in Affinity Publisher: https://youtu.be/8PiWMNzoVLQ
💎 Affinity Publisher: Build With Me: https://youtu.be/oghUASJ6zZQ
💎 Working with Colour in Affinity Publisher: https://youtu.be/PxyBqfL-dK8
💎 How to Create a Newsletter in Affinity Publisher: https://youtu.be/MKcdb6OGo7U
💎 Deep Dive Data Merge in Affinity Publisher: https://youtu.be/wav8wuucZUY
💎 Creating and Managing Assets in Affinity Publisher: https://youtu.be/2tp5hFOntiI
💎 How to Create a Table of Contents in Affinity Publisher: https://youtu.be/y3EPZWp2DhQ
💎 How to Create an Index in Affinity Publisher: https://youtu.be/BcJcV51JNxM
💎 Designing a Photo Book in Affinity Publisher: https://youtu.be/P904B6-C18A
💎 Advanced Photo Book Techniques in Affinity Publisher: https://youtu.be/h5EoiD4ffGY
💎 Design a Magazine in Affinity Publisher: https://youtu.be/d5BjWgbFG-I
💎 Create Tutorials in Affinity Publisher: https://youtu.be/KKH5Uoeqfls
💎 Create Planner Pages in Affinity Publisher: https://youtu.be/XTFCY8Yxewg
💎 Design an Interactive Digital Planner in Affinity Publisher: http://youtu.be/WS2VZLHBzd4
💎 Power Up Planner Page Creation with Data Merge in Affinity Publisher: https://youtu.be/cIb1OPDZnOk
💎 Creating Snapshots in Affinity Publisher (FULL Tutorial): https://youtu.be/VyUgucxu8_w
💎 Affinity Publisher Beta (FULL TUTORIAL): https://youtu.be/wDfq4zOmmKk

Duration: 01:33:36

source