REF_ROWS versus SELECT display

[paullynun]

Hi,
What make REF_ROWS and SELECT display differently? I would like SELECT results to be displayed in a nice list like for REF_ROWS. See the picture below.

[Steve]

The display you see for REF_ROWS() is because it provides a list of rows (i.e., the key column values of rows). I’m guessing your SELECT() returns something other than key column values. To get a display like that for your REF_ROWS() column, your SELECT() must produce a list of key column values.

[paullynun]

Hi @Steve.

This sounds very interesting!
Could elaborate more on “key column values” and if the SELECT must returns exclusively these?

Thanks!

[Marc_Dillon]

paullynun:

if the SELECT must returns exclusively these?

If you want it to act like REF_ROWS() it must.

help.appsheet.com

What is a Key?

Learn the purpose of keys and why they’re necessary.