Hi team, iยดm using this template to do a Multi-Search, but the list of reference not working, iยดm receiving the Map view
the template is: https://www.appsheet.com/Template/AppDef?appName=Multi-SearchDemo-675786#Data.Columns
Result:
This is my Formula:
FILTER(โPROJETOSโ, **
** AND(
** OR( ISBLANK([_THISROW].[PROJETO]) , CONTAINS([PROJETO] ,[_THISROW].[PROJETO]) ),**
** OR( ISBLANK([_THISROW].[STATUS]) , CONTAINS([STATUS] ,[_THISROW].[STATUS]) )**
** )**
)
My result in map view
Who can help me?
Solved! Go to Solution.
Oh, I see the problem.
First, revert the EnumList back to List.
Then, create a new view of type table in the ref position for the Projectos table or slice. That view will govern the display of the results.
Try with removing [_THISROW] de-ref from your column names
@Alan_Martins
Also you can try with this
FILTER(
"PROJETOS",
AND(
OR(
ISBLANK([PROJETO]),
CONTAINS([_THISROW].[PROJETO],[PROJETO])
),
OR(
ISBLANK([STATUS]),
CONTAINS([_THISROW].[STATUS],[STATUS])
)
)
)
UPDATE!
The results changed but no in list yet
My reference is this results view in list
How can i change the results view to list?
What do you mean by this? Please elaborate.
Hi Steve,
I need to see the โresultsโ in list, just it.
Still not entirely clear what you mean by โresultsโ. The table appears to be โresultsโ to me. But if you just want a flat list of the individual codes, try changing the column type from List to EnumList.
Hi Steve, i changed to Enumlist type but not work.
PS:
to be clearer or what I need is for the view to be presented as a table as in the example and not as a list
Like the left (green) exemplo:
Staus / Date / Name
Oh, I see the problem.
First, revert the EnumList back to List.
Then, create a new view of type table in the ref position for the Projectos table or slice. That view will govern the display of the results.
Hi Steve!! Working perfect!!
Solution: I created a new view in the table formate
Thanks!
Hi team,
Iยดm Trying to create a second view but i didnยดt receive the same list results
Could you help me?
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |