# Related articles

**URL:** https://community.glideapps.com/t/related-articles/16266
**Category:** Ask for Help
**Created:** [September 23, 2020, 11:23pm UTC](https://community.glideapps.com/t/related-articles/16266 "2020-09-23T23:23:15Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 23, 2020, 11:23pm UTC](https://community.glideapps.com/t/related-articles/16266/1 "2020-09-23T23:23:15Z")

</div>

Hello,

Let’s say I have a list of articles, each article has comma delimited list of keywords. I want to show “Related articles” under the article I am viewing, based on at least one identical keyword. What’s the best strategy for that without having to create categories?

@Robert_Petitto ? 😌

Thank you!

---

<div class="post-metadata">

### Author: ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 23, 2020, 11:34pm UTC](https://community.glideapps.com/t/related-articles/16266/2 "2020-09-23T23:34:06Z")

</div>

I “think” what you could do is use the split text field to separate out the values. Then create a relationship to those values. This should bring in other articles with those same values. Then just place a component with the relationship under the article content.

I “think” that will work. Best of luck!

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 23, 2020, 11:35pm UTC](https://community.glideapps.com/t/related-articles/16266/3 "2020-09-23T23:35:44Z")

</div>

Interesting idea @_eric! thank you, I’ll give it a try 🤩

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 23, 2020, 11:42pm UTC](https://community.glideapps.com/t/related-articles/16266/4 "2020-09-23T23:42:48Z")

</div>

Splitting worked well but not sure how to relate to items in the same tab?

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 23, 2020, 11:49pm UTC](https://community.glideapps.com/t/related-articles/16266/5 "2020-09-23T23:49:23Z")

</div>

Is each comma separated list in its own column?

---

<div class="post-metadata">

### Author: ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 23, 2020, 11:53pm UTC](https://community.glideapps.com/t/related-articles/16266/6 "2020-09-23T23:53:53Z")

</div>

You would create a relation column, it should be pulled from your split text column and then again related to the same split text column on the relation.

Then any articles that have any of the same keywords would populate in the relation.

Make sure to select the match multiple option as well.

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 23, 2020, 11:58pm UTC](https://community.glideapps.com/t/related-articles/16266/7 "2020-09-23T23:58:46Z")

</div>

All keywords are comma delimited in the same cell for each article @Robert_Petitto

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 23, 2020, 11:59pm UTC](https://community.glideapps.com/t/related-articles/16266/8 "2020-09-23T23:59:58Z")

</div>

I tried that @_eric but looks like it’s just showing me the writers? and then all articles when I create a relation list?

 ![Screen Shot 2020-09-23 at 1.59.33 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/402899c37e961a55b3ff460c2e34986bfdd57755.png)

---

<div class="post-metadata">

### Author: ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 24, 2020, 12:04am UTC](https://community.glideapps.com/t/related-articles/16266/9 "2020-09-24T00:04:05Z")

</div>

By default it will show you the value that is row 1 within that tab.

Are the writers listed first in the articles tab? Like the very first column?

---

<div class="post-metadata">

### Author: ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 24, 2020, 12:06am UTC](https://community.glideapps.com/t/related-articles/16266/10 "2020-09-24T00:06:31Z")

</div>

I think you have it setup correctly. Try to now add an inline list component from that related column. It should populate the related articles.

Then you would just map the display field to the article names and images on the inline list.

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 24, 2020, 12:08am UTC](https://community.glideapps.com/t/related-articles/16266/11 "2020-09-24T00:08:43Z")

</div>

It shows me all articles, not really filtering them just to related articles 🥴

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 24, 2020, 12:10am UTC](https://community.glideapps.com/t/related-articles/16266/12 "2020-09-24T00:10:04Z")

</div>

Actually it’s showing me all articles that have anything in the rel-keyword column…

---

<div class="post-metadata">

### Author: ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 24, 2020, 12:11am UTC](https://community.glideapps.com/t/related-articles/16266/13 "2020-09-24T00:11:14Z")

</div>

Well that’s not good 😫.

Is your intention to show articles that contain “any” of the keywords or “all” the exact keywords?

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 24, 2020, 12:12am UTC](https://community.glideapps.com/t/related-articles/16266/14 "2020-09-24T00:12:38Z")

</div>

At least one keyword that is the same as in another article 🙂

---

<div class="post-metadata">

### Author: ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 24, 2020, 12:14am UTC](https://community.glideapps.com/t/related-articles/16266/15 "2020-09-24T00:14:04Z")

</div>

Something looks off with your relation column. I just noticed that it looks like it’s populating values within the related keywords column that shouldnt exist.

Make sure that your relation is from the same tab and to the keyword split text column. You are basically relating rows in the same tab.

In your screen shot, you should only have the first 3 rows populated (in the rel-keywords column) if the relation is setup correctly.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 24, 2020, 12:17am UTC](https://community.glideapps.com/t/related-articles/16266/16 "2020-09-24T00:17:43Z")

</div>

So it’s part of the article itself?

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 24, 2020, 12:19am UTC](https://community.glideapps.com/t/related-articles/16266/17 "2020-09-24T00:19:56Z")

</div>

It looks fine to me, everything is showing correctly in the split keyword column, what I was missing was a lookup column. Now it’s showing me the articles.

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 24, 2020, 12:20am UTC](https://community.glideapps.com/t/related-articles/16266/18 "2020-09-24T00:20:57Z")

</div>

No, I generate keywords based on article content with this tool for now:

> **[Extract Keywords | Free Keyword Extraction | NLP Keyword Extraction |...](http://www.cortical.io/freetools/extract-keywords/)**

And manually add them to the keyword column for each article

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [September 24, 2020, 12:23am UTC](https://community.glideapps.com/t/related-articles/16266/19 "2020-09-24T00:23:20Z")

</div>

Seems to be working now on articles that actually have keywords, I simplified it with less keywords just to see that it works.

That said, articles that don’t have any keywords are just showing a lot of articles as related for no reason?

 ![Screen Shot 2020-09-23 at 2.21.50 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/85aeeb626299102992a6b03ae5755bd24b12ff36.png)

---

<div class="post-metadata">

### Author: ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 24, 2020, 12:24am UTC](https://community.glideapps.com/t/related-articles/16266/20 "2020-09-24T00:24:09Z")

</div>

The split keyword values are missing (from row 4 down) but the related keywords are still populating. Technically this shouldn’t happen (if you are using the real keywords as the relation) because there are no keyword values to pull in the relation.

So that leads me to believe that the relation itself might be pulling from another area. It should only pull from keywords split text, same tab.

That’s why something looks off with the relation.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7bfce3a4c73f300376a2124330b952198af7c392.jpeg)

[Next page](https://community.glideapps.com/t/related-articles/16266.md?page=2)
