Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it.

Expressions of the form


return a List type data value that contains the values in Column for ALL records in the entire Table.

Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just:


One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like:

  Table[Column] ,
  Table[Column] = "X"

The second argument in SELECT(), the “condition”, is evaluated iteratively across every record in the Table, from the context of each individual record. Which is why you can just use [Column]. So you change to:

  Table[Column] ,
  [Column] = "X"

For reference:

Good suggestion from @MultiTech_Visions:
An additional helpful tip, you can freely replace “Table” with the name of any Slice and expressions work the same way, but only reference records from the Slice instead of the entire Table.


Nice one!

Maybe include something about how slices and tables are essentially the same in this situation.


I have one question. That I can’t display ref data on PDF workflow Is it related to SELECT()?

Screen Shot 2021-08-03 at 14.25.31


I’m afraid to disturb others. If possible, can you please reply to this link?

Hopefully, you can help me out.


Thank you for your help.

This description clarifies things a lot.

PS: Sorry for the delay in responding to your answer. I was stuck in a remote construction site for a few weeks.

1 Like