Hello,
I have a list with exports date and hours and minutes. I need a formula that will allow me to show on the UX, the latest date with hours and minutes. Is there such a formula?
Thanks
@ilincach: if I understand correctly, you have a list with multiple elements and in a module you have per every element saved like below?
the idea is to have the format date like "YYYY-MM-DD HH24:MM" in order that you apply an order, all the rows will be correctly ordered (even if the format is TEXT).
The Line-item has the summary setup "Firstnonblank":
and in a system module take the total value that can published in the card.
As you notice the value in SYS00 is not correct: the correct value should be "2024-05-01 14:20", so what it is needed is to order the list descending on the line-item "Date Time Export" in order that the first element to be the latest Export DateTime.
So, after you populate the list and the "DateTime Export" you need to launch the Order List Action in order to put as first element the latest DateTime Export (max).
After launching the Order Action the totals will show correct result:
If you do not want to use the Order List, you could transform the TEXT Date in number like "YYYYMMDDHHMI" and put summary as MAX and transform the MAx number back in text in order to publish it.
Hope it helps,
Alex
@ilincach, you can keep dates, hours, and minutes in text format and use the "&" operator to concatenate multiple text line items so that you can show them in whatever format you want them to be!
Thanks @Dikshant but how can i show the latest ? (for example in UX, in a card, to show the date and time of the latest extract)?
@ilincach - You can load it via integration. Which integration tool are you using?
Hi @Dikshant , the dates loads into a module and then, I need to show in the UX the latest date. So i would have thought i would need a formula to have this information shown properly
thanks a lot @alexpavel it work very good!!!! Much appreciated!
@alexpavel , this action need to be run averytime by someone or in the UX, the card will show the latest export by default with what stated abouve by you?
@ilincach The order action should be in the same process that populates the list and after the DateTime line-item is updated. This will avoid the need to be manually triggered.
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
