using a table as Calendar in order to display availability of worker in on-call team?

[Ruxandra]

Hello!

In order to manage the periods when the on-call team are available, there is any possibility to do that in appsheet, but not using View Calendar, but table view? 

For example, I have the members of the on-call team, phone numbers, department, etc, then they should fill in start date and end date of the period when they are available to be called even if they are at home (there are some urgent works to do). I need those days between start date and end date to be displayed in a table view as their period of availability for every team, for every department, etc.

If I use a Calendar view, it is shown, but I need to also display the personal data of the members of the team, emergency level, management, etc, and also days of the month, months, years. 

Can you help me with suggestions how I could do this? Is there any possibility to have a friendly view for final users?

Thank you very much for your help!

Regards!

Ruxandra

[Steve]

You can display data from a calendar using a table view. Give that a try.

If you need to include data from other tables in the rows of the calendar, add virtual columns to the calendar table to pull in values from elsewhere.

[Ruxandra]

Hello, Steve!

I am not sure I understand  "You can display data from a calendar using a table view.", I mean I need to see all days of the months, as they are displayed in the view Calendar, and the period between start date and end date coloured, but in a table view; I am afraid, it is not clear for me how to do it. Could you, please, give me an example?

Regardind the virtual columns, I will test using them. Thank you!

Many thanks!

Regards!

Ruxandra

[Ruxandra]

I have one more question regarding data from other tables in the rows of the calendar, as a test I already have some physical column including data about the employee, + start date and end date, but if I make a view Calendar, there is no option to see these columns about employee. I read the documentation and there is nothing about it.

This calendar will not be integrated with google calendar. I need to be  self-standing, with no relation-ship to Google calendar.

Thank you for your help!

Regards!

Ruxandra

[Steve]

---

@Ruxandra wrote:

This calendar will not be integrated with google calendar. I need to be  self-standing, with no relation-ship to Google calendar.

---

Ooooh! I misunderstood! Yikes! Sorry!

Could you put together a simple drawing of what you would want the desired view to look like?

[Ruxandra]

Something like this: 

planning on-call teams for a month; the name of the persons is necessary to see who is available outside of work hours, if something happens, and call him.

[Steve]

There is no simple way to do that. I can imagine a complex way to do it, but I would recommend against it.

[Ruxandra]

Hello!

Ok! Thank you! I think, the only way is to change the solution and the solution; using directly the Google calendar integration it seems to me a more stable and optimal solution, even if the result can't be displayed as the users would like to see.

Regards!

Ruxandra