How to Implement Order-Independent Multi-Keyword Search in Adalo?

Get Help Database
1

Hi everyone,

I’m building an image search feature in Adalo and would appreciate some advice on the best database/search structure.

From a UX perspective, users naturally enter multiple keywords separated by spaces, for example:

cute cat

or

cat cute

My goal is that both searches return the same results, regardless of keyword order.

For example, an image record in the database might have keywords stored as:

cute cat

When a user searches for:

cat cute

I still want that image to be returned.

In other words, I want the search to match records that contain all keywords, regardless of their order.

What is the recommended way to structure the database and search logic in Adalo to achieve this?

Should keywords be stored as a text string, separate records, a relationship table, or something else?

I’d love to hear how others have implemented order-independent keyword search in Adalo.

Thank you!

2

Hey @Yuki.O,

In order to implement this feature, you’d need to add keywords as a text property in each record of the results. This way you can filter the list to know if the records contain the (Input Value).

In case you’d like “Cute cat” & “Cat cute” to give the same results when typed, I’d suggest using AI to fill the (Keywords) text properly, so you can tell the AI prompt (Add all possible search results of the following keywords), then you can save them in the same fields.

Note: This second method is only if your list filter is set to (is equal to), but if it was (contains), you don’t need it.

Thank you!
Ali