# 🆕 Single value now supports "whole row" as a value

**URL:** https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003
**Category:** Ask for Help
**Created:** [August 31, 2020, 9:37am UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003 "2020-08-31T09:37:44Z")
**Posts on this page:** 10
**Page:** 1

<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: [August 31, 2020, 9:37am UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/1 "2020-08-31T09:37:44Z")

</div>

So you can now create a relation out of thin air?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9346113965b5040cad5ea2c8d19f31e74d231e42.png)

---

<div class="post-metadata">

### Author: ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [August 31, 2020, 11:11am UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/2 "2020-08-31T11:11:56Z")

</div>

What are the types of use cases?

---

<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: [August 31, 2020, 2:08pm UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/3 "2020-08-31T14:08:36Z")

</div>

Hm… 🤔

Maybe @Mark or @JackVaughan an chime in here. First thing that comes to mind is to display a random post/add/challenge/etc. to the user on your homepage:

---

<div class="post-metadata">

### Author: ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)
#### Post date: [August 31, 2020, 5:01pm UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/4 "2020-08-31T17:01:48Z")

</div>

I think this will be very useful in cases where we want to set up a details view for users but also need to display data from another sheet which could be like the “homepage”  
That way, without having to create new columns/components in the user profile sheet, we should be able to display the data from other sheets in the same details screen

---

<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: [August 31, 2020, 6:21pm UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/5 "2020-08-31T18:21:09Z")

</div>

Ah. Agreed. Yes, a homepage that has many columns but only one row would be a good use case. Each user would then be “related” to that whole row.

Keep 'em coming all! More use cases!

---

<div class="post-metadata">

### Author: ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)
#### Post date: [September 5, 2020, 1:44am UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/6 "2020-09-05T01:44:39Z")

</div>

I still don’t understand the best use of this. @Robert_Petitto Did you get any response from Glideapps team?

---

<div class="post-metadata">

### Author: ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [September 5, 2020, 4:16am UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/7 "2020-09-05T04:16:36Z")

</div>

Single value-whole row complements the “independent screen config per item” option that you have on View Detail actions for inline lists. Another layer of flexibility - you can bring with you elements that are independent of sheets/lists and plop them where you want. If you have a catch-all sheet that’s not bound to a tab and you set column A to be an INDEX of sorts, using that column in a single value-whole row context is a calling card. It starts to act more like a relation column and you can look up other columns on that sheet instead of constantly setting up single value columns. Hope this helps.

---

<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: [July 11, 2021, 3:05pm UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/8 "2021-07-11T15:05:39Z")

</div>

Bringing this post back to life. It’s now been a year since we’ve had Single Value \> Whole Row. Who’s using it and for what purpose?

---

<div class="post-metadata">

### Author: ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [July 11, 2021, 3:16pm UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/9 "2021-07-11T15:16:52Z")

</div>

Me, I use and it is very practical.  
Recall a one row element with singlevalue / whole row, then I use it as a relation to do lookups.

---

<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: [July 11, 2021, 3:46pm UTC](https://community.glideapps.com/t/single-value-now-supports-whole-row-as-a-value/15003/10 "2021-07-11T15:46:30Z")

</div>

It would be a killer combination if we had inline lookups.

> [@Select values from relations just like "User \>" (Inline Lookups)](https://community.glideapps.com/t/select-values-from-relations-just-like-user-inline-lookups/26092):
>
> Just like we can choose a value from a user profile sheet during if/then/else columns, template columns, filtering/visibility conditions, etc, would love to be able to do the same via relations. It would cut down on SO MUCH app bloat. @david @mark @tristan Here’s a mockup:

@mark @jason
