sure, just to mention : concatenate genuine feature does not exist (yet ?) in Adalo.
So, all happens on your form for CREATING a new restaurant.
Note : in this very example, the Restaurant NAME and the MENU CONTENT are all on the same record Line,
Restaurant A Name / Menu Text 1 / Menu Text 2.
Restaurant B Name / Menu Text 1 / Menu Text 2…
So at the time you create the new restaurant - you should enter all its menu on the same line
In this way, on clicking SUBMIT, you copy the content of Restaurant Name AND Menu text 1 AND 2…etc ALL to one single column. say its named “Concat-content”
Later you just use the column “concat-content” to run your searches…
I havent tried to set it in another way that is ; 1rst column for NAME , 2nd for Menus since you would have to repeat the same Name for each line of menu (if using only a SINGLE column for all its menus)…and that would create many copies of the Same Restaurant in the results…so not much of a choice here.
*I havent tried to see how one can COPY two properties from 2 collections into 1. maybe its possible, I do not know…definetely, more complicated I believe
Let know if you need more help