Glide: Calculate Dates

[@kenadelglass7933]

Without a doubt you have the best videos on Glide!

[@RobertPetittoWA]

Very kind of you to say!

[@kenadelglass7933]

@@RobertPetittoWA I say that because your short actionable examples have answered many of my questions and have given me a deeper understanding of date manipulation options in Glide. Very practical.

[@DanChern-i7k]

Thank you for the lesson! Very useful information!

[@RobertPetittoWA]

Glad it was helpful!

[@oualidamirou5596]

Support from France 🇫🇷

[@RobertPetittoWA]

Appreciated!

[@lolilulelagaming3213]

nice feature , thanks for the tutorial

[@RobertPetittoWA]

You're welcome!

[@minprivataseriosakanal]

Very good videos thanks. I have a question. How do we make items of a collection show up daily, and be gone once we checked them, and then let them come back again the same time every day? (trying to build a habit tracker)

[@RobertPetittoWA]

Check out my checklist video. It should be the latest video that I’ve uploaded.

[@PatchitForward]

Excellent tutorial, but what about the instance when it has been more than 6 months since the form was submitted? Doesn't there need to be a third If/Then condition in the action?

[@RobertPetittoWA]

In my video, no. It’s checking to see if that six months out date is after today (still in the future). Once it’s past six months, then that six months out date is no longer in the future, and thus no longer satisfies that condition so it would allow the user to fill out the form.

[@PatchitForward]

@@RobertPetittoWA got it, thanks

[@ЕкатеринаЕвстафьева-п4ю]

Спасибо))) очень информативно

[@RobertPetittoWA]

My pleasure

[@prashanthkrishnakumar1761]

Can java script column use values from the same row or columns from relations directly using some sort of keyword to represent the column name ?

[@RobertPetittoWA]

That would be nice, but no. You would have to look up the values first into the table for the JavaScript column to be able to use them. What you’re referring to is inline lookups and is a feature we’ve been asking for a couple years now.

[@zigmortragudo4835]

Hi! How can we count the number holidays and or weekends?

[@RobertPetittoWA]

I need more context. In a given year? From a list of dates already recorded in the app?

[@zigmortragudo4835]

@@RobertPetittoWA In a given period. Like from December 1, 2022 - January 31, 2023.

[@Latest_moviesnow]

am trying to make an app where users can sponsor their products for a certain period of time maybe 1 day 1 week or 1 month then after that clears values itself help me know how I can do that. Your support will be highly appreciated

[@RobertPetittoWA]

Glide doesn't have time-based actions (eg. clear a value when time has been reached). However, they do have filtering and visibility conditions that are time based (eg. only show items where end date is on or after today).

[@Latest_moviesnow]

@@RobertPetittoWA am on free plan but can't find overlays buttons.