Ref Columns from Slice With No Data

[Oscar_Daniel_Ma]

Thanks in advance for the help,

I have two tables:

Table A (Sales_Details),
Table B (Products)

And I have a Slice, from Products, and the row filter for the slice is “Product Active = TRUE”

There is a ref column in Sales_Details to Slice_Products, it works perfect, when I try to add a new sale, the dropdownlist shows only “Active Products”; but the problem is, when I search for old sales, there are many sales with products that maybe, in this moment are Inactive, so, in the Sales_Details View shows only the ID, just because the Product “doesn’t belong to Active Products”

Maybe someone of you, could help me, thanks in advance.

[Marc_Dillon · Accepted solution]

You need to have your Ref column point to the base Table, not the Slice.

You can still limit the dropdown list by using a valid_if expression if that is necessary.

help.appsheet.com

Dropdown from Valid_If

How to create a dropdown that depends on a particular list of values.

[Oscar_Daniel_Ma]

Thanks @Marc_Dillon !!!