Search Rows module in make.com

User Talk
1

Hi guys,
I want to use the “Search Rows” Module in make.com and I try to figure out how I use the “Search term” field. I can’t find any documentation about the possible search terms for different column types.
Best
Sven

1 Like
2

Sorry, but I don’t understand the question.The search should be self-explanatory:

  1. select the table and the column you want to search in
  2. provide a serch term
  3. select if the search should be case insensitive or not and if you want to activate wildcard search

image
image741×840 66.6 KB

Let’s say you have a column “Names” and you want to search for “John”, then you will only receive back rows from your table, that contains “John”.

  • Insensitive means “john” will also find “JOHN”.
  • wildcard search means “Jo” will find “John” and Jonnathan".

Where is your question?

1 Like
3

Hey Christoph,

thank you for your reply. For me it works only in those cases you wrote in your answer.

I try to make it work for:

  • text fields: search for “nathan” finds “Jonathan” (wildcard search is switched on)
  • Date fields: “< {{now}}” or similar searches
  • Checkbox fields: “true” or “1” should find a checked value
  • Number fields: “> 4” or other searches with operators

How can I solve such searches?

Best
Sven

1 Like
4

Now I see your point. But the “search node” in make.com is not that intelligent.

But you can implement the logic inside SeaTable. Just add an additional “formula” column, add any logic you want in there and then just output a string, that you search for that column for that string.

1 Like
5

All right, I got it. Unfortunately this seems to be a showstopper. If there is a specific selection, I can solve that with such a column but with dynamic requirements like search for rows that have a date between start and end date that would not work.

I just saw in your API documentation that there is a SQL query. Is this Would that endpoint solve my requirement? I yes, that would be the solution.

7

I can’t believe, that there is any logic, that could not be solved with a formula column in SeaTable. Please give an example, that you think could not be solved with that.

9

I agree, I could create a formula for each query, but that is not a good aproach for me, I want to use the search term field that I don’t have to do that in the seatable.

Therefore I would like to ask my question from above again:

I just saw in your API documentation that there is a SQL query. Would that endpoint solve my requirement? I yes, that would be the solution for me.

10

Just try it by yourself: Query SeaTable with SQL

11

When selecting modules, the “SeaTable” module is not the right one. It shoulld be “SeaTable rework”. Have you got access to this one? The “Search” module in the “old” SeaTable does not work. It’s a long story.

12

No , I only see “SeaTable” and no rework version?

13

SeaTable need to invite you to it. ask @cdb

14

A short search for “make.com” in this forum would have delivered the result:
🎉 Rework of make.com SeaTable App

Please see this “rework SeaTable App” as a proof of concept or playing ground.
In the next weeks, I will improvements to the default SeaTable Make.com app supporting the SeaTable API Gateway.

15

Wow! Two weeks to come to this result for such a simple question.
“Try it by yourself”, “Search for it”, … thank you. :frowning:
I’ll stay with airtable…