Hi all!
If you are still interested in the implementation of this task, I propose a proven algorithm. As a basis, I took the table published by Susu Sui in Google and after minor edits, I added one column “DofY” - the day of the year. Using the DATEVALUE function, I calculated for each date in 2022 the day of the year, as an integer, starting from 1. Now, from the current date, you can calculate the day of the year and display the prayer schedule on the display or screen of your mobile phone. In graphical form, the annual schedule looks like this:
Starting from 06/09/2022 to 07/05/2022, the timetable contains the start times of the first and last prayers related to different dates. I didn’t include explanations for users, thinking it would be intuitive. The table is saved in CSV format and uploaded to the site’s collection. All fields are in the “Text” format except for the “DofY” field. I “cut” the published Susu Sui template into 6 parts for use in the repeater. Images recorded in the collection of the site. In the current implementation, only the start time of the prayers is displayed. Susu Sui did not explain the purpose of the other information. When you call the site for control, the date and the current time every second are displayed. information is updated once a day at “0:0”. The change can only be seen at this time or by changing the computer’s system time.
This function is used to determine the day of the year.
//days from NewYear from[1]
function dindex ( today ) {
const year = today . getFullYear ();
const todayms = today . getTime ();
const todayzms = today . getTimezoneOffset () * 60000 ; //Z
let ds = new Date ( year + ‘-01-01’ ); // YYYY-MM-DDTHH:mm:ss.sssZ
const dsms = ds . getTime ();
return Math . floor (( todayms - todayzms - dsms ) / 86400000 ) + 1 //(10006060*24))
}
The example is implemented on the website https://211026a.wixsite.com/mysite-12 including the mobile version.
I would be grateful to anyone who writes comments or suggestions. In particular, is it necessary to implement a schedule view for the following days?
https://211026a.wixsite.com/mysite-12