REF_ROWS output to variable

AppSheet AppSheet Q&A
,
1

This may not be REF_ROWS at all but here goes.

I have an inline Ref table (Parts) displayed on the Details page of my Job table records. I have an AppScript that I am posting payload to Quickbooks and I would like to pass this Ref table to a variable and iterate thru later in the script.

I am seeing the inline table fine but the Test output on REF_ROWS expression is not showing any list data. Maybe they are not the same?

2

The REF_ROWS function returns a list of values from the referencing table’s key column. Are you seeing something else?

3

I found the issue. I needed to return a list, but not of the key column. I am using SELECT now and getting the expected list of values.

Thanks.