Referencing the value of another cell in the same row and passing to query

App Building
1

I'm attempting for each row to reference the value from another cell in the same row, and update a query for another cell. I want to do this without having to manually select a cell.

I tried:
{{table1.currentRow.keyname}} But currentrow it says is undefined.

I also tried this, and even though the data returns an array, the i value is still 'null': {{table1.data[i]}

2

So if you are using Custom column currentRow - {{currentRow.keyname}}, however if you are referencing table currentRow is not supported and you can go by {{table1.selectedRow.data.keyname}}. From what you wrote it sounds you need to loop through table data using {{table1.data[i].keyName}}.

3

Hi, thanks for the help! I didnt want to have to select a row to have this data appear. You mentioned looping. Would i do this within the value field via JavaScript?

4

You can build a JavaScript transformer or query and display the result within the field.

5

If you want to iterate:

for (i=0;i<yourTableName.data.length;i++){
 yourQuery.trigger({
  additionalScope: {
valuetoPassIntoQuery:yourTableName.data[i].ColumnNameHere
  }
}
);
}

In your query, use {{valuetoPassIntoQuery}}

6

Hi Scott, but does this mean I would need to trigger the query?

7

I was able to also get some help from support:
{{ Object.entries(Analytics.data.includes[i])[0][1].title }} - this apparently loops for you!

1 Like
8