# How to get last value
**URL:** https://community.glideapps.com/t/how-to-get-last-value/42060
**Category:** Ask for Help
**Created:** [May 17, 2022, 1:48pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060 "2022-05-17T13:48:50Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Surat\_Rattanaphaiboo](https://community.glideapps.com/u/Surat_Rattanaphaiboo)
#### Post date: [May 17, 2022, 1:48pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/1 "2022-05-17T13:48:50Z")
how can I get last value from a choice I chose last time I already sent using form?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 17, 2022, 1:51pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/2 "2022-05-17T13:51:30Z")
You can use a Single Value column to get the last value either from an entire table, or the last value through a relation.
---
### Author:  [@Surat\_Rattanaphaiboo](https://community.glideapps.com/u/Surat_Rattanaphaiboo)
#### Post date: [May 17, 2022, 1:54pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/3 "2022-05-17T13:54:55Z")
Can you please give me an example or pictures ?. It would help a lot.
Thank you
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 17, 2022, 2:10pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/4 "2022-05-17T14:10:59Z")
There really not much to it. Go to the data editor in glide, add a new column, select Single Value as the column type, set which which column in which table you want to get the value from, and set it to get the last value in that column. That’s it.
> **[Single Value Column](https://docs.glideapps.com/all/topics/computed-columns/primary/single-value-column)**
>
> Copy a single value to every row
---
### Author:  [@Surat\_Rattanaphaiboo](https://community.glideapps.com/u/Surat_Rattanaphaiboo)
#### Post date: [May 17, 2022, 2:17pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/5 "2022-05-17T14:17:31Z")
I dont really mean that type of the value
lets say I choose the name “Amazon” in the form and send it. Then, how can the choice automatically choose “Amazon” for me the next time I click in the form for the default value. I did it in the other app it says get last value
---
### Author:  [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)
#### Post date: [May 17, 2022, 2:21pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/6 "2022-05-17T14:21:28Z")
The other way, if you’re not wanting the value of the column of the last row that was written, is to do a ‘set column’ in a custom action to a field in your user table set aside to store that value. Call it "Last Retailer’. Then, when you bring up the custom form to submit a new record, you can set the default value of a field to the value contained in the ‘last retailer’ field of the logged on user.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 17, 2022, 2:23pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/7 "2022-05-17T14:23:12Z")
Still could use the single value column. You could place that single value column in a user profile table or the parent table that contains your form button. Then you can set the default value of the choice component in the form to use that single value.
---
### Author:  [@Surat\_Rattanaphaiboo](https://community.glideapps.com/u/Surat_Rattanaphaiboo)
#### Post date: [May 17, 2022, 3:01pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/8 "2022-05-17T15:01:51Z")
I still dont get it can you explain how can I do it please. Or if you can give me a video it would help a lot
Thanks
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [May 17, 2022, 3:43pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/9 "2022-05-17T15:43:06Z")
Maybe this video may help you!
> **[Last Value.mp4](https://drive.google.com/file/d/1DY-9Hs0baxdeVa-YB9TrhvrIUxxznzG8/view?usp=sharing)**
>
> Google Drive file.
---
### Author:  [@Surat\_Rattanaphaiboo](https://community.glideapps.com/u/Surat_Rattanaphaiboo)
#### Post date: [May 17, 2022, 4:12pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/10 "2022-05-17T16:12:56Z")
Got it man
Thank a lot I really appreciated
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [May 18, 2022, 4:13pm UTC](https://community.glideapps.com/t/how-to-get-last-value/42060/11 "2022-05-18T16:13:34Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.