Hey Gliders, I have a google sheet with a list of crops. Each crop has two date columns - Ready for Harvest and End of Harvest. I have another glide table called “What’s available” with a column of all Mondays from June through August. So for e.g. row 1 - June 5, 2023 row 2 - June 12, 2023 and …

Glide is releasing the Query column later this week. I’m not sure, but I think it could help address your request nicely. [image] new Query column! This request has been brought to life. See Mark’s video here. [image] Conditional Relations Featur…

Woah! This must be how it feels to get a wish granted by the geni(us) at Glide! :pray:

It is a simple JavaScript… i can write it for you

It’s in production already, you just need to enable it in Previews. @Food2Soil curious how this turns out for you. If you can share some screenshots of sample data, we can brainstorm together!

Enabling Query preview and using it in the Harvest Calendar sheet worked for a split second. I could see the results and then it wiped off. Sharing screenshots. Is it a glitch in query or is there something I am doing wrong. [query]

That’s weird. Can you refresh the tab and try again? I think you’re quite close to your solution.

I’m not sure, this is typically the type of situation where I would need to tweak with a real example and see the output, but try changing the configuration of your Query Column: Ready For Harvest is on or before Week And End of Harvest is on or after Week

it is working now. I just tried a few random things like deleting the glide table and starting over. and then playing with things like ‘before’, ‘on or before’ etc. Those didn’t work. What worked is setting a relation column between the Harvest Calendar (Glide Table) and Crop sheet. and then using t…

A Query on the Relation? Either way, congrats for making it work!

Mondays between two dates

Ask for Help

nathanaelb May 4, 2023, 10:09pm 2

Glide is releasing the Query column later this week. I’m not sure, but I think it could help address your request nicely.

Topic		Replies	Views
Array with all dates in between Ask for Help	27	1179	May 13, 2024
Can I get a list of all dates between 2 date columns? Ask for Help	6	1342	February 15, 2022
Query data using two date columns Ask for Help	4	167	December 27, 2023
Show field beetween 2 date ( start - end ) Ask for Help	1	219	October 17, 2023
Create a List of specific Relation Items Ask for Help	13	537	May 4, 2023

Mondays between two dates

Related topics