Jump to content
Eugene Tyson

Calendar Automation (sorta) - Tables Feedback

Recommended Posts

I'm going to use a Calendar as a way of showing a few useful features I found out - and some suggestions.

Firstly, dragging out a table is great! Select the Table icon in the tool bar, select the Snapping tool to get it to snap to the margins, and simply Drag Out the table - you will see it gives dimensions - rows and column counts too! Pretty cool!

There are only a few modifier keys available. A modifier key is when you are using the mouse to move/alter something and press a key on the keyboard to get it to behave a different way.

  • Shift = constrains proportions
  • CMD = sizes from the centre point where you clicked on the screen

What I think is missing is a modifier key to allow the amount of rows and columns  - simple arrow keys could add and remove rows and columns would be super useful!



For this calendar - I only want the First 3 rows to appear. Month - Days - Dates

I draw out the table and let go of the mouse and low and behold - I have 7 (that was lucky) columns and 3 rows, as I only dragged down that far.


The added feature that's pretty cool!

With the Table tool still selected - you can drag down the table from the tab as indicated. Or similarly - on the right hand side, grab the tab and drag to add more columns!

You can slide them up and down or left and rigth until you have the desired amount of columns or rows.


However, once you have made your decision - you cannot remove the rows/columns by dragging them back up. I presume this is to prevent deleting information accidentally, however, if the cells are empty I don't see why this can't be done :)

If you want to remove the column/row you can select it and right click and choose Delete Row

However if you have more than one row/column selected you cannot choose to Delete Rows!

1859700407_ScreenShot2018-09-05at10_19_49.png.d41ccb2e7394b7c89a660d7209d2e8d1.png        No option to Delete Rows 921091789_ScreenShot2018-09-05at10_19_58.png.bd8172841b7a9d7a19dba1e172361f9f.png

To delete more than one Row/Column you have to use the Table menu and choose "Delete Rows" or "Delete Columns"




Onto the calendar!

Select the top row and right click and choose Merge Cells



View>Studio>Table (I believe this menu and sub menus are subject to change)




Select your table and add some "Insets" so the text doesn't butt up against the cell wall - this is optional and you can adjust to how you like. 

Very important to ensure you're on the CELLS portion - there is an option for the FRAME - which is above in the screenshot of the Table  Panel, this is relating to the Frame the table sits in and not the Table Properties.

That's a bit confusing becuase you'd expect the Table options to the forefront of the options, however, not a major issue! 


In fact it's all optional - I'm leaving mine plain because I want to show another feature.

Insert the Month top row - days on the 2nd row - and leave the 3rd row blank.


Select the entire 3rd row and go to View>Studio>Paragraph

568102750_ScreenShot2018-09-05at10_34_05.thumb.png.49d5a11725330ce0af0be7ed8cb254b4.png   Expand the Bullets and Numbering List!   579763197_ScreenShot2018-09-05at10_34_48.thumb.png.a988e0dec272e4f1b3a18e6d728fd07c.png   



Choose 1. 2. 3. 4.  2030736353_ScreenShot2018-09-05at10_36_13.png.37fea88bfccbf49770280bf3bbdde1d7.png   Change the text section to read as. 1454954294_ScreenShot2018-09-05at10_36_51.png.fe2b03239c921f6ec3a749bf129933b0.png


Note - when you edit this panel option - you need to hit Return - this shouldn't be the case - if you don't hit return your changes won't be implemented. 

Your table should now look like this!



Grag the TAB as shown before - to expand the table to add more rows. 



January 2019 starts on a Tuesday (any calendar will tell you that :) )

Cool feature! You can select cells noncontiguous - that means they don't have to be beside each other. 

To do this - select the A3 cell - then let go of the mouse to leave it highlighted. Press the CMD key (possibly CTRL on PC) which is the "modifier key" then select the remaining cells. 

From the List Type in the Paragraph Panel - you can then set this to NO LIST.



Your table will now automatically renumber to ensure all the days have the correct number assigned.



Drag the handle down on the side of the table -  to make it fill the page! 



Select the numbered rows - right click and select distribute rows evenly




Duplicate your page




Rename Month to February 

January ended on a Thursday - so February starts on a Friday and February 2018 has 28 days. 




Select the first 3 days - and set the Paragraph Numbering to No List



Voila! February is Done! 



Add your icons! 




Now you can repeat the steps to make the remaining calendar months! 

Screen Shot 2018-09-05 at 10.14.42.png

Screen Shot 2018-09-05 at 10.24.56.png

Screen Shot 2018-09-05 at 10.29.35.png

Screen Shot 2018-09-05 at 10.44.55.png

Screen Shot 2018-09-05 at 10.45.52.png

Screen Shot 2018-09-05 at 10.45.45.png

Screen Shot 2018-09-05 at 10.44.55.png

Screen Shot 2018-09-05 at 10.45.45.png

Screen Shot 2018-09-05 at 10.57.00.png

Edited by Eugene Tyson
Some images repeated for some reason...

Share this post

Link to post
Share on other sites

Fab work Eugene, I'm going to digest this over the next couple of days. Need to get my head around this shortcut for populating the dates for each month, I did mine manually per month. :/

I noticed if you just click the tab that you used to drag for more rows, you get a pop out with a counter, handy for larger number of rows. :27_sunglasses:


Share this post

Link to post
Share on other sites

Thanks! @GaseousClay Yes a lot of people insert the dates manually - which leaves room for errors.

If you automatically number the cells using Numbering in the Paragraph panels, you can avoid costly mistakes! It's virtually impossible to make a mistake, unless you start on the wrong day! 

As a sidenote: in my youth I designed a comic book called Gaseous Clay, a boxer who won by farting out his opponents - needless to say it never took off - funny though that it's your username, brings back memories... 

Share this post

Link to post
Share on other sites


I decided on my username from the fact my surname is Clay, a mate at school used to call me Cassius but I never was much of a fighter. Though I do suffer with a lot of wind. :$

Share this post

Link to post
Share on other sites
2 minutes ago, Seneca said:

As suggestion you once you complete January save the style of this table.

Then you can apply this style to subsequent months. Of course you could also copy and paste the first table and change the details there.

Great work.


Yes - I was going to get into the Table Styles but the post was quite long as it is. 

Table Styles are definitely 100% the way to go! 

Share this post

Link to post
Share on other sites

This came up on another thread here somewhere but can't find it at the moment...

Select each column of the table where numbering is desired.  Under "Bullets and Numbering" in the Paragraph panel, select the numbering type, set "Name" to a unique value for each column, and set "Restart numbering" to "Below Current Level".

Share this post

Link to post
Share on other sites
On 9/5/2018 at 11:08 AM, Eugene Tyson said:

January 2019 starts on a Tuesday (any calendar will tell you that :) )

Alternatively, you can use the handy little formula

W = k + [ 2.6 m - 0.2 ] - 2 C + Y + [ Y / 4 ] + [ C / 4 ] mod 7
      where [] denotes the integer floor function (round down),
      k is day (1 to 31)
      m is month (1 = March, ..., 10 = December, 11 = Jan, 12 = Feb)
             Treat Jan & Feb as months of the preceding year
      C is century (1987 has C = 19)
      Y is year (1987 has Y = 87 except Y = 86 for Jan & Feb)
      W range is [0=Sun,...,6=Sat]

This formula is good for the Gregorian calendar (introduced 1582 in parts of Europe, adopted in 1752 in Great Britain and its colonies, and on various dates in other countries).

It handles century and 400 year corrections, but there is still a 3 day / 10 thousand year error which the Gregorian calendar does not take into account.

Alfred online2long.gif
Affinity Designer • Affinity Photo • Windows 10 Home (4th gen Core i3 CPU)
Affinity Photo for iPad • Affinity Designer for iPad • iOS 12.1.4 (iPad Air 2)

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now