Forum Discussion

bhelou's avatar
bhelou
Responsive Resident
6 years ago
Solved

Card text filter

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

 

  • 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>)

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    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's avatar
      bhelou
      Responsive Resident

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