Cannot replicate steps to import Relationship field

[otacon239]

I've been trying for a week or more to replicate the steps found in issue #10899 to "import" a Relationship field. The interface has noticeably updated so some of the steps outlined aren't matching up to what I'm trying to do.

I have two tables: Locations and Plants

The Locations table has several columns, but the two I'm concerned with are a text field Landmark Subtype and the currently empty Many-To-One Plant Relationship field.

I also have a Plants table that has two columns: Name and Image URL

Here's the layout of my automation along with the variables used:

Query Locations

• Table: Locations

Loop

• Binding/Value: {{ steps.Query Locations.rows }}
• Max iterations: 10 (for testing)

Query Plants

• Table: Plants

Update Row

• Row ID: {{ loop.currentItem._id }}
• Edit Fields: Plant
  • Javascript:

let allLocations = $("steps.Query Locations.rows");

for (location of allLocations) {
  if (location?.plant_id === $("loop.currentItem")._id) {
    return allLocations.map(row => row._id)
  }
}

return []

This returns an error, but runs through all iterations. I couldn't find any specific error message, but looking at the Data Out, it looks like it's not injecting the Plant field at all in the data structure of the returned row. If I have information in the Plant field in the Locations table, it clears it.

[itxashancode]

Use the relationship field’s ID, not the plant’s ID.
In the Update Row step set Edit Fields → Plant to a JavaScript expression that returns an array of the matching location IDs.

// Get all locations
const locations = $("steps.Query Locations.rows");

// Find locations that point to the current plant
const ids = locations
 .filter(l => l.plant_id === $("loop.currentItem")._id)
 .map(l => l._id);

// Return the array (empty if none)
ids

The expression must be a plain array of IDs; Budibase will write that into the Many‑to‑One relationship.
If you pass a string or an object the field clears. Also make sure the relationship field in Locations is named exactly “Plant” and that the column storing the foreign key is plant_id. This matches the code above.