Calendar from multiple tables

[ThinhDinh]

I think you can explore something like this:

• A query to get all “favorited” events from “Talks”.
• A query to get all “favorited” events from “Overview”.
• A lookup to get all favorited rowIDs from “Talks”.
• A lookup to get all favorited rowIDs from “Overview”.
• A Make Array column to join those two lookups into a single array of rowIDs.

Transpose Columns to an Inline List: The Miracle Method

I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD]

Use this method to transpose that list of IDs in a new helper table. Add as many rows as you might need.

• Use two relations to try to link each rowID back to their “Talks” and “Overview” table.
• Use lookups to pull over titles, start times and end times from each relation.
• Use if-then-else columns to get the final titles, start times and end times (since only one from each pair of columns for those can contain a value).
• Use those values for your Calendar.