Excluding empty value for suggested values in an EnumList Ref

AppSheet AppSheet Q&A
1

Hi All,

I have a column EnumList of type Ref where I use AUTO COMPUTE > Suggested values with the following code:

SPLIT(
	SELECT(
		Objective_Completion_Logs[Working_Teaching_Tips]
	,
		AND(
			ISNOTBLANK(Working_Teaching_Tips)
		,
			[Objective]=[_THISROW].[Objective_1]
			
		)
	,
		TRUE
	)
,
	","
)

In the Select condition, I exclude rows that have their column Working_Teaching_Tips empty. However, when the user clicks on the column to see the list of suggested values, an empty option is displayed. The good thing is that it disappears if I try to select any options (see video).

2X_1_173e69b9fa41d75928165ac3f08aaf6dfe3e7d37.gif

Do you have any recommendation in changing the expression above to avoid seeing this glitch?

1 Like
2

-LIST("") at the end of your expression, also don’t use SPLIT() here.

8 Likes
3

Thank you @Bahbus!

Also, I thought I should be using SPLIT() anytime I retrieve EnumList of Ref. Why is SPLIT not necessary here?

4

SELECT() naturally returns everything as a List. No need to further split it. Split is only sometimes with finicky EnumList columns where the data is already stored. And even then, it’s only sometimes needed.

2 Likes
5

LIST(’’’) to be added at the end of select().please ?

6

Can I exclude specific values as well this way?
And if so…what am I doing wrong in my statement?
The “Exclude this value” keeps popping up in my generated list

UNIQUE(Registration[Destination]) - LIST(“Exclude this value”)