# šŸ†• Format Date Plugin **URL:** \ **Category:** General\ **Created:** [October 21, 2021, 3:30pm UTC](https://community.glideapps.com/t/format-date-plugin/33411 "2021-10-21T15:30:28Z")\ **Posts on this page:** 20\ **Page:** 2
**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 21, 2021, 4:23pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/21 "2021-10-21T16:23:37Z")
> [@L.M](#): > > I tried with a french format JJ/MM/AAAA and an appropriate token like DDD, it does not seem to react. I am not quite sure how flexible the parsing is. It uses JavaScriptā€™s `Date.parse()`. I should add an optional `Input Format` argument so you can help it interpret the input date. @L.M please file an issue here: [Issues Ā· glideapps/glide-code-columns Ā· GitHub](https://github.com/glideapps/glide-code-columns/issues) ---
**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 21, 2021, 4:24pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/22 "2021-10-21T16:24:35Z")
Escaped Text = URL friendly strings. Sometimes I need to send this value via a webhook or include it in the middle of a URL (not as a parameter in the construct URL) Website Validator: true/false does it return a 404 or not ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [October 21, 2021, 4:32pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/23 "2021-10-21T16:32:22Z")
> [@Jeff\_Hager](#): > > I would like to see a raw math column that lets me plug in a complete formula from a user entered string. Something so Iā€™m not tied to a preset formula in a math column. Yes please. Would make calculations so much simpleršŸ‘ ---
**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 21, 2021, 4:36pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/24 "2021-10-21T16:36:57Z")
Oh thks, David. Iā€™m not sure itā€™s appropriate for me to file an issue at this early stage. Without knowing the general expected behavior and entry format. I have not even installed a single plugin yet. There are lots of countries here, there must be some patterns weā€™ll end up noticing all together to bundle the issue if it happens to be one. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [October 21, 2021, 4:37pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/25 "2021-10-21T16:37:06Z")
> [@david](#): > > I am also taking requests for new columns. Hi, donā€™t know if itā€™s in the scope of these columns: checking if an url is compatible with webview, and return 1 if yes This enables us to display url entered by users either in webview (best) or via a link (with visibility condition) ---
**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 21, 2021, 4:48pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/26 "2021-10-21T16:48:33Z")
Donā€™t know if itā€™s in your scope, I love the mesh and triangles generate image šŸ¤Ž. Iā€™m just gazing at them as they move, fascinating šŸ˜ƒ However, they appear paramount whenever I want to display them in layouts, in place of user profile pic, I mean. Can you allow resizing? Or icon column (not an emoji) to display an icon according to its number, name, whatever. Also, can you enable to desaturate the emojis (grey version) = more elegant and unobtrusive. VoilĆ  šŸ™‚ Thks for your attention, David. šŸ„ā˜•šŸ„ ---
**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 21, 2021, 5:11pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/27 "2021-10-21T17:11:49Z")
A Randomize column, maybe? (you asked for that, didnā€™t you, BTW, @Robert_Petitto?) Or any formula that Google Sheets can compute, in short & as a rule. Thks šŸ™‚ ---
**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 21, 2021, 5:37pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/28 "2021-10-21T17:37:16Z")
Random Number would be nice. Set min/max threshold. Or Random Value within an array. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [October 21, 2021, 5:45pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/29 "2021-10-21T17:45:38Z")
> [@david](#): > > I am also taking requests for new columns. I also think that **ā€œpretty time / dateā€** would be such a killer ---
**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 21, 2021, 5:51pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/30 "2021-10-21T17:51:02Z")
> [@V88](#): > > ā€œpretty time / dateā€ Uh? Whatā€™s a ā€œpretty time / dateā€, pls ? šŸ™‚ ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [October 21, 2021, 6:37pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/31 "2021-10-21T18:37:40Z")
Sorry. To be clear. Itā€™s when you want to display a timestamp in a friendly manner relative to now. For example ā€œ2 mins agoā€, ā€œan hour agoā€, ā€œ5 days agoā€, ā€œ3 weeks agoā€ or ā€œin 3 hoursā€. Make sense? ---
**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 21, 2021, 6:43pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/32 "2021-10-21T18:43:32Z")
Yes! And in the same set of ideas, Iā€™m using as captions for progress bars 100 % completed or 59 % in progress or 12 % started with template columns, but it would be more clever to get the conditional text automatically depending on the range of values. As you put it ā€œin a pretty wayā€. Which would be pretty cool šŸ¤  ---
**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 21, 2021, 6:49pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/33 "2021-10-21T18:49:52Z")
Does it work in the future? by the end of the week next Friday in 2 monthsā€™ time (for friendly deadlines) and this morning, tonight, etc. To be more user POV. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [October 21, 2021, 7:07pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/34 "2021-10-21T19:07:02Z")
Ultimately itā€™s down to whoever writes the plugin to determine the rules (@david in this case, during hie coffee break) ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [October 21, 2021, 7:42pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/35 "2021-10-21T19:42:45Z")
@david Does the fetch column have cache? ---
**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 21, 2021, 10:21pm UTC](https://community.glideapps.com/t/format-date-plugin/33411/36 "2021-10-21T22:21:18Z")
> [@SantiagoPerez](#): > > Does the fetch column have cache? Press this button to view the source code and see for yourself: ![CleanShot 2021-10-21 at 15.20.39@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/0716446744a104589ba5f2f473497e87bab9c989.jpeg) ---
**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 22, 2021, 12:49am UTC](https://community.glideapps.com/t/format-date-plugin/33411/37 "2021-10-22T00:49:52Z")
For extra brownie points, make one that supports [Discordian Time](https://en.wikipedia.org/wiki/Discordian_calendar) šŸ˜† ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [October 22, 2021, 7:40am UTC](https://community.glideapps.com/t/format-date-plugin/33411/38 "2021-10-22T07:40:02Z")
Number 5. That is an interesting site. I know my users would love hashtag suggestions. > **[Hashtag Generator for text API | RiteKit](https://ritekit.com/api-demo/hashtag-suggestions)** ---
**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\ **Post date:** [October 22, 2021, 7:45am UTC](https://community.glideapps.com/t/format-date-plugin/33411/39 "2021-10-22T07:45:37Z")
David, what about problems with Experimental columns? Is it only me who needs to put all XC values into components to see their values in Set Column Values, trigger webhook, Copy to Clipboard, etc? When is this expected to be solved? ---
**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\ **Post date:** [October 22, 2021, 7:53am UTC](https://community.glideapps.com/t/format-date-plugin/33411/40 "2021-10-22T07:53:24Z")
Re columns: I suggest adding Rating to String. [https://replit.com/@MaximKM/glide-rating-to-string](https://replit.com/@MaximKM/glide-rating-to-string) [https://glide-rating-to-string.maximkm.repl.co](https://glide-rating-to-string.maximkm.repl.co) It converts rating from rating component to chosen emoji. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/93197a582f52e9a8b5412c7e87b30017f3dc8f47.png) [Previous page](https://community.glideapps.com/t/format-date-plugin/33411.md?page=1) [Next page](https://community.glideapps.com/t/format-date-plugin/33411.md?page=3)