Am working on an automation of course names and dates.
In my table the view displays the courses according to date. Plus each course has the same name but is distinguished by the suffix MM.YY at the end. This is an example of how it displays in SeaTable:
My Course 02.23
My Course 03.23
My Course 04.23
However, when this data is passed over to make.com, the order is mixed up. E.g.
My Course 03.23
My Course 04.23
My Course 02.23
What is the criteria that ST uses for passing data ? What could explain the discrepancy?
I did do that. Everything was sorted well in advance. I am using make.com.
For clarification: not all of the rows are affected. some course types do pass to make.com in the correct date order.
The view has been sorted according to the column “start date” ( = start date of course). Because the courses have month and year in their names (e.g. 02.23, 03.23, 04.24) and the rest of the course name is the same for each course type, this automatically lists them in the right numerical order in make.com.
I have tried listing them according to name (ascending), which also lists them in the right order in SeaTable but bunches them together rather than separate according to date order. Yet still some course types do not display in the right order.
I have now managed to solve the problem by deleting the affected / problematic rows and re-entering them. Let’s hope the problem doesn’t pop up again.