# Get range on google sheet

**URL:** <https://community.thunkable.com/t/get-range-on-google-sheet/2491919>\
**Category:** Questions about Thunkable X\
**Created:** [July 3, 2023, 10:44am UTC](https://community.thunkable.com/t/get-range-on-google-sheet/2491919 "2023-07-03T10:44:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pdh1982](https://avatars.discourse-cdn.com/v4/letter/p/edb3f5/32.png) [@pdh1982](https://community.thunkable.com/u/pdh1982)\
**Post date:** [July 3, 2023, 10:44am UTC](https://community.thunkable.com/t/get-range-on-google-sheet/2491919/1 "2023-07-03T10:44:58Z")

</div>

how i can set data viewer list1 on sheet1 range A1:D5  
and data viewer list2 on sheet 1 range A6:D7  
thank you very much

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [July 3, 2023, 1:52pm UTC](https://community.thunkable.com/t/get-range-on-google-sheet/2491919/2 "2023-07-03T13:52:41Z")

</div>

You can’t map a DVL that way. So instead, set up your Google Sheet so that one sheet is copying the first range of cells from a main sheet and a different sheet is copying the second range of cells from the main sheet. Then, map the DVLs to each of the sheets with the copied ranges.

---

<div class="post-metadata">

**Author:** ![pdh1982](https://avatars.discourse-cdn.com/v4/letter/p/edb3f5/32.png) [@pdh1982](https://community.thunkable.com/u/pdh1982)\
**Post date:** [July 4, 2023, 12:43pm UTC](https://community.thunkable.com/t/get-range-on-google-sheet/2491919/3 "2023-07-04T12:43:24Z")

</div>

can i ask one more question, how can i set color for DVL when screen1 start, i can do it when DVL click, but i want to do it when screen1 start  
 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/c/7cbc2b8dd3217f77fb2befb3dbb1c6af03cc42b8.png)

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [July 4, 2023, 1:41pm UTC](https://community.thunkable.com/t/get-range-on-google-sheet/2491919/4 "2023-07-04T13:41:09Z")

</div>

There is a way but there is currently a bug preventing it from working: [Can't change container background color manually in DVL](https://community.thunkable.com/t/cant-change-container-background-color-manually-in-dvl/2459628)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [October 2, 2023, 1:41pm UTC](https://community.thunkable.com/t/get-range-on-google-sheet/2491919/5 "2023-10-02T13:41:28Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.