How to sort Monday.com by date column with Integromat (make) and send HTML table with GMAIL
I am able to get board’s items(monday.com) with integromat.
Then iam also able to create an HTML table and send them with gmail.
Iam looking for a solutino how to sort the data based on dates.
- make cenario picture
- Unsorted table (the email)
There is a sort() array function you could use first to sort the array that holds your data before it goes into a table.
All right, this should absolutely be part of the core documentation related to “raw” and “dot notation”. The sort() function takes 3 arguments, the first being mandatory
You must pass an array to sort so usually you will pass the output of an array or an array aggegator to perform the sort.
Ascending is the default sort order so if you leave off key 2 you will get ascending.
It is the third argument that is crucial. You cannot just cram a color pill from the result of a previous output into this key. You have to either identify the simple key name or array path (in dot notation).
This video shows you how to derive this from looking at the output bundle in JSON, which is the easiest way to identify this raw path.
The sort() function mentioned by @alex.newpath is the way to go. See below how I set this up to sort by descending order for the created_at field
Thanks for @alex.newpath i was able to solve it…BUT
make sure you don’t have any leading spaces
Nice. Yeah leading spaces in the text could mess up the sort but you can trim those first before assembling the array. Do you want to share your final solution here?
well done Alex - that is very interesting.