Date format locale struggle: sheet vs app

[avanavana]

A while ago I posted about these issues. I actually resorted to writing apps script to format the dates automatically for me:

(the below links to my earlier post, with annotated apps script)

Hello, and, On Extending Glide with Google Apps Script

Have to make an update to this thread: It’s known that the event picker widget, while providing an undeniably superior UX compared to, say, two date/time pickers (event picker has smaller chance for mistakes in user input, users can see context of other events when inputting data, one less form field, provides ‘confirmation’ or ‘preview’ of correct input, etc), is still quite buggy. Glide have assured me that these bugs are to be fixed in an update that will drop next week. The major bug that…