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!