# šŸ†• Enhanced single value column **URL:** \ **Category:** Ask for Help\ **Created:** [August 28, 2020, 9:46am UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880 "2020-08-28T09:46:42Z")\ **Posts on this page:** 20\ **Page:** 1
**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 28, 2020, 9:46am UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/1 "2020-08-28T09:46:42Z")
Single value column now supports getting last value, random value or a determined position from start or end of the source column. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3abbcccb55114394f4bb816b92eb390adfbc16d9.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/26aefc94b63a7c84d28e766c4d9dd0299adf10d6.png) ---
**Author:** ![ilimp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ilimp/32/12111_2.png) [@ilimp](https://community.glideapps.com/u/ilimp)\ **Post date:** [August 28, 2020, 10:14am UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/2 "2020-08-28T10:14:42Z")
šŸ‘šŸ» ---
**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 28, 2020, 10:16am UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/3 "2020-08-28T10:16:54Z")
I just saw this last night too! Will need to play around with this for sureā€¦specifically how Random works/shuffles. ---
**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 28, 2020, 11:51am UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/4 "2020-08-28T11:51:34Z")
Iā€™m really glad @Mark and the team are adding enhancements to the Single Value column. Hopefully they build in `=NOW()` functionality! ---
**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:** [August 28, 2020, 11:58am UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/5 "2020-08-28T11:58:49Z")
Even a TODAY() value that isnā€™t dependant on sheet updates to processā€¦ though I guess that would make upgrading to Pro less attractive for some. I currently use an IFTHEN to check if a date is today, but a single value would be nice and clean. ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 28, 2020, 12:14pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/6 "2020-08-28T12:14:11Z")
Creating a number column with 100 rows of decimal numbers from 0.01 to 1, along with multiple single value columns pointing to it each of them set to random, then another math column to multiply the results of all of themā€¦ that would provide a pretty precise random numberā€¦ depending on the number of single value columnsā€¦ and of course, as long as these columns recalculate every time an edit is made to the sheet. @ThinhDinh does Random change with every edit? Or does it just set it something random that stays that way forever? ---
**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 28, 2020, 12:18pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/7 "2020-08-28T12:18:05Z")
# šŸŽ² Random Dice Roller Playing around with Single Value \> Random that relates to a list of numbers and then looks up a cloudinary image with that number: ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 28, 2020, 12:21pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/8 "2020-08-28T12:21:59Z")
Regardless, this is exciting. And definitely feels like weā€™re getting closer to Glide Sheets eventually having what we need to step away from Googleā€¦ perhaps at first through some interesting, bulky workarounds. Has anyone suggested or requested column grouping? To keep a bunch of columns that were only created for one function organized together. I often find myself building out some piece of logic that requires 5 to 10 columns (roll ups, relations, look ups, math, etc) to function. And I always worry Iā€™ll forget what they are or why I created them. Grouping could help there. Iā€™d probably build more logic in the data editor than conditions on duplicate components if I had a bit better organization in that data editor (grouping, search). Drag and drop sorting and renaming was already huge though. Anyway. These are the kind of changes that geek me out. ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 28, 2020, 12:29pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/9 "2020-08-28T12:29:38Z")
Amazing!!! Absolutely amazing! And so so so exciting for my use case! I have a seasonal earning algorithm in my app where users earn a random amount of currency per content submission but that random amount is modified by a separate multiplier associated with the time of yearā€¦ so certain times of year are more fruitful than others. And it updates down to the split second (upon an edit of course). So I can build half of that algo in Glide nowā€¦ which is blowing my mind a bit, and making me more and more confident that my app could stay with Glide for the long term. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [August 28, 2020, 12:56pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/10 "2020-08-28T12:56:04Z")
There are more and more elements in Glide where I think ā€˜why in the world would I need thisā€™ ? Glide is becoming less and less Blom-proof šŸ˜‰ ---
**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 28, 2020, 1:40pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/11 "2020-08-28T13:40:11Z")
Agreed. I requested this in the Feature Requests appā€¦column grouping and then ability to drag/drop those groups at once. ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 28, 2020, 5:54pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/12 "2020-08-28T17:54:59Z")
šŸŽµ You say tomayto, I say tomahto, you say external URL linking, I say special recalculating values. Letā€™s call the whole thing off šŸŽµšŸ˜‰ ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 28, 2020, 6:03pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/13 "2020-08-28T18:03:15Z")
@david you were asking the other day about use cases for a Row Numbers column. To use this Random feature as Robert is showing in his video, youā€™d need to create a corresponding column of non-repeating numbers. Would be nice not to have to do that manually. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [August 28, 2020, 6:08pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/14 "2020-08-28T18:08:04Z")
Itā€™s important that someone keeps pointing out that Glide can be for the masses, next to the spreadsheet geeks! šŸ™‚ ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 28, 2020, 6:19pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/15 "2020-08-28T18:19:16Z")
Not going down that rabbit hole with you again, Blom. šŸ˜‰ ---
**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 28, 2020, 7:13pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/16 "2020-08-28T19:13:03Z")
šŸ˜ Just found out you can do a Random Single Value from a RELATION COLUMN: ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 28, 2020, 8:54pm UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/17 "2020-08-28T20:54:44Z")
@Robert_Petitto we may be getting close to needing to schedule a Glide game night (or day for those who might join from other countries). ---
**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, 12:53am UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/18 "2020-08-31T00:53:18Z")
@Mark Does the Single Value \> Random value per row _ **ONLY** _ change on a shuffle action (unlike a `=RANDBETWEEN()` formula that changes on sheet edit)? ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [August 31, 2020, 2:41am UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/19 "2020-08-31T02:41:51Z")
While the app is running that should be the only time it changes, yes. ---
**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, 3:20am UTC](https://community.glideapps.com/t/enhanced-single-value-column/14880/20 "2020-08-31T03:20:18Z")
Does it also change upon screen navigation away and back to the screen? If so, that would be ideal. I assume this is also user specific? [Next page](https://community.glideapps.com/t/enhanced-single-value-column/14880.md?page=2)