Suggested values

AppSheet AppSheet Q&A
,
1

I have a From Warehouse and a To Warehouse on a form.

The two fields of type Enum with a Ref base type Warehouse.

I wish to filter the To Warehouse Suggested values so that if SGN is selected in From, only SGN is available in To field.

Select(Warehouses[Row ID], [Row ID] <> [_THISROW].[From], true)

The above is not working. Any suggestions, please?

2

Is [ROW ID] the key of the Warehouses table? If not, try

SELECT(
 Warehouses[key col],
 [Key Col] <> [_THISROW].[FROM],
 TRUE
)

.

3

@TeeSee1

Yes, Row ID is the key.

StephenSaid_0-1697059586203.png
StephenSaid_0-1697059586203.png869Ɨ436 27 KB

4

Hmmm, then the expressions should work..

What are you getting exactly, the whole list, errors?

5

Iā€™m getting the whole list.

StephenSaid_0-1697062508670.png
StephenSaid_0-1697062508670.png373Ɨ661 18.2 KB

I should only be getting Master warehouse if I have SGN selected.

6

I have exactly the same and it works for me..

Animation.gif

TeeSee1_0-1697063052195.png

TeeSee1_1-1697063385998.png
TeeSee1_1-1697063385998.png797Ɨ1074 47.1 KB

See any differences?

1 Like
7

@TeeSee1

Thanks for taking the time to debug this. I really appreciate.

I had Other values allowed on and had some validation going on.

As soon as I removed both of them, it worked as expected.

Thank you so much for your time.