Hi everyone, So I know Glide is a “no-code” solution for many, but hear me out. I am a developer of 12+ years used to doing apps the “old-fashioned way”, but it’s obvious to me that Glide is the perfect solution for 99.9% of all the apps developers used to build, and I’m happy to use my technical…

I’m not sure what was going on here, other than I had multiple people inputting data from different devices, and for a few of these people, the data was coming in from Glide as a raw ISO-8601 time stamp, while from others it was not. Obviously lots of software uses this standard as an underlying f…

I’ll have to spend some time thinking about this and reading through old posts. How Glide works with dates has evolved over the past year or so. I’m still convinced that ISO is the deep down underlying value somewhere within Glide’s copy of the database, as demonstrated here. [image] Over a year…

Yeah, I have no doubt Glide is using ISO-8601… the problem is that is a format that doesn’t work in Google Sheets. Usually, if you have formatting on the column in Glide, this formatting goes into Google Sheets just fine, but it appears that on some users’ devices, the raw ISO format goes through a…

[image] Jeff_Hager: m still convinced that ISO is the deep down underlying value Hi Jeff, More than an year later :slight_smile: I’d like to convert the “Event start” and “Event end” values to ISO. Tried Luxon and a JS code column. Neither worked. Any ideas? Thanks

So you would rather see the raw ISO date? As long as the dates were entered using a date picker in glide, then I think you should be able to convert the date column to a text column, which should expose the unformatted version of the date.

If it isn’t picked by date picker, maybe try toISOString. [image] Date.prototype.toISOString() - JavaScript | MDN The toISOString() method returns a string in simplified extended ISO format (ISO 8601), which is always 24 or 27 characters long (YYYY-MM-DDTHH:mm:ss.sssZ or ±YYYY…

[image] Jeff_Hager: dates were entered using a date picker in glide, then I think you should be able to convert the date column to a text column Dates were entered using the Event Picker, not the Date Picker. Tried changing the column type to text, and to others, nothing worked. [image] T…

Just to give some context: What I’m trying to achieve is a URL for a Google Calendar event, as detailed here: InteractionDesignFoundation/add-event-to-calendar-docs/blob/main/services/google.md # Google ## Official documentation There is no official documentation for the current v…

Have you tried this? [image] Introducing Agical.io, the smarter ICS file generator If you've used Marketo's dynamic ICS files (the "Calendar File" token type) you're probably not completely happy with 'em. While undeniably useful, they lack certain key elements we're used to when sendi…

[image] ThinhDinh: create a calendar link Looks great. Can you please share an example of how you implemented it with Glide?

Hello, and, On Extending Glide with Google Apps Script

Ask for Help

ThinhDinh February 17, 2022, 11:55pm 13

If it isn’t picked by date picker, maybe try toISOString.

Topic		Replies	Views
Date format locale struggle: sheet vs app Ask for Help	42	2586	February 13, 2022
📆 Date/time formats General	82	7651	December 29, 2020
Add to Calendar Feature Requests	43	6455	December 8, 2025
Working on a calendar link generator Ask for Help	31	3652	September 14, 2022
🆕 Date-time Math General data-editor	126	14072	September 27, 2023

Hello, and, On Extending Glide with Google Apps Script

Related topics