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