03-17-2023, 02:15 AM
Finally let me list the basic possibilities of searching/filtering via a field (A) using the example of Mobilesheets.
1. we want to filter / search in field A:
1.1. we want to search within all list entries
1.2. we want to filter/search only certain list entries that we select beforehand
1.3. we want a NOT filter that shows us songs that do not have certain list items
1.4. we want a filter that shows us songs that do not have any list entry in field A at all (a special case of 1.3)
2. we want to exclude field A completely from the search/filter. Results from field A are not found/considered in the search.
Mobilesheets, as far as I can see, can currently do 1.1, 1.2, and in the collections-field also 2.
(Certainly: you can limit the search to only one field and thus exclude the others all. But the exclusion of only one field is currently only possible in the Collection field).
TH
1. we want to filter / search in field A:
1.1. we want to search within all list entries
1.2. we want to filter/search only certain list entries that we select beforehand
1.3. we want a NOT filter that shows us songs that do not have certain list items
1.4. we want a filter that shows us songs that do not have any list entry in field A at all (a special case of 1.3)
2. we want to exclude field A completely from the search/filter. Results from field A are not found/considered in the search.
Mobilesheets, as far as I can see, can currently do 1.1, 1.2, and in the collections-field also 2.
(Certainly: you can limit the search to only one field and thus exclude the others all. But the exclusion of only one field is currently only possible in the Collection field).
TH