# šŸ†• 20 new experimental code columns to play with **URL:** https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351 **Category:** General **Created:** [October 20, 2021, 2:24pm UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351 "2021-10-20T14:24:04Z") **Posts on this page:** 16 **Page:** 2
### Author: ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler) #### Post date: [October 24, 2021, 7:22am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/21 "2021-10-24T07:22:47Z")
Would love to understand how do I change the time zone of the Date Time Formatting? I inserted dd/MM/yyy HH:mm in the format parameter and it shows right but the result is +3 hours from the actual time in the date column. ---
### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy) #### Post date: [October 24, 2021, 7:37am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/22 "2021-10-24T07:37:42Z")
The general rule of thumb is that 1 is singular, and anything else (including 0) is plural. There are probably exceptions, but I canā€™t think of any off the top of my head. If you follow that, youā€™ll be grammatically correct at least 99% of the time. ---
### Author: ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M) #### Post date: [October 24, 2021, 7:46am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/23 "2021-10-24T07:46:43Z")
When you say 0.5 second / 0.5 dollar, itā€™s not even a second, so it should remain singular. When you get 0.9 billion dollars. It must be a paramount amount, but itā€™s still \< 1 billion. So singular. But dollars : plural. When statistics say that there is an average of 1.66 child / family, itā€™s not yet 2, so should remain singular too. ---
### Author: ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M) #### Post date: [October 24, 2021, 7:57am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/24 "2021-10-24T07:57:37Z")
Unless we can populate a customized glossary or full dictionary for exceptions, for now, the plural plugin cannot be used for french (so many cases). ---
### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy) #### Post date: [October 24, 2021, 8:13am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/25 "2021-10-24T08:13:31Z")
> [@L.M](#): > > When you say 0.5 second / 0.5 dollar, itā€™s not even a second, so it should remain singular. Nope, I would never say either. Always 0.5 seconds, never 0.5 second. Thatā€™s just _wrong_ However, if you were using fractions then itā€™s different. - Half a second: correct - Half a seconds: incorrect - 0.5 second: incorrect - 0.5 seconds: correct English is stupid. ---
### Author: ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M) #### Post date: [October 24, 2021, 8:24am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/26 "2021-10-24T08:24:22Z")
Itā€™s not stupid, Darren itā€™s different šŸ˜Œ We have much worse language issues in French (\*sighing like Snoopy šŸ™„) I thought nonsense was only part of this unique "Brit-English charm"šŸ‡¬šŸ‡§ā€¦ ---
### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy) #### Post date: [October 24, 2021, 8:39am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/27 "2021-10-24T08:39:07Z")
Well, when I say itā€™s stupid I mean stupid in the sense that it has many illogical and inconsistent grammatical rules. As a native English speaker, I can usually tell instinctively when something isnā€™t grammatically correct. But often I canā€™t explain why, because the rules are just too damned complicated šŸ¤Ŗ But yeah, Iā€™m sure English isnā€™t alone in this respect šŸ™‚ ---
### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto) #### Post date: [October 27, 2021, 12:57am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/28 "2021-10-27T00:57:05Z")
6 days later and @davidā€™s already given us 30 more plugins. Crazy! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/aca599eccd0ded02fdb73f96463fe9fe5e9f4e77.png) ---
### Author: ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david) #### Post date: [October 27, 2021, 1:11am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/29 "2021-10-27T01:11:23Z")
The whole team worked on them! ---
### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto) #### Post date: [October 27, 2021, 1:28am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/30 "2021-10-27T01:28:35Z")
Fun with [Color Palette](https://www.glideapps.com/plugins/color-palette) and [Image from Color](https://www.glideapps.com/plugins/color-to-image): ---
### Author: ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M) #### Post date: [October 27, 2021, 5:46am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/31 "2021-10-27T05:46:17Z")
If we can use JS, that means we can display background images cycling every n seconds, minutesā€¦ I assume this feature is still possible (used it back in 2002). or display parts of image by coordinates, instead of creating several images ---
### Author: ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup) #### Post date: [October 27, 2021, 3:41pm UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/32 "2021-10-27T15:41:53Z")
Does anyone have something for formating a phone number this way (###) ###-####? ---
### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero) #### Post date: [October 27, 2021, 10:57pm UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/33 "2021-10-27T22:57:49Z")
Hola @david, I think we need to put a kind of note or advice on Sort Array plugin: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/74e39c1d165ca44595fe26ed4fdf6e03a58194de.png) The plugin works fine when the array contains number or text values but if you create a **array of dates and use this plugin, the result is wrong** due to the code handles the dates as text/string and everything is a little mess. My PIC can give you an idea of this situation and the wrong order: January ( 1), October (10), June ( 6) and July ( 7). ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/85a691c6642216fc177353e7127e32a91f8de6a6.png). So far, my workaround to do it correctly is using this Jeffā€™s trick showed here (convert dates to number values): [Agent for information - #85 by Jeff\_Hager](https://community.glideapps.com/t/agent-for-information/29981/85) I hope it helps and avoid future problems. Feliz dĆ­a! ---
### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh) #### Post date: [October 27, 2021, 10:58pm UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/34 "2021-10-27T22:58:04Z")
What format do you currently let users type in? I assume 1234567890? ---
### Author: ![noobly\_channel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noobly_channel/32/24182_2.png) [@noobly\_channel](https://community.glideapps.com/u/noobly_channel) #### Post date: [October 28, 2021, 5:25am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/35 "2021-10-28T05:25:10Z")
For the love of all things decentā€¦Javascipt ā€œActionsā€ please. ---
### Author: ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa) #### Post date: [October 29, 2021, 7:58am UTC](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/36 "2021-10-29T07:58:54Z")
Great work @david and team šŸ”„ Would love to see a word count plugin - same as the text length but for words instead of characters. [Previous page](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351.md?page=1)