# 🔧 Single Value Column Updates **URL:** \ **Category:** General\ **Created:** [October 5, 2020, 9:25am UTC](https://community.glideapps.com/t/single-value-column-updates/16763 "2020-10-05T09:25:04Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [October 5, 2020, 9:25am UTC](https://community.glideapps.com/t/single-value-column-updates/16763/1 "2020-10-05T09:25:04Z")
There have been a few updates to the [Single Value Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/single-value-column) over the last few months. You can now retrieve the – first, last, random, X from start, X from end – value from any table in your app or multiple relation in the current table. You also have the option of ‘Whole row’ which acts a little like a relation. [Read more in our docs.](https://docs.glideapps.com/all/reference/data-editor/computed-columns/single-value-column) ![Screen Shot 2020-10-05 at 10.11 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0ed3e53f4b5905066890651231d27d4b2c59c9b6.jpeg) ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [October 5, 2020, 9:27am UTC](https://community.glideapps.com/t/single-value-column-updates/16763/2 "2020-10-05T09:27:38Z")
Excellent!!! I will test it out in one of my apps. ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [October 5, 2020, 10:58am UTC](https://community.glideapps.com/t/single-value-column-updates/16763/3 "2020-10-05T10:58:48Z")
> [@JackVaughan](#): > > value from any table in your app or multiple relation in the current table. Interesting! 👓 ---
**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:** [October 5, 2020, 12:29pm UTC](https://community.glideapps.com/t/single-value-column-updates/16763/4 "2020-10-05T12:29:23Z")
Sometimes I forget all of the potential in the Single Value column. ---
**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:** [October 5, 2020, 1:57pm UTC](https://community.glideapps.com/t/single-value-column-updates/16763/5 "2020-10-05T13:57:48Z")
Looking over the doc, my mind is still blown by the use of a column to determine the single value dynamically. What would be a couple of practical applications of this? Maybe one column of images that are associated to a number 0-4. When a certain status = that number, then grab that image? How is this different than a relation/lookup though? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 5, 2020, 2:16pm UTC](https://community.glideapps.com/t/single-value-column-updates/16763/6 "2020-10-05T14:16:52Z")
> [@JackVaughan](#): > > You also have the option of ‘Whole row’ which acts a little like a relation. Does anyone has a use case of this? I really wanna understand it better ---
**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:** [October 5, 2020, 2:23pm UTC](https://community.glideapps.com/t/single-value-column-updates/16763/7 "2020-10-05T14:23:19Z")
It’s very meta. A relation when there is no relation. Eg. A sheet with random quotes. Columns include the quote, the author and an image. You could do a single-value -\> Random -\> whole row to grab the row of a random quote within any other Glide table. Then use lookups to grab the elements of that row for display purposes. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 5, 2020, 2:28pm UTC](https://community.glideapps.com/t/single-value-column-updates/16763/8 "2020-10-05T14:28:40Z")
Awesome, gotta try it ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [October 5, 2020, 3:39pm UTC](https://community.glideapps.com/t/single-value-column-updates/16763/9 "2020-10-05T15:39:28Z")
I used it the other day to bring over a random value. But I’m stuck there, I can’t think of any other use case. ---
**Author:** ![Mauronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mauronic/32/21726_2.png) [@Mauronic](https://community.glideapps.com/u/Mauronic)\ **Post date:** [October 5, 2020, 8:55pm UTC](https://community.glideapps.com/t/single-value-column-updates/16763/10 "2020-10-05T20:55:26Z")
Assuming I understand the behavior (I am not an expert like you guys), the first thing that came to mind was to use this to auto-populate a random default profile image for new users. ---
**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:** [October 5, 2020, 9:12pm UTC](https://community.glideapps.com/t/single-value-column-updates/16763/11 "2020-10-05T21:12:41Z")
Certainly possible! But that avatar will change every time they visit their profile page. ---
**Author:** ![Mauronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mauronic/32/21726_2.png) [@Mauronic](https://community.glideapps.com/u/Mauronic)\ **Post date:** [October 6, 2020, 12:45am UTC](https://community.glideapps.com/t/single-value-column-updates/16763/12 "2020-10-06T00:45:15Z")
I was thinking about stuffing the random stock image URL as a default value when they create their profile for the first time. ---
**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:** [October 6, 2020, 1:02am UTC](https://community.glideapps.com/t/single-value-column-updates/16763/13 "2020-10-06T01:02:02Z")
If we need to use this for a system where we always need users to interact with a first or last row from a range then it would work. Probably a “Latest show” or “Check in”, I can only think of that. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [October 6, 2020, 1:42am UTC](https://community.glideapps.com/t/single-value-column-updates/16763/14 "2020-10-06T01:42:12Z")
Ohhh I love this. This is a great use case. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [October 6, 2020, 9:53am UTC](https://community.glideapps.com/t/single-value-column-updates/16763/15 "2020-10-06T09:53:08Z")
Yes, I’m currently using this to display a user’s latest form submission. Very simple to set up!