Lookup Multiple Values from One Cell / Many-to-Many Relation

[Raphael_Aebersold]

Hi all,

I’m somehow confused with the “Relation” between two tables.

This is the situation:

• I have multiple “Split” values in relevant cells of the “agency” table. (“SEO”, “SEA”, “Google Ads”)
• I have another table “services” that matches single values like “SEO” to it’s respective HTML value (e.g., <span style="stylisch html code">SEO</span>)

What I wanted to achieve:

• I tried to create a “Match Multiple” Relation from the agency table to the services table in order to get the styled elements via a lookup column to my agency table.
• The result looks like this (image 1). As you can see, the relation is incorrect.

What I’ve tried so far:

• I’ve played around with different columns (lookup, query, relation, split, array) - nothing seems to fix the data retreival from the services table.

I guess I’ve got something wrong with the relation logic, but I can’t figure out what…Do you guys have any idea how i can convert the .csv data to multiple styled elements in an automated way without a for-loop?

Best,
Raphael

[Darren_Murphy]

Start with a multiple relation in the first table that matches the split text column with the service name in the second table, then use a Joined List column to fetch the related HTML snippets (through the relation).

You will probably want to remove the default comma separator from the joined list column.

[Raphael_Aebersold]

Hi Darren,

Thanks for replying.

Did I get that correctly:

1. Relation column in the agency table, match split text to services in the services table. Activate match mutliple
2. Use a lookup column and then create a joined list with all the code values

[Darren_Murphy]

No, you don’t need a lookup column. Just a relation and a joined list.

But, is this a continuation from yesterday? If it is, you could just use the JavaScript that Jeff provided and point it at the original list.

[Raphael_Aebersold]

Hi Darren_Murphy,

You helped me find the solution! But not the way I expected, cause what you just mentioned was exactly the way I’ve tried it.

However, the thing is, that if I refer to split value columns subsequently, the glide app does something weird (or at least I don’t get it).

It only ever uses the split values correctly if I copy a whole column and paste it at the same place again. On the bottom I can always see an “updateing” indicator. (This worked, however!)

So I guess glide just doesn’t refresh data when a new column is added?

It’s exactly the same issue with filters:

Identical filters after added row although "Split Value" Column is used for filtering

Hi ThinhDinh, Sure, I struggled explaining it properly, sorry. Image 1: I have a table with a filter. The filter is called “Ziele”. Image 2: I pull the items for the filter from a split text column. The text to be split is taken by the column right next to it – a column with comma separated values. To put it in context: all this information so far is in the main table i’m using for the app. In order to collect user data, however, I have a different table (“new entries”) so i can check entrie…

Anyhow, thanks for your help and if you know if there is a way to automatically update a table after a column has changed / calculated something then please lemme know.

[Raphael_Aebersold]

Yes, exactly. The pills worked perfect. But what do you mean by “point to the javascript” is there a way to use JS?

[Darren_Murphy]

Here…

[Jeff_Hager]

Might be related.

@Raphael_Aebersold

It only ever uses the split values correctly if I copy a whole column and paste it at the same place again

Identical filters after added row although "Split Value" Column is used for filtering

Ah, I know what’s going on. It’s because you are manually copying and pasting. There is currently an ongoing issue when you copy and paste text. Seems that the underlying Unicode for maybe the space character is different from what it would be when you type a space compared to when you copy/paste. The text looks identical, but it isn’t. Your best option is to manually type the text instead of using copy and paste until Glide fixes that issue. Or you can pull that data using relations and L…

[Darren_Murphy]

@Raphael_Aebersold - something else I just noticed. See below:

You called that column “template”, but it’s a basic text column, which suggests to me that you added the values for all rows by copy/pasting, yes?

That’s way, way more work than you need to be doing. What you should be doing there is using an actual template column. Then you configure it once, and it’s automagically applied to all rows - even new rows that get added.

Template Column