# DVL start from end **URL:** \ **Category:** Feature Requests\ **Created:** [June 14, 2023, 2:30am UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345 "2023-06-14T02:30:54Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [June 14, 2023, 2:30am UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/1 "2023-06-14T02:30:54Z")
Hello everyone Please, make the DVL start from end then users can scroll up just like any chat app “WhatsApp” or “Messenger” because I am tired looking for how to sort Google sheet in real-time. I hope I can see this simple and powerful feature in Thunkable StP and DnD. Please guys. Is it hard to make DVL start from bottom/end? ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [June 14, 2023, 3:51am UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/2 "2023-06-14T03:51:44Z")
Hi, i must’ve missed it, can you give me a rough idea of how you are looking to sort your Google sheets data? An example would help. I agree the bottom-top option would be a great add 👍 ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [June 14, 2023, 9:12am UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/3 "2023-06-14T09:12:21Z")
If I have a list on Google sheet: 1. Hello 2. Hello 3. How are you doing? 4. Doing well. Thanks This data on Spreadsheet must be sort to make the last value is the first one so DVL can view it. The problem is that I tried many ways: Changing the script of googlesheet, adding another sheet that is sorted, sorting from data … etc. All these things fail to sort my data. If DVL has the option of “Start from end” just like WhatsApp chat and users can scroll down instead of scroll up the NO need to work around with Spreadsheet to sort the data. ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [June 14, 2023, 2:15pm UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/4 "2023-06-14T14:15:58Z")
I’d like to propose a solution for sorting - If you have a column which has row IDs (numbers 1 … n), you can use the GVIZ query language’s OrderBy clause to get descending sorted data. > **[Query Language Reference (Version 0.7)  |  Charts  | ...](https://developers.google.com/chart/interactive/docs/querylanguage#language-clauses)** * * * I agree, a start from end option would be of a lot of help 👍 ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [June 14, 2023, 2:52pm UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/5 "2023-06-14T14:52:51Z")
> [@kartik14](#): > > If you have a column which has row IDs (numbers 1 … n), you can use the GVIZ query language’s OrderBy clause to get descending sorted data. I do have row id but does it sort the rows in real-time when we send values to spreadsheet. I have tried many codes in script and formula but it sorts the rows only when I add in spreadsheet but not when I send. ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [June 14, 2023, 3:45pm UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/6 "2023-06-14T15:45:28Z")
Yes, GVIZ works realtime - let’s say you update your spreadsheet with data A and then call a gviz query just after it, chances are it would return you data A too, as gviz generally works very fast. Browse around on google, there are a bunch of articles on GVIZ queries, you’ll get a rough idea 👍 * * * Edit : what do you mean by “not when i send”? ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [June 14, 2023, 10:16pm UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/7 "2023-06-14T22:16:28Z")
> [@kartik14](#): > > what do you mean by “not when i send”? Thanks a lot buddy for your reply. I mean when I manually add value to googlesheet the code in script can sort my data according to ID column but when I add data to spreadsheet via my app (send values to spreadsheet) sorting will not work at all. ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [June 15, 2023, 6:20am UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/8 "2023-06-15T06:20:02Z")
Alright; I think GVIZ is very efficient and fast in accessing your google sheets, so no matter the way you create data in your spreadsheet, it will fetch it. Prepare an appropriate query according to your needs, and add the order by clause to sort accordingly. Let me know if any clarifications needed 👍 ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [June 15, 2023, 11:03am UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/9 "2023-06-15T11:03:31Z")
> [@kartik14](#): > > GVIZ queries Would you tell me please how to use if I have a sheet with 5 columns I want to sort them according to the last colmun. What is GVIZ? Where can I set it in googlesheet? ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:33pm UTC](https://community.thunkable.com/t/dvl-start-from-end/2465345/10 "2024-11-08T13:33:49Z")