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.…

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 …

Hi Darren, Thanks for replying. Did I get that correctly: Relation column in the agency table, match split text to services in the services table. Activate match mutliple Use a lookup column and then create a joined list with all the code values

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.

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…

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

Might be related. [image] Raphael_Aebersold: It only ever uses the split values correctly if I copy a whole column and paste it at the same place again [image] Identical filters after added row although "Split Value" Column is used for filtering Report a Bug Ah, I …

@Raphael_Aebersold - something else I just noticed. See below: [CleanShot 2023-09-23 at 20.56.40@2x] 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 do…

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

Ask for Help

Jeff_Hager September 23, 2023, 12:54pm 8

Might be related.

Topic		Replies	Views
Comma separated values in a single sheets column to drive the match multiple relations in Glide? Feature Requests	13	2328	February 9, 2020
Use Relation to output a single column value Ask for Help	7	1030	January 27, 2023
Convert Look up to text Ask for Help	6	397	February 26, 2024
Convert an array (from match multiple relation) into a single column Ask for Help	6	1363	September 30, 2020
Lookups from multiple realations Ask for Help	9	1137	July 25, 2020

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

Related topics