Skip to main content

Dear Community,

I’m working on a vacation & sick leave overview. I created a form each, each of them populating a table, one for the overview of vacation requests and one for sick leave. 
In the employee interface, we have one calendar page. This shows atm the vacation requests for the current user. 

Now my question is if I can add the data from the “Sick leave” table to this one calendar page, meaning that in the calendar the employee can see the vacation as well as the sick leave info.

If you need pictures for a better understanding, I’m happy to provide them. 

Thank you so much already!

Best, 
Philip

Ah at this point Calendar Interface layouts can only display data from a single table I believe

To achieve what you’re looking for I think you’d need to either:

  1. Create a new table that contains both the vacation and sick leave data
  2. Create the sick leave data in the vacations table

For both, you’d populate them via automations and create lookups and formula fields to consolidate the data for the Interface to display

Hopefully someone else has a better idea!

---

Is there any chance you could use the same table for both the Vacation and Sick data instead?  If you had a ‘Type’ single select field to designate what type of data each record was (vacation or sick) then the Calendar would work right out of the box and it’d be a lot cleaner

Hey ​@Philip_Klimaten,

As mentioned above, that is not possible. Furthermore, except for very specific use cases where you might want to split your data in different tables, if they represent the same object/entity (i.e. at the end of the day, Vacation and Sick data seem to be both “events” sharing many attributes/fields) you’ll really want to have them under one unique table.

If you’d like to go through this together on a quick call I’d be happy to show you around database best practices :D

Mike, Consultant @ Automatic Nation 
YouTube Channel

Terms & Conditions