Hello, How can I make a search engine that only shows what I want to search for?
Solved! Go to 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:
Hello @samolorz
Already there:
If that does not fit your need, please be more specific 🙂
For reference:
Configure column properties - AppSheet Help
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
@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:
or there:
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.
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
OK I see 🙂
You need to use:
LINKTOFILTEREDVIEW("MFD_Detail", [NUMERO DE PEDIDO]=[_THISROW].[NUMERO DE PEDIDO])
For reference:
LINKTOFILTEREDVIEW() - AppSheet Help
Still not working
😞
What am I doing wrong?
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.
I don't see the data in the MFD table 🤔
Just the data from my other table
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:
Thank you for the pacience
It is done
Have you tried the built-in filter feature? It may simply be suit what you need in no time.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |