Issue with passing items to make.com

User Talk Automations
1

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?

2

Hi @webdienste.

Do you pass the list from the Default View or from a custom view?

3

Hi AkDk7: I use a custom view
Just did a check in the default view and it is still showing the same problem

4

I am using n8n to automate and if I need to sort the output I am using a custom view which is sorted before. Did you try that?

5

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.

6

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.

1 Like
7

Uh, that’s dirty :slight_smile: Good luck with that!

8

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.