Virtual Column Order Issue

[Rod]

I have virtual “is part of” - REF_ROWS(“Job Slice”, “Customer”) pointing to a slice with the column order that I want, however it’s still showing my virtual column at the bottom of the form.
What am I doing wrong?

[Steve]

Make sure the view displaying the form is using your slice. The emulator in the app editor identifies which view and data set are being displayed:

[Rod]

It’s a nested form and it shows the original form not the actual table, is that the issue because it’s nested?

[Steve · Accepted solution]

Make sure the Referenced table name matches the slice name used in the REF_ROWS() expression.

[Rod]

Worked, thanks!

[Rod]

Next question: I forgot how to show a list from a ref that is NOT the label in the table.
For example, I need to show the computed_name, however because the label is the ID it’s showing the ID’s. I apologize, I’ve done this before but I can’t find it…call me old…

[Lynn]

Hi @Rod
Did you try SELECT() ?

[Rod]

I figured it out, changed my ref and derefs to match the ID

[Rod]

I thought about that but will it populate the computed name when selected from a nested level? The ID shows up…