Filter not working for Formula
I've added a field to a table view. It simply counts the number of attachments for each record:
Next, I add a filter to that column:
I still see all records, regardless of their value. I thought, perhaps, somehow the column value type was being changed to a string, so I tested with ="0", but that didn't work either. Any suggestions on how to filter a formula field?
Yeah, I get the same result and it doesn't make sense. The filter works in a View layout element which makes me wonder if it not working in the Table view is a bug. I created another Formula field and assigned numbers to it based on the contents of another field and was able to successfully filter on that Formula field.
Thanks for verifying Sean. I too was able to filter a formula field that grabs its value from another number field. I tried force coercing the results of count via the number function, but that didn't work. I also added the formula as a new field in my table, but that didn't work either. I've sent an email to support@
Kevin, no problem. One option would be to create a Number field and use a Button or the Console to assign the values to the Number field. Here's the code I used...
for i in select YourTable do
i.(Attachments := count(files(this)))
"Attachments" is the Number field. It filtered correctly when I did this.
Good suggestion and it worked well. I've also added a trigger to that field to keep it up to date
The trigger doesn't appear to work. Oh well. I'll just make a global function and run it when needed
- 3 yrs agoLast active