# Possible Issue - Is the Single Value First/Last not working properly? **URL:** \ **Category:** Ask for Help\ **Created:** [March 24, 2022, 7:16am UTC](https://community.glideapps.com/t/possible-issue-is-the-single-value-first-last-not-working-properly/40013 "2022-03-24T07:16:29Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Hans](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans/32/41352_2.png) [@Hans](https://community.glideapps.com/u/Hans)\ **Post date:** [March 24, 2022, 7:16am UTC](https://community.glideapps.com/t/possible-issue-is-the-single-value-first-last-not-working-properly/40013/1 "2022-03-24T07:16:29Z")
Hi folks, i have set up a Single Value to read from a user specific column but it does not seem to be working properly. This was not the case a couple days ago. Basically i have a temp user specific column (only 1 row entry for the user) which pulls the value into a single value for comparison against all other records. Have tested from start / from end options to succesfully pull the value from the specified row. but First and Last seems to only pull from row 0 and last row instead of skipping blank rows to pull the first possible value as intended. Thanks! ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 24, 2022, 7:23am UTC](https://community.glideapps.com/t/possible-issue-is-the-single-value-first-last-not-working-properly/40013/2 "2022-03-24T07:23:57Z")
??? USC pulls value into a single value??? that statement makes no sense… can you explain deferent way and maybe attach some screenshots? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 24, 2022, 8:02am UTC](https://community.glideapps.com/t/possible-issue-is-the-single-value-first-last-not-working-properly/40013/3 "2022-03-24T08:02:55Z")
> [@Hans](#): > > but First and Last seems to only pull from row 0 and last row instead of skipping blank rows to pull the first possible value as intended. I’m not aware that Single Value First and Last has ever worked that way (ie. skipped blank rows). First should always take the first value, regardless of whether it is empty or not. And ditto for Last. ---
**Author:** ![Hans](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans/32/41352_2.png) [@Hans](https://community.glideapps.com/u/Hans)\ **Post date:** [March 24, 2022, 9:50am UTC](https://community.glideapps.com/t/possible-issue-is-the-single-value-first-last-not-working-properly/40013/4 "2022-03-24T09:50:59Z")
Thanks Darren, i guess i have gotten confused on this function of first/last value for the single values (that it doesn’t skip blanks). I can’t recall but i may have then been editing in the first row when it worked. Sorry for the confusion everyone! ---
**Author:** ![Hans](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans/32/41352_2.png) [@Hans](https://community.glideapps.com/u/Hans)\ **Post date:** [March 24, 2022, 10:00am UTC](https://community.glideapps.com/t/possible-issue-is-the-single-value-first-last-not-working-properly/40013/5 "2022-03-24T10:00:52Z")
Thanks Uzo, basically was trying to pull a single value of the dates you see in the columns (event picker) to compare with existing dates and check for clashes. Darren clarified that First wont pull the data from the row shown cos it doesnt skip the blanks. it just pulls the actual first row (0) which was blank. Thanks! ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/889e7a0b083ce7db7d280a19c0b3e50eb9bff522.jpeg) ---
**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:** [March 24, 2022, 11:52pm UTC](https://community.glideapps.com/t/possible-issue-is-the-single-value-first-last-not-working-properly/40013/6 "2022-03-24T23:52:13Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd31691135c8ac94c669b5661ebc86a6dc227c67.png) I think you can try this instead. Use a lookup column, pointing to the column you want to take the value from. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39d21f19af0cf77021811aa23172892c37bd15e2.png) Take the first value of that array from single value column. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/922971b704edb4069be0518f63e8f36305f6596d.png) ---
**Author:** ![Hans](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hans/32/41352_2.png) [@Hans](https://community.glideapps.com/u/Hans)\ **Post date:** [March 25, 2022, 1:54am UTC](https://community.glideapps.com/t/possible-issue-is-the-single-value-first-last-not-working-properly/40013/7 "2022-03-25T01:54:17Z")
Nice! Thanks Thinh! Thats neat! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 26, 2022, 1:54am UTC](https://community.glideapps.com/t/possible-issue-is-the-single-value-first-last-not-working-properly/40013/8 "2022-03-26T01:54:24Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.