I see, @Otto-d172, thanks for those additional details!
This is how I would build an on-call summary in Tables for a recurring schedule based on days of the week:
First, you'll want to have a table that stores the weekdays. The WEEKDAY() function returns a number to represent a day of the week. The purpose of the table is to help display the day in a form we recognize better (i.e. "Tuesday" or "Wednesday"):
I then created a table of Shifts that could be associated to any day. I'll note that I created a couple of additional columns that calculate if the current time is before or after a shift start or end. That will be relevant to the summary table that we'll get to:
Note: The calculations of the TRUE or FALSE checks I added are based on a calculated time to my time zone (PST). Honeycode time is in UTC, so refer to this article on converting time: UTC & Time Zone Conversion.
The formula for the current hour (converted to PST):
Check to see if start is after current hour:
Check to see if end is before current hour:
I then created a Schedule table where I assign a "Group" to a shift. Each column is a rowlink to another table (you'll want to have a Groups table where you perhaps assign team members):
Finally, the Summary table shows the current time and which group is assigned to the current shift:
For the formulas for each column:
The "Current Weekday" column checks the current weekday and displays that name of the day based on the Weekday table:
The "Current shift" column checks the current time and looks for the shift where the time is after the start time but before the end time of a shift (refer to the Shift table I set up):
=FINDROW(Shifts,"Shifts[After Start]=TRUE AND Shifts[Before End]=TRUE")
And the assigned group checks for the group in the row of the Rotation Schedule where the current day and shift match:
=FINDROW(OnCallRotation,"OnCallRotation[Weekday]=OnCallSummary[Current Weekday] AND OnCallRotation[Shift]=[Current shift]")[Group]
Now, in an app, you can set up a screen that displays the data of your Summary table:
For your last question, if you wanted to have users input information for each recurring shift, you can add additional columns to the rotation schedule table (i.e. a "Notes" column), and set up your app to allow for edits of these details. (i.e. on a Details screen. If your schedule is set up in your tables, you can easily set up an app with a list and details screen for the shifts using the App Wizard). You're also able to modify the UI of the app to create a look more of a calendar (rather than a listed schedule), but that's more of a visual preference.
If you'd like to further explore integrating Honeycode with other services that may meet any other calendar / scheduling requirements, check out Honeycode's two-way integration with Zapier and AppFlow to connect your data and app with another service.
Hope all this helps! Let me know if you have any other questions.