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

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