Would it be possible to use Baserow to find partial (but closes) matches for terms in 2 differents tables (specific cells) and show the associated lines data?
Ex.
In table 1, in the choosen column for this query, there is a cell with ‘behind the word mountains’
In table 2, in the choosen column there is a cell with ‘behind words mountains’
I would like to output both cells thats match, along all data on the same line for both tables.
This could be achieved by using Link row and lookup fields.
To also search data from another table you would need to add that data to your current table by first making a link row field connected to that table and then you could add a lookup field for every relevant field you want to have “duplicated” in your current table from the other table.
Just being able to run search and it will automatically search multiple tables and merge the results, is not something you can just do by enabling a setting for example.
The search does a contains comparison on the whole string that you insert into the search.
What that means is, it will take the search text that you put in, and see if any of the fields contain that search text exactly how you have written it. It won’t re-arrange the letters or words and look for matches based on that.
It’s probably not possible. I can’t think of a way you can achieve this with formula fields, and our search is non-configurable. @nigel can you confirm?
Really what we need here is the ability to search and get results backed ordered by some “search distance” metric. Right now our search functionality is very exact and basic.