1 Table to rule them all

1

First of all sorry for the name i just couldn’t resist it!

Hello Everyone!

I have several tables (each in its own subpage) that i use to follow my working days and hours. In those tables some rows are marked either as a festive day that i worked or working day that i took off. It always marked the same “Festivo” and “Recuperando” . Example :

Ejemplo fixta
Ejemplo fixta931×422 71.8 KB

I want to make a main table that will have those specific rows. For now i guess just as a copy paste would be enough but my main objective perhaps will be with fewer columns and more simple as marking just Festive or Worked days on those specific rows. To achieve it i thought best will be a button that will do all those actions:

  1. Filter (both to not duplicate the rows that are already in the table nor rows that do not Contain “Festivo” or “Recuperando xx/xx”)
  2. Lookup
  3. Copy and paste

Festivos y recuperacion
Festivos y recuperacion1330×420 61.4 KB

P.s As can be seen, its goes by month and as so i am still missing December. Is there a way to that could be made that the formula will automatically apply it to a page that will be created in the future?

Thanks in advance !!!

2

Welcome back, Asaf.

As your heading says, one table to rule them all…

I would strongly recommend that you have only one table, and then filter that table to the months/ days that you want to see.

It will be much, much simpler.

3

Hey ho!

Yeah no doubt but the thing is that each table is in a subpage that have more information and stuff for that specific month.

Sure that if i manage to find that magical formula i guess ill have to keep update it as months goes by(and later also years but for that i just copy the page and start again) .

Just like out of curiosity, i am pretty sure its doable but having a button that iterate between 12 tables to collect data. Is it something could be pulled off ? or am i risking either that the doc might crush or maybe expecting a very long waiting time untill it will be done?

4

yes it can be done, if you really want it to.

But believe me, it is sooo much simpler to have a single table, and filter that table as you need it.

1 Like