Combine two tables of date to display in one calendar

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?

0 2 808
  • UX
2 REPLIES 2

Steve
Platinum 4
Platinum 4

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.

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.

Top Labels in this Space