Filtering Suggested Values

AppSheet AppSheet Q&A
1

Hello,

I have a table in my app which tracks equipment inventory. I’d like to categorize the various types of equipment on three levels:

[Equipment Type] → [Category] → [Subcategory]

I set up each column as an Enum type. I’d like users to be able to categorize things as they’d like, but I’d like the app to present [Category] and [Subcategory] options based upon existing combinations.

I set the Suggested_Values formula for the [Category] column like this:

sort(
select(
Equipment Inventory List[Category],
[Equipment Type] = [_THISROW].[Equipment Type],
true
)
)

I expected to be presented with a suggested list of [Category]'s that already existed for the currently entered [Equipment Type], but I’m just getting every unique [Category] with no filtering based on [Equipment Type].

What did I overlook on this?

Thanks!

2

I think I may have discovered my issue: “Auto-complete other values” was turned on, and apparently overruled the Suggested Values formula? After disabling that option, the filter works as expected.