Hi there, I’m relatively new to Glide apps - absolutely loving it. I’ve hit a blockage with my app however and would be grateful for some advice. I have a number of tables with data users can submit about their homes. There are various columns within those tables that contain dates. What I’d really like to do is create a 'Calendar" page to display all those various dates. I’ve been able to do this using dates from just one of my tables, but how can I go about having a master calendar with dates from all the tables? I thought I could create a “Dates” table, but have no way of pulling in the various dates from elsewhere… Many thanks in advance.

you can copy columns in Google Sheets ={A:A;B:B} Glide does not have that option, you would have to join columns and split them… complicated but doable

Thank you Uzo. Most of my existing tables are Glide tables and I believe, for scalability it’s best to keep that way. So unfortunately, even if I use a Gsheet for this consolidated set of dates, I don’t think I can use Gsheet formulae to pull data from Glide tables. Unless I’m mistaken.

You can check this out. [image] Calendar: Multiple data sources feeding to one calendar Hi Nathan wave Here is how I would do it. I’ll would first bring my two date columns into the same table, I’ll assume you have done that. Now you need to merge/collate these two columns: one list of dates below the other and we need values (not arrays). You can use the screenshot below to follow along: RowID column RowIDsArray column: Do a lookup on the RowID column. RowIDIndex column: Do a “Find element index” on the RowIDsArray column. We already have our two basic date columns: Dates1, D…

Hello! Thank you for the link - it sounds like he/she has a very similar challenge… I’m actually stuck at the very first part of the proposed solution - “I would first bring my two date columns into the same table”. I suspect a very novice question, but how is it best to do that?

use the lookup column or join column, and point to the column with the dates [Screen Shot 2022-11-25 at 8.11.07 PM] [Screen Shot 2022-11-25 at 8.15.35 PM] [Screen Shot 2022-11-25 at 8.15.52 PM] [Screen Shot 2022-11-25 at 8.17.12 PM] [Screen Shot 2022-11-25 at 8.17.31 PM] [Screen Shot 2022-11-25 at 8.19.12 PM] [Screen Shot 2022-11-25 at 8.19.42 PM]

the tricky part is… you need to have the same or more rows in that table as all dates that you are bringing… so every time you add a new date somewhere, you need to add a row in this table.

OK yes, understood. I’m going to have a play with your solution as it looks like it could work :slight_smile: Assuming I can add a new row to my Dates table using the “on submit” feature. We’ll see. Thanks very much - I’ll let you know how I get on…

[image] c7y: I have a number of tables with data users can submit about their homes Just curious… why “a number” of tables and not just one table? Sounds like it’s similar data, in which case it would probably make sense to have it all in one table. Then you wouldn’t have the problem that you have now.

Nice Uzo, similar approach, same result. Your approach: you handle values, then arrays. Joined list Dates1. Joined list Dates 2. Template (join) Dates 1 & 2. Split (-> Array). Row index. Single value to create list of values from the array. My approach: I work with arrays immediately. Lookup Dates1 (-> Array). Lookup Dates2 (-> Array). Make array (join the array). Row index. Single value to create list of values from the array. Any reason you handle values at the beginning and not arrays?

in case you need to add some text, to make them unique when you have identical values… that would be needed to make rank… when you have identical values… row will be empty… but in this case, no need for it

Collecting all dates into one table for a calendar

Ask for Help

ThinhDinh November 26, 2022, 1:01am 4

You can check this out.

Topic		Replies	Views
Calendar: Multiple data sources feeding to one calendar Ask for Help	14	1586	November 10, 2023
I want to show dates from 2 different tables in a single calendar collection Ask for Help	3	615	January 28, 2023
Combine / join tables Ask for Help	4	372	May 15, 2024
Pivoting multiple date columns into one Ask for Help	26	370	November 18, 2024
Help With Calendar Ask for Help	9	149	March 1, 2025

Collecting all dates into one table for a calendar

Related topics