I’ve seen other posts on this, and the repeated answer seems to be that the data needs to be compiled into one table. What I’m struggling with is that I have two tables that are set up with user specific favorite columns. Is it possible to compile user specific scheduling data into one table, so that it can all be displayed on one calendar?
What do you mean by “user-specific favorite columns” and “user-specific scheduling data”? Can you show us an example of your data structure and how the favorite columns come into play here?
Hi, yes, hopefully I can explain and show it in a way that makes sense. Probably 90% of the calendar data is being pulled from my “talks” sheet, but I have a small amount of events that are on my “overview” sheet. Each of these sheets has a favorites column that is set up with a user specific toggle, so our attendees can toggle the specific sessions and events they plan on attending.
Then I have a tab set up as “My Schedule.” So, this will use the user’s login email to identify which sessions they have marked on the “talks” sheet as favorites and show them in the calendar that I set up to display that collection.
I was trying to figure out a way to do it as a relational column somehow? But I couldn’t figure out what columns I should be trying to match? Or if a relational column would even work in the scenario of user specific columns?
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.
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.
1 Like
Eeek, this one might be way over my head. A thought I just had though was that it feels like it should, in theory, be possible to use the users table as the source data for the calendar? But, there is no specific column on the user table that I can use to display the favorited sessions, even though shouldn’t all of that data be tied to the user’s profile?
It does tie to the user, but it still comes from different tables, so you still have to go through the steps above to bring them to the same helper table.