How to check if a text column includes a value from a Single Value column?

[ttss3131]

Hello Glide Experts,

I need your help with a filter logic. This seems like it should be simple, but I am completely stuck.

My Goal: I want to create an “AND search”. For example, if a user selects “Pork” and “Onion”, I want to show recipes that include both “Pork” AND “Onion”.

My Setup:

1. I have a Recipes table. In this table, I have a text column named 食材キーワード which contains comma-separated ingredients (example: Pork,Onion,Pepper).
2. I also have a Single Value column named ユーザー選択1. This column correctly shows the first ingredient the user selected (example: Pork).

The Problem: I am trying to create an If-Then-Else column named Check1. The logic I want is: IF 'ユーザー選択1' is empty THEN true, ELSE IF '食材キーワード' includes 'ユーザー選択1' THEN true, ELSE false.

However, as you can see in my screenshot, in the ELSE IF part, when I try to check if 食材キーワード includes the value from ユーザー選択1, the column ユーザー選択1 does not appear in the list of values I can select.

My Question: What is the correct way to check if a text column (食材キーワード) includes the value from a Single Value column (ユーザー選択1) inside an If-Then-Else column?

Is there a special syntax I am missing? Thank you so much for your help.

[Jeff_Hager]

Retranslating so it’s easier to read:

Hello Glide Experts,

I need your help with some filter logic. This seems like it should be simple, but I’m completely stuck.

My Goal:
I want to create an “AND” search. For example, if a user selects “Pork” and “Onion”, I want to display recipes that include both “Pork” AND “Onion”.

My Setup:
I have a Recipes table. In this table, there’s a text column called Ingredient Keywords that contains a comma-separated list of ingredients (example: Pork,Onion,Pepper).
I also have a Single Value column called User Selection 1, which correctly shows the first ingredient the user selected (example: Pork).

The Problem:
I’m trying to create an If-Then-Else column called Check1 with the following logic:

If User Selection 1 is empty → return true

Else if Ingredient Keywords includes User Selection 1 → return true

Else → return false

However, when I try to create the “Else If” condition, I can’t select User Selection 1 as a value when checking if it’s included in Ingredient Keywords. It doesn’t appear in the list of selectable values.

My Question:
What is the correct way to check whether a text column (Ingredient Keywords) contains the value from a Single Value column (User Selection 1) inside an If-Then-Else column?

Is there a special syntax or workaround I should be using?

Thank you so much for your help!

[Jeff_Hager]

What is the type of column that the Single Value column is pointing to?

What does the Single Value column look like when it contains multiple values to be searched?

I’m guessing the User Selection is an array which can contain multiple values, so it is not letting you do a single value compare. I have an idea, but I want to first understand where that value comes from that ends up in the Single Value column.

[ThinhDinh]

Also interested to hear more on the flow here. Why do you need to use a single value to check the “first” item from a selection? Do you plan to check the same conditions for the 2nd, 3rd choice and so on?