Creating a relationship that’s not case sensitive

Ask for Help
1

Is it possible to create a relationship isn’t case sensitive? For example, I want ‘Parent’ in one sheet’s column to relate with ‘parent’ in another sheet’s column.
I know it’s possible to create an array with multiple cases or simply keep everything in lower case but I am looking for a better solution.

2

A relation will always look for an exact match, so best bet is have a column in both sheets to change everything to lowercase/uppercase and then make the relation based on those columns. It’s just 2 more arrayformulas though.

3

Can also use IFTHENs in the editor to change values. Not sure if it works out faster, but might be quicker than doing it through the sheet.

4

Thanks @ThinhDinh and @kyleheney.

I am anticipating 50+ words in the array (1 word per cell). Based on that it’s kind of unlrealistic to create 3 array formulas / if then else for each.

Wish glide would simply make it case insensitive.

1 Like
5

@S_C You can take approach of ID. Each word will have an unique ID and same ID you can use in other sheet. Then match by Id so you don’t need to worry about word match.

1 Like
6

Can you elaborate on this?

7

If parent_column is parent, then Parent; else parent_column.

Could also just check if parent_column is not Parent if that’s the only option.

8

my apologies, but I tried that
I’m sure I’m doing something wrong how do i make it case insensitive

1 Like
9

It doesn’t make it non-case-sensitive, it just changes values from one case to another, when necessary. You’d then point your relation to this new column rather than the original.

10

Do we have a solution for this , I’m also interested in creating a search but with other functionalities also in it based on some actions … but if the input is case sensitive … then it will be a hasle

11

Can you elaborate on this?

I believe Kyle and me provided enough info to work on this. Basically you use a computed column to lowercase the text on both sides, then make a relation based on those 2 columns, but I’d be interested to hear more about your use case. This thread is almost 3 years old and we might have better ways to do it now.

1 Like