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 reall…

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 colum…

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 202…

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 y…

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 Dat…

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	1527	November 10, 2023
I want to show dates from 2 different tables in a single calendar collection Ask for Help	3	601	January 28, 2023
Combine / join tables Ask for Help	4	330	May 15, 2024
Pivoting multiple date columns into one Ask for Help	26	235	November 18, 2024
Help With Calendar Ask for Help	9	109	March 1, 2025

Collecting all dates into one table for a calendar

Related topics