ID in Relation column not workng as expected

[Daniele_B]

Hello guys,

I’m adding rows using a Make automation.
I have a column that is a relation, that gets an order ID from another table.
The number is correct, but somehow it doesn’t “link” to the related table:

What am I missing?

Thank you for your input

[Rohan_Mitchell]

Hi @Daniele_B ,

Most likely, you need to link to the row, not the column value. Without seeing your doc I can’t say what you specifically need to do, but I think it will be something like setting your automation to reference OrderIDsTable.Last() … this returns the last row in the table, rather than say OrderIDsTable.OrderId.Last(), which returns the last value in the OrderId column.

Are you able to share you doc, or provide some screenshots of the automation formula?

[Daniele_B]

Hello Rohan,

I think I confused you talking about automation.
The automation is external, on Make, and just adds a row with the column “Order ID” set to a number, that is an ID present in another DB.

In Coda, the column “Order ID” is a Relation to another DB:

“Vendite DB” has the “Order ID” as Display column.

The Relation column works well, I see the list of Order ID from the other table:

To make it more clear:
Test 1: I add a row and type the order ID 51689 → the column is linked to the other DB
Test 2: Make adds a row with order ID 51689 → the column show the number but no link to the other DB (as shown in the original post).

I hope it makes sense

Thanks

[Rohan_Mitchell]

Hi Daniele,

Thanks, I understand re Make being an external automation tool. How is Make getting the Order ID?

In your “Test 1”, you are actually selecting a reference to a row.
In “Test 2”, Make is just adding a text value to the cell

What you need to do is get Make to also select the reference to the Row. I haven’t used Make, so I just signed up and this is the first option that shows up when selecting Coda -

So I think what you need to do is something like get a row from your “Order IDs” table (such as the last row added). This would presumably return a reference to a row, which is what you would then add to your “Orders” table.

Perhaps someone with experience with Make could assist further?