EPG viewer application

[waellotfy77 (wael)]

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

Read data from Google Sheet

4- Date tools extension help me to make the logic to show the current running program

DateTools : Some tools to work with date and time

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

Floating View: float your component. [FREE]

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