search

[samolorz]

Hello, How can I make a search engine that only shows what I want to search for?

[Aurelien]

Hello @samolorz 

Already there:

If that does not fit your need, please be more specific 🙂

For reference:

Configure column properties - AppSheet Help

[samolorz]

Gracias por ayudar 

Lo que necesito es una vista de motor de búsqueda. Donde puedo ingresar un dato y me lleva a esa vista pero no se ven otros datos

Excuse my English

[Aurelien]

---

@samolorz wrote:

Lo que necesito es una vista de motor de búsqueda. Donde puedo ingresar un dato y me lleva a esa vista pero no se ven otros datos

---

"What I need is a search engine view. Where I can enter a piece of data and it takes me to that view but no other data is visible."

You may want to try to build a look-alike search engine using a dashboard filter, as described here:

Filtering Dashboard

or there:

Dashboard Filter PF

The idea is pretty simple: on one table you enter the information to look for; on the slice result, you filter data that matches your input.

[samolorz]

I made a form view where I write a piece of information and with an action it should take me to that detail 

But it leads me to another piece of information that is not what I wrote. 

I think there is something wrong with the formula of my action 

 

 The previous search brings me to this result 

 

[Aurelien]

OK I see 🙂

You need to use:

LINKTOFILTEREDVIEW("MFD_Detail", [NUMERO DE PEDIDO]=[_THISROW].[NUMERO DE PEDIDO])

For reference:

LINKTOFILTEREDVIEW() - AppSheet Help

[samolorz]

Still not working 

😞

What am I doing wrong? 

[Aurelien]

LINKTOFILTEREDVIEW("MFD_Detail", [NUMERO DE PEDIDO]=[_THISROW].[NUMERO DE PEDIDO])

The [NUMERO DE PEDIDO] on the left should have the name of the column in the table MFD.

The [NUMERO DE PEDIDO] on the right should have the name of the column in the table you are using this action.

Does that help?

If not, please share a screenshot of your structure table.

[samolorz]

I don't see the data in the MFD table 🤔

Just the data from my other table 

 

[Aurelien · Accepted solution]

That's OK.

Don't trust the autocompletion tool, it's not perfect.

However I think the problem is somewhere else.

You are using a filter expression which will render a list. But you are willing to go on a detail view, hence you should have only one item to consider.

Can you use instead:

LINKTOROW(
  ANY(
    FILTER("MFD",[NUMERO DE PEDIDO]=[_THISROW].[NUMERO DE PEDIDO])),
  "MFD_Detail"
)  

 For reference:

LINKTOROW() - AppSheet Help

[samolorz]

Thank you for the pacience 

It is done 

[Swoopy]

Have you tried the built-in filter feature? It may simply be suit what you need in no time.