Adding a column from another table to a view

[ravisom]

Hi, Newbie question 😞

I added a virtual column on a table and referenced it to a column in another table using ref rows. However when I add this virtual column to the view, the field doesn’t show up on my form. Any help please?

Firstly, is virtual column the right way to use values from another table as a drop down list?

[Marc_Dillon]

REF_ROWS is typically only auto-generated when you set a column as Ref to another Table. It's very rare to manually write a REF_ROWS expression.

https://help.appsheet.com/en/articles/961426-references-between-tables

https://help.appsheet.com/en/articles/2357313-ref_rows

If a field is not editable, and it doesn't have a value, then Appsheet will automatically hide that field in a Form View. That is perhaps what is happening here.

What exactly do you mean "use values from another table as a drop down list"? Drop down lists are typically presented to get user input from a set list. Virtual Columns are only for expressions, they don't allow user input. So no, you're probably not doing it the right way, but I also don't really know what you're trying to do. Maybe this article will help?

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

[ravisom]

Thank you for your response. I am trying to learn from the template for Incident reporting. Reports table  has Sites as a reference table. In new reports view there is only one field from Sites table - site name (this column is designated as label on Sites table). I want to add another field also to the form - site address. And trying to figure out the best way.

[Marc_Dillon]

What do you want to do with this added site address field? Are you wanting to select a site, then have the site address auto-filled?

https://help.appsheet.com/en/articles/1090811-dereference-expressions