# Single value: last value help

**URL:** <https://community.glideapps.com/t/single-value-last-value-help/19354>\
**Category:** Ask for Help\
**Created:** [December 3, 2020, 11:18pm UTC](https://community.glideapps.com/t/single-value-last-value-help/19354 "2020-12-03T23:18:52Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\
**Post date:** [December 3, 2020, 11:18pm UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/1 "2020-12-03T23:18:52Z")

</div>

Hey Guys!

Quick question: If I have a sheet called _posts_ connected via a relation to a sheet called _comments_ then how would I pull in the last comment’s user-who-posted’s profile picture to a separate column? I tried doing it with a single value, but that pulls in the last comment’s profile picture from ALL posts, not the last comment’s profile picture from EACH post.

How can I do this?

Thaaaaaanks  
Pablo

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 3, 2020, 11:36pm UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/2 "2020-12-03T23:36:07Z")

</div>

You should be able to use the relation as the driver for the single value column to get the last item.

---

<div class="post-metadata">

**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\
**Post date:** [December 3, 2020, 11:40pm UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/3 "2020-12-03T23:40:25Z")

</div>

The relation from posts to replies or from replies to posts?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 4, 2020, 1:01am UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/4 "2020-12-04T01:01:47Z")

</div>

I would assume the same relation you have from posts to replies?

---

<div class="post-metadata">

**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\
**Post date:** [December 6, 2020, 7:23pm UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/5 "2020-12-06T19:23:05Z")

</div>

Thanks for the amazing help jeff!!!

I did Last Replies\>Image

---

<div class="post-metadata">

**Author:** ![Riza\_Lesmana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/riza_lesmana/32/21067_2.png) [@Riza\_Lesmana](https://community.glideapps.com/u/Riza_Lesmana)\
**Post date:** [February 16, 2021, 6:09pm UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/6 "2021-02-16T18:09:08Z")

</div>

Does anyone experience if we select single value, the table is the link field with the open link button, but the screen doesn’t appear when we share

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 16, 2021, 11:27pm UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/7 "2021-02-16T23:27:02Z")

</div>

Can you give us some screenshots? I’m not sure I understand the question that you have regarding the “link field” and the part “the screen doesn’t appear when we share”. Thank you.

---

<div class="post-metadata">

**Author:** ![Riza\_Lesmana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/riza_lesmana/32/21067_2.png) [@Riza\_Lesmana](https://community.glideapps.com/u/Riza_Lesmana)\
**Post date:** [February 17, 2021, 1:18am UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/8 "2021-02-17T01:18:14Z")

</div>

![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/9/99f56a9d38e5a6fcea13b9a5730b911ab8e66506.png) ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/13a345bfa17050489ffd293bc68001fea71e8866.png) ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f1d69b14c68728ad1dcb44ac9607236f3cc8f109.png) ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fb0fe2c5a2aad56c35a896c2c74cf0d8d0293675.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 17, 2021, 2:25am UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/9 "2021-02-17T02:25:55Z")

</div>

What’s the “right” action in your configuration?

---

<div class="post-metadata">

**Author:** ![Riza\_Lesmana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/riza_lesmana/32/21067_2.png) [@Riza\_Lesmana](https://community.glideapps.com/u/Riza_Lesmana)\
**Post date:** [February 17, 2021, 2:35am UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/10 "2021-02-17T02:35:27Z")

</div>

i don’t know help me In visibility, I never input the condition, I try to combine the google sheet and glide table with a relation and a single value and the contents are in the form of a link, but I put it on the button for link relationships, it doesn’t appear when we share

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 17, 2021, 3:27am UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/11 "2021-02-17T03:27:39Z")

</div>

I was just asking about the “right” (as in left and right) because in the screenshots you only show configurations for the left side.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 12, 2024, 1:50am UTC](https://community.glideapps.com/t/single-value-last-value-help/19354/12 "2024-01-12T01:50:03Z")

</div>


