# Rank Date **URL:** \ **Category:** Ask for Help\ **Tags:** custom-code\ **Created:** [August 12, 2021, 12:24pm UTC](https://community.glideapps.com/t/rank-date/30370 "2021-08-12T12:24:32Z")\ **Posts on this page:** 20\ **Page:** 2
**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:** [August 14, 2021, 1:48am UTC](https://community.glideapps.com/t/rank-date/30370/22 "2021-08-14T01:48:21Z")
Does it go through if you put the EC value in a template column?? ---
**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:** [August 14, 2021, 1:53am UTC](https://community.glideapps.com/t/rank-date/30370/23 "2021-08-14T01:53:21Z")
It does show in the builder, but not passed to the webhook @Manu.n. Any columns that rely on the YC all appear empty @Santiago_Perez1. Theoretically I can try set that YC value to a user-specific column and use that USC column to pass to the webhook, but when I try it it still did not work. ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 14, 2021, 2:09am UTC](https://community.glideapps.com/t/rank-date/30370/24 "2021-08-14T02:09:24Z")
Well, I don’t know if it’s related. But be aware that there is currently a bug for the use of YC columns in an action. At the moment, the only way this works is to display the column on the same page as the action. I already gave Mark a little review > [@Agent for information](https://community.glideapps.com/t/agent-for-information/29981/36): > > Yes Here is a little video. The principle is to modify the order of a list. So with YC I determine what the next number is. The action on the list is to copy the new number to the order column. But it doesn’t work. ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 14, 2021, 2:17am UTC](https://community.glideapps.com/t/rank-date/30370/25 "2021-08-14T02:17:20Z")
I made you a little demo video ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 14, 2021, 2:23am UTC](https://community.glideapps.com/t/rank-date/30370/26 "2021-08-14T02:23:14Z")
I just checked with a WebHook action, and that’s exactly it. if the YC column is not displayed, nothing is sent to the webhook ---
**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:** [August 14, 2021, 3:00am UTC](https://community.glideapps.com/t/rank-date/30370/27 "2021-08-14T03:00:44Z")
Oh wow it has to be visible on screen? ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 14, 2021, 3:01am UTC](https://community.glideapps.com/t/rank-date/30370/28 "2021-08-14T03:01:47Z")
Yes 😃 ---
**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:** [August 14, 2021, 3:15am UTC](https://community.glideapps.com/t/rank-date/30370/29 "2021-08-14T03:15:57Z")
You need to read the fine print 😉 ![Screen Shot 2021-08-14 at 11.15.01 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f9b047602d56b35bcb4743c1ca0ba0ca7296fda.png) ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 14, 2021, 3:18am UTC](https://community.glideapps.com/t/rank-date/30370/30 "2021-08-14T03:18:29Z")
thank you for your clarification. But according to mark, it should work now, well almost 🙂 > [@Agent for information](https://community.glideapps.com/t/agent-for-information/29981/35): > > > [@Agent for information](https://community.glideapps.com/t/agent-for-information/29981/20): > > > > I think @Mark is growling with my post and he will tell us again that we cannot use YCs in an action. > > You should be able to use YC columns _in_ an action. Do you have a simple example app where that fails? ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 14, 2021, 3:44am UTC](https://community.glideapps.com/t/rank-date/30370/31 "2021-08-14T03:44:31Z")
I’m waiting to know if it worked for @ThinhDinh ---
**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:** [August 14, 2021, 10:05am UTC](https://community.glideapps.com/t/rank-date/30370/32 "2021-08-14T10:05:21Z")
It works!!! I put a text component on the screen and hide it using visibility conditions. Webhook can read the data. ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 14, 2021, 10:09am UTC](https://community.glideapps.com/t/rank-date/30370/33 "2021-08-14T10:09:54Z")
Curious, I had tried the hidden text component and it didn’t work at the time. If it works like this, that’s great ---
**Author:** ![Marc-Olivier](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Marc-Olivier](https://community.glideapps.com/u/Marc-Olivier)\ **Post date:** [August 14, 2021, 10:43am UTC](https://community.glideapps.com/t/rank-date/30370/34 "2021-08-14T10:43:32Z")
Merci manu c’est top! One question though, would it be possible to do multiple ranking in a sheet let’s say for rows that share a same index but for exemple with different dates. For exemple you have 10 rows with index 1 (and 10 different dates) , 5 rows with index 2 (and of course 5 different dates) etc … This would enable to have a YC column that would do multiple ranking based on an index and the date for same index rows. Merci et c’est cool de voir tous ce que tu produits pour la communauté. Marc Olivier PS : le but est de réaliser une colonne YC pouvant classer toute une feuille mais auparavant en séparant les index et classant pour chaque index identique les dates de la ligne attenante. ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 14, 2021, 10:52am UTC](https://community.glideapps.com/t/rank-date/30370/35 "2021-08-14T10:52:40Z")
@Marc-Olivier Give me a little time to think. Basically the basic data would be like that? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/add57d74f242cbafc65fa8939cd60e6bf6e4832d.png) ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 14, 2021, 12:28pm UTC](https://community.glideapps.com/t/rank-date/30370/36 "2021-08-14T12:28:25Z")
@Marc-Olivier Here I did that. A rank date according to an index Note that we cannot have an empty index or a date. Tell me if that answers your question? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/b/6b597c20ec19d55340d8b8895e54198c98734d26.png) YC Link [https://Rank-Date-With-Index.manun2.repl.co](https://Rank-Date-With-Index.manun2.repl.co) Source > **[Rank Date With Index](https://replit.com/@ManuN2/Rank-Date-With-Index?v=1)** > > Public ---
**Author:** ![Marc-Olivier](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Marc-Olivier](https://community.glideapps.com/u/Marc-Olivier)\ **Post date:** [August 14, 2021, 6:26pm UTC](https://community.glideapps.com/t/rank-date/30370/37 "2021-08-14T18:26:28Z")
looks great, merci manu YODA je regarde ça lundi 😀 ---
**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:** [August 14, 2021, 11:31pm UTC](https://community.glideapps.com/t/rank-date/30370/38 "2021-08-14T23:31:38Z")
Hola @Manu.n I can see you use the date format _dd/mm/yyyy_ like any person in Latin America. May you test a possible bug I found with this format when anyone tries to write/change the hour in GDE manually? 1)- Create this 2 columns and write these values please ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/05a5714b98bb9753baaf0de6270e1cbb677882d1.png) 1. Later, try to change the time value in any row. I’m going to change the value _12:40:00_ to _1:30:00_ As you can see, the Date is **03/08/2021** (dd/mm/yyyy) and has to be read as **03 de Agosto de 2021** because my Regional Settings were set to work different to US format. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e30064e34dee6efaa591aa3f1eb951475970ac63.png) 1. but, when the new time value is set, the Month and Day were switched and the new Date is totally wrong!!. Glide thinks that March is August now and many problem begin ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/dbaa47eaf2768963d3161909c2c9072a9624585b.png) 1. If you change any value (time) again, Glide switches again Month/Day and everything looks fine 🤨 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d80567de6ffb7429803337444e13f7b25d3cece0.png) To sum up my problem: try to modify a time value manually in GDE when a user has a Date-Time format different to US format can cause problems. The problem begins when Month and Day are \<=12 and are together in the same value. Can you test and replicate this issue please? Thanks a lot! ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 15, 2021, 8:31am UTC](https://community.glideapps.com/t/rank-date/30370/39 "2021-08-15T08:31:06Z")
Hello @gvalero yes i have the same problem. the date column is a little capricious, even annoying. To modify the time of an existing date, I retype the complete date in “us”. I use editing in the Data editor as little as possible. I invite you to make a small topic with this bug 🙂 ---
**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:** [August 15, 2021, 1:18pm UTC](https://community.glideapps.com/t/rank-date/30370/40 "2021-08-15T13:18:20Z")
Sure! I just wanted to confirm this issue with someone using the Date format different to US format. I was creating my own Date Rank YC but testing and writing the data manually it drove me crazy 🥴 Gracias @Manu.n ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 15, 2021, 1:22pm UTC](https://community.glideapps.com/t/rank-date/30370/41 "2021-08-15T13:22:03Z")
Sometimes can you test this RankDate because i did some tips and stuff to be compatible with dates but not sure if it works with your date format. [Previous page](https://community.glideapps.com/t/rank-date/30370.md?page=1) [Next page](https://community.glideapps.com/t/rank-date/30370.md?page=3)