Card text filter

[bhelou]

Dear Community ,

i have a search items and i need to show the contet of the search in a card  but it is giving me the last satus of the enrty , can i make it blank when i open it or clear it ,

1ist image showing in search is blank but showing in cards the last entry 

2nd image is when i search , it works perfectly

Thanks for help

[Greg_Deckler · Accepted solution]

You are probably using MAX or Last which is why you are getting the last one. What you could do is something like:

Comments = 

  IF(COUNTROWS(ALL('Table')) = COUNTROWS('Table'),BLANK(),<whatever your calculation is>)

[bhelou]

Thank you very much it worked perfectly . what a solution 🙂