# Hello, and, On Extending Glide with Google Apps Script **URL:** \ **Category:** Ask for Help\ **Created:** [October 30, 2020, 5:20am UTC](https://community.glideapps.com/t/hello-and-on-extending-glide-with-google-apps-script/17751 "2020-10-30T05:20:03Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 30, 2020, 11:49am UTC](https://community.glideapps.com/t/hello-and-on-extending-glide-with-google-apps-script/17751/4 "2020-10-30T11:49:30Z")
> [@avanavana](#): > > The problem is, that would coerce the data into a String, and would result in all sorts of craziness, such as Fridays coming before Mondays, in a list that is supposed to be Chronological. Human-readable dates were an absolute requirement in this case, so something like 01-January-1900-Friday wasn’t possible. Dates needed to be rendered strictly in the `dddd, mmmm d, yyyy` format. I do what @ThinhDinh suggests. The template is a string but only used for grouping. The sorting still happens with the original date format column. Examples here: > [@new Grouping](https://community.glideapps.com/t/grouping/12711/38): > > I started playing with this a little bit yesterday. I didn’t need to do a formula in the sheet to format the date. Instead I just set the formatting in the date column and created a template column to “lock in” the date that was formatted within Glide. The template is what I use for grouping. I think the underlying issue is that the grouping will still actually use the underlying timestamp value, so if the days match, but the times don’t exactly match, then they are grouped separately. I di… Complicated sorts involving date and other values is a different story. If glide provided an ISO format option, then you could template that with other values, such as calculated duration to get the sort order you want. However, you could possibly subtract a seed datetime from the current datetime to get a numeric value, add the difference in event duration, then sort on that numeric value. It better yet, calculate the seed datetime from event datetime, then separately calculate duration, then template them both together. May or may not run into issues with number if digits, so might be best to add something like 10000 to each calculated result to get a consistent number of digits to the left of the decimal. I’m not knocking the use of scripts. I use then too, but Glide can be surprisingly powerful and much more responsive if you can accomplish the same thing exclusively within glide. If you want to play around with a concept and throw some random events at it, feel free here. It’s not perfect but I haven’t worked on it for awhile. > [@Playing with some of the new features](https://community.glideapps.com/t/playing-with-some-of-the-new-features/15984): > --- _[View the full topic](https://community.glideapps.com/t/hello-and-on-extending-glide-with-google-apps-script/17751)._