Re: Using a filter, but Case Sensitive

Digidre

Hi,

In a filter View, I have a couple of filters. On of them is addressing Chord Progressions (music). These are listed in Roman Figures (I, II, III, IV, but also in low case: i, ii, bvii and so on).

The filter I use is this:
IF(ISBLANK(ANY(FILTERSONG[ChordProgressions])), TRUE, ISNOTBLANK(INTERSECT(SPLIT([Chord Prog], ","),
SPLIT(ANY(FILTERSONG[ChordProgressions]), ",")))),

I just found out that the progression vi-IV-I-V results in 2 songs that make use of this progression, at least, they are very close: vi-IV-i-V and vi-IV-I-V. Obviously I need to do something with the formula to avoid this problem.
In Google Sheets I use EXACT, but this is not available in Appsheet. Any advice?
Regards, André

Suvrutt_Gurjar

Could you update what are the types of columns [Progressions] and [ChordProgressions] in the respective tables Filter Setting table and Main table that you are trying to filter?

Digidre

@Suvrutt_Gurjar
Hi!
Sorry it took me while to dive into it again. But, I checked it out for you.

I have a table "Progressions", with a field "Prog Sorted", which is a text field.. This contains an ever growing list.
So, in my table "Filtersong" I have the field "Chordprogressions" which is a Ref field, linked to the table "Progressions".

Regards,
André

Suvrutt_Gurjar

Thank you.

Could you share the screenshots of table columns. This is so because if the field [Chordprogressions] is a reference field, it should return a key value of the parent table Progressions. So , you may want to elaborate how you are comparing it with another text field.

You also mentioned another field [Prog Sorted] which does not seem to be present in the expression you shared.

@Digidre wrote:

IF(ISBLANK(ANY(FILTERSONG[ChordProgressions])), TRUE, ISNOTBLANK(INTERSECT(SPLIT([Chord Prog], ","),
SPLIT(ANY(FILTERSONG[ChordProgressions]), ",")))),

Digidre

Hi, for some odd reason, the probleem appears to be gone. I have nog idea what changed. I will look into it some more. I guess when can close this thread for now.

Regards,
André

Suvrutt_Gurjar

That is great. Thank you for the update.