I love that we can filter by dynamic values (Field = [This Entity].Field), however, unless I’m missing something, this doesn’t work with basic text/number fields. If I have a field for say Level (if entity has no Parent = Level 0, otherwise Level 1), I have to create a Relation field for this to automatically filter to entities with the same Level value. This means keeping Databases aren’t aren’t really necessary.
1 Like
I’m not sure why you write this:
It should work no problem.
Perhaps you want to share screenshots/videos of something that’s not working.
This is what I mean. In this case, the number field is a formula field (Level #), but number and text fields also don’t work for dynamic filtering. I would like to dynamically filter that field to other entities that share this entity’s Level (for example), but I have to create another Database to do that.
Dates would be good as well. We can do X days ago, etc. but not x days after This Entity > Date.
I hope that makes more sense.
Aha!
I misunderstood. I thought you were talking about filters in formulas, e.g.
Tasks.Filter(Level = [This Project].Level)
But you’re right that dynamic relation-view filters don’t support number or text fields, sorry.