Combine two tables of date to display in one calendar

AppSheet AppSheet Q&A
1

I have a table of Job bookings and a table of staff holidays. My client would like to see them combined into one calendar view. Is this possible?

1 Like
2

My initial thought would be to combine the two by formula in a new worksheet and surface it in the app as a read-only table.

There is no simple way to combine tables in AppSheet.

1 Like
3

I thought about something similar using Google Sheets. It will display fine, but clicking through to anything would be a nightmare.

Annoyingly its one of those jobs where its about 5 times more complex than we ever thought and really needs a week of refactoring to make it more efficent.

3 Likes
4

Hi 1minManager,

Have you found a way to deal with it ?