# Open Weather Map Sunrise/Set Parsing

**URL:** <https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832>\
**Category:** Off Topic\
**Created:** [March 16, 2021, 4:00pm UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832 "2021-03-16T16:00:43Z")\
**Posts on this page:** 7\
**Page:** 2

<div class="post-metadata">

**Author:** ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)\
**Post date:** [March 17, 2021, 6:54am UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/21 "2021-03-17T06:54:37Z")

</div>

Oh, ok! Thanks so much!

---

<div class="post-metadata">

**Author:** ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)\
**Post date:** [March 17, 2021, 6:57am UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/22 "2021-03-17T06:57:31Z")

</div>

Is this correct?

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/3/a3e6acd3f3661a1e1c0542f326222653d4e73f7b.png)

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [March 17, 2021, 7:00am UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/23 "2021-03-17T07:00:31Z")

</div>

One nice thing about Google sheet connection is that rowID is predictable.

The first row has row id of 1, the second row has row id of 2 and so on

So you can safely put 1 in the row id of the update and get blocks

---

<div class="post-metadata">

**Author:** ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)\
**Post date:** [March 17, 2021, 7:01am UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/24 "2021-03-17T07:01:41Z")

</div>

Oh, ok. I thought it would act like Local Table, where each Row ID is a long string of numbers and letters. Thanks!

---

<div class="post-metadata">

**Author:** ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)\
**Post date:** [March 17, 2021, 7:03am UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/25 "2021-03-17T07:03:18Z")

</div>

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/a/4a56aab1b5cfb765e5d6c72cf0a1a655537702db.png)  
Would this do the trick?

**EDIT: @muneer It worked! Thank you so much for all your help!! Thank you once again!**

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [March 17, 2021, 7:09am UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/26 "2021-03-17T07:09:02Z")

</div>

Glad to know the trick worked for you.

---

<div class="post-metadata">

**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:26pm UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/27 "2024-11-08T13:26:01Z")

</div>



[Previous page](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832.md?page=1)