Use case or problem
I want to be able to use bases to find notes that contain a certain text value in a property, but without having to be that exact value. It just needs to contain that text value.
A use case. I’m a farmer and have organized crops according to the time I sow them, time I plant them etc. One crop can have in its “sowing-time” property the values “1 ultimo january”, “2 february” and “3 medio march” (as a list property)
I want to be able to pull up a base with all the crops I can sow in March. If I put ‘sowing-time contains march’ then nothing comes up. If I put ‘sowing-time contains 3 march’ then all the crops come up with exactly “3 march” as one of the values in that property, but it doesn’t catch any crops with the value “3 medio march” or “3 ultimo march” etc.
Proposed solution
When using ‘contains’ bases takes that literally.
If I have notes that have a property with values like “Favourite book” and “Worst book ever” and “Unread book” and “Great movie” and I make a filter that contains “book” then I should get notes with the first three values, but not the fourth.
Current workaround (optional)
Base cannot currently do this (other users provided a workaround in this help thread). Dataview can do it, so I assume it should be simple to integrate into bases.