I’ve seen lots of posts about the count of static data relationships, i.e. the count of related table items. I can’t find one about counting the items in a tab list. I want to show an error if the user filters out all the valid items in the list.
Empty form:
Form that should show an error, like, “Sorry, OREC does not currently have projects within that postal code area.”:
Thanks!
Create an IF-ELSE column to check if the entered value matches your list. Then if yes 1 if no 0… sum results… if sum is 0 then show error message
Hi @jkirkwood001 , welcome to Glide,
You can use eiter a text component or a image component to display the message you want and set the visibility of the component based on the amount of coincidences of the list.
I did something similar, I use a text to display the amount of coincidences.
I am not using the native search tool
I have a IF colum that is true is the text searched is conained in some columns
The inline list is filtering only the TRUE values of the IF column
There is another Rollup column that count the TRUEs of the IF column
The visibility of any component can be managed based on the Rollup columm
I hope this information is clear and useful for your application.
The key here, as @Jesus_Valenzuela_Dia pointed out, is that you can not access the native search bar value to pre-calculate the number of items that would show on the screen.
It has to be a text entry pointing to a user-specific column, and beware of the amount of updates it will cost you.
