Link references lists programmatically using n8n

Ask for Help
,
1

Hello,
I have a master inventory table that I’d like to link to each instance a SKU was purchased:

Master Inv Table
SKU 8831

Purchase Table:
ID#1 SKU 8831 QTY 2
ID#2 SKU 8831 QTY 5

Now I’ve been able to do this when using a reference column by just having n8n provide the Row ID. However, on a reference list it’s not working. I’m assuming it needs the list in a particular format?

I tried ID#1,ID#2, etc , but even typing these in directly into Grist doesn’t work. However, if the column type was set to “text” first and then converted to reference list, the same format (ID#1, #2) works!!

Hope that made sense!

TLDR: how do I programmatically link hundreds of rows on a column reference list?

2

The format of values of a reference list of ["L", <id1>, <id2>, ...], e.g. ["L", 5, 17]. Does that work?

3

Through some tinkering, I finally got this to work:

The reference list must be set to display the “ID” field of the reference sheet, not anything else.

In my case, the reference column was displaying “SKU” instead of “ID”. So when I typed in the SKU (8831) OR the ID (#1) it did not work.

However, setting the reference column to display ID worked properly when entering an ID into the field.