How to combine two tables into single one

Ask for Help
3

Hm, that is now even more interesting :slight_smile:

2 tables approach:

Yes, the date is not the same. Income could contain any day as I have YYYY-MM output and it’s really a table to count hours worked and sums of money.

And the payout differs and could be any date and sometimes even 1 in 2 months but YYYY-MM-DD.

So this will not work.

I have thought about scenerio like:

  1. query data (YYYY-MM-DD) columns from table1 and table2 in python, merge and output to colA (column formula), I’m fine to read Python docs and I think it’s just some list object or set of objects or whatever it called in python.
  2. query for items in table1 to colB, query from table2 to colC. Both lookupRecords() based on date. Hide both.
  3. output colD as sum of B and C. And since there is no overlap between them, I get a value for each cell.

1 table approach:

It’s good but if could make it this way:

  1. Create a table for everything with column type.
  2. Create custom table/widget to fetch only typeA and same for typeB values.
  3. Hide unnecessary columns for this tables to keep it visually simple.
  4. Be able to add date to this table that will be automaticaly marked as typeA/typeB (like filtered values must be added to corresponding table).

ps: I got something similar in my crm system where I could create my custom lists and everything I add also contains exact list parametres.

I have created an example: Single table and 2 filtere views of it(but i have to keep type column visible)

bJLIAdCBl2
bJLIAdCBl22394×1618 268 KB

  • just understood that I’m really missing an ability to sort based on hidden field. It’s type for this example but I had same difficulty before when I imported db table and hide id col as I don’t need it to work with data but still need everything to be ordered by initial id.

ps: I hope it’s okay that I am boring you with all these things. It looks to me like you guys made a deal to get no only more customers but some fuel for further project tuning. At least I hope it’s useful for you too, because it’s more interesting to me to use Grist and sometimes change tools then really needed. Just try to make something more productive and automate as much as possible. But everything I try now worked for me before in gsheets. (except api experiments)