Share
Explore

How to get Full Day Google Cal Events to show up in Table View

My attempt at showing multi-day events in all their respective days, not just on one day.

Question by Coby

Justin’s Solutions
Before implementing a solution, I’d suggest copying this doc

Copy doc

Here’s the Google Calendar pack table we’ll use for the solution:

Events
2
Search
Event
Start
End
1
Staff meeting
1/19/2021, 8:00 AM
1/19/2021, 9:45 AM
2
Rivals meeting
1/19/2021, 2:15 PM
1/19/2021, 4:00 PM
3
House Meeting
1/20/2021, 9:15 AM
1/20/2021, 11:00 AM
4
Shoot amazing video
1/20/2021, 9:30 AM
1/21/2021, 1:00 PM
5
Game Night
1/20/2021, 6:00 PM
1/20/2021, 9:00 PM
6
Traveling
1/21/2021, 12:00 AM
1/23/2021, 12:00 AM
7
Edit video
1/21/2021, 11:00 AM
1/21/2021, 1:45 PM
8
Wedding
1/22/2021, 12:00 AM
1/23/2021, 12:00 AM
There are no rows in this table


Solution #1: Less complex
This solution is less complex, but you have to be okay with seeing all your events as a bulleted list rather than a row per event. If you are dead set on seeing a row per event, head to solution #2 :)

Instructions
Create a table. I’m calling it
Add 3 columns and add the formulas for each (to see the formula, click on the column icon → edit formula):
Date - notice the “Value for new rows” formula in the “date options”
Events (can hide this once the Today’s meeting column is set up)
Today’s meetings
Pop open the formulas on each of these columns to see how to pull events from the table, and then format them in a bullet list.
You’ll need to add rows for each day of the week. Once you do that, I also suggest filtering this table to only show events for this week.
That’s it! You can now see the events listed in a bulleted list for each day of the week.

Meetings (simple)
0
Search
Date
Events
Today's meetings
1
Monday

2
Tuesday
Staff meeting
Rivals meeting
Staff meeting:
8:00 AM
-
9:45 AM
Rivals meeting:
2:15 PM
-
4:00 PM
3
Wednesday
Shoot amazing video
Game Night
House Meeting
House Meeting:
9:15 AM
-
11:00 AM
Game Night:
6:00 PM
-
9:00 PM
Shoot amazing video:
9:30 AM
-
1:00 PM
4
Thursday
Shoot amazing video
Edit video
Traveling
Shoot amazing video:
9:30 AM
-
1:00 PM
Edit video:
11:00 AM
-
1:45 PM
Traveling:
12:00 AM
-
12:00 AM
5
Friday
Wedding
Traveling
Traveling:
12:00 AM
-
12:00 AM
Wedding:
12:00 AM
-
12:00 AM
6
Saturday
Wedding
Traveling
Traveling:
12:00 AM
-
12:00 AM
Wedding:
12:00 AM
-
12:00 AM
7
Sunday

There are no rows in this table

Solution #2: More complex
I’ll admit, this isn’t the most elegant solution. But it should work if you’re super determined to have a schedule table that includes separate rows for multi-day events. Let me know if you have questions!

Step 1: Create a separate schedule table by typing /table. I’m calling it .

Step 2: Add the following two columns to your sync table:

Days included (text column)
Sequence(0,(thisRow.End-thisRow.Start)).FormulaMap(DateTimeTruncate(CurrentValue+thisRow.Start,"day"))

Add to modified events table (button column)
image.png
Action
thisRow.[Days included].FormulaMap(AddRow(

[Events (modified)],

[Events (modified)].Event,thisRow.Event.Url,

[Events (modified)].Date,CurrentValue

)
)

Disable if
[Events (modified)].Filter(Event=thisRow.Event).Count()>0

When you push the button, it splits multi-day events into separate rows. Or, if it’s a single-day event, it just adds that event as a row.

Step 3: Because events might move dates on Google Calendar, set up two buttons that a) clears ; and b) pushes all the buttons in to regenerate. Here are the buttons 👇

Clear events
Add rows to schedule

Periodically pushing these buttons will make sure your is relatively up-to-date with what is actually on your Google Calendar. But ain’t nobody got time to push buttons every time they make a change on their calendar, so on to the next step....

Step 4: Add an automation to periodically push the buttons for you
Ensure your table is syncing as often as you can under your plan (daily or hourly). Then, set up an automation that runs just as often to push both of those buttons. If you copy this doc you can pop open this automation under Settings. Make sure to turn the automation on!

Here’s a screenshot of the automation 👇

image.png
Step 5: And that’s it! Enjoy your custom schedule table below 🥂



Schedule
0
Search
Date
Event
Start
End
Tuesday
2
Staff meeting
8:00 AM
9:45 AM
Rivals meeting
2:15 PM
4:00 PM
Wednesday
3
House Meeting
9:15 AM
11:00 AM
Shoot amazing video
9:30 AM
11:59 PM
Game Night
6:00 PM
9:00 PM
Thursday
3
Shoot amazing video
12:00 AM
1:00 PM
Traveling
12:00 AM
11:59 PM
Edit video
11:00 AM
1:45 PM
Friday
2
Wedding
12:00 AM
11:59 PM
Traveling
12:00 AM
11:59 PM
Saturday
2
Wedding
12:00 AM
11:59 PM
Traveling
12:00 AM
11:59 PM


Events with buttons
2
Search
Event
Start
End
Days included
Add to modified events table
1
Staff meeting
1/19/2021, 8:00 AM
1/19/2021, 9:45 AM
1/19/2021
Add to modified events
2
Rivals meeting
1/19/2021, 2:15 PM
1/19/2021, 4:00 PM
1/19/2021
Add to modified events
3
House Meeting
1/20/2021, 9:15 AM
1/20/2021, 11:00 AM
1/20/2021
Add to modified events
4
Shoot amazing video
1/20/2021, 9:30 AM
1/21/2021, 1:00 PM
1/20/20211/21/2021
Add to modified events
5
Game Night
1/20/2021, 6:00 PM
1/20/2021, 9:00 PM
1/20/2021
Add to modified events
6
Traveling
1/21/2021, 12:00 AM
1/23/2021, 12:00 AM
1/21/20211/22/20211/23/2021
Add to modified events
7
Edit video
1/21/2021, 11:00 AM
1/21/2021, 1:45 PM
1/21/2021
Add to modified events
8
Wedding
1/22/2021, 12:00 AM
1/23/2021, 12:00 AM
1/22/20211/23/2021
Add to modified events
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.