After 15 day of searching community i finish my first application
1- Transfer xml file to excel
2- Upload the data to airtable free account base limit 1200 row only and EPG data reach about 12000 row) so i use google sheet as your database
when but all the rows in one sheet it took a very long time to filter data so i divide the data on 5 sheets
3- I learn how to read data from google sheet from the post below
Hi, Is there any way to read data from Google sheet? I want to take data in column 2 (countries) and 4 (new cases) from this file https://docs.google.com/spreadsheets/d/1mpC--JsHI9sdo9RDbLUGwTT_eoaV0DlgQKFsV3BQBLk/edit?usp=sharing Thank you for...
Reading time: 1 mins 🕑
Likes: 1 ❤
4- Date tools extension help me to make the logic to show the current running program
1.Introduction
DateTools
As the name suggests it is specially made to work with Dates but since it uses SimpleDateFormat so you can also work with Time by using appropriate format.
Latest Version: 6.1
Last Updated: Invalid date (UTC)
2.Blocks
[image]
[image]
[image]
It has 22 function blocks and 1 event block
3.Documentation
It has not so much coplex blocks but some examples can help you to understand its usage.
[image]
Returns day of given date.
Note: You can also use DateTime besid…
5- I use floating view extension so i can use the application during watching TV
1.Introduction
Extension Name: Floating View
Through this extension, it is possible to transfer its visible component to a floating view capable of remaining active while the user is in other activities. An example of an application that uses this feature is the messenger.
Latest Version: 1.2
Released:2020-06-14T11:52:00Z (UTC)
Last Updated:2020-06-28T18:25:00Z (UTC)
2.Blocks
[component_method (32)]
[component_method (43)]
[component_method (37)]
[component_method (41)]
[component_me…
The final result
to get current running programs
to get full day program
finally thanks to all the people in community who help me and answer my questions