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?
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.