Skip to main content

resume table of 3 tables linked by 3 columns

  • December 30, 2023
  • 2 replies
  • 33 views
C
Forum|alt.badge.img+2

Hi every one, 

I'm just trying to create a table that shows 3 tables together. Each table is been filled by data fetcher, each table is a channel sources. Meta, Google, etc, with the results grouped by year, month and week (Is like the data comes from data fetcher)

I need to do one table with all the channel together. The thing is, in each table of source I have 3 columns that identify and probably link each raw of each table. Column user, year, month and week.

Each table has the same first tree columns, so the resume table should have user, year, month and week, and then, the linked results from the table meta, google, etc.

In excel is relatively easy, but here I don't find an easy solution. 

Thanks for any help.

2 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Alexey_Gusev
  • Brainy
  • 1261 replies
  • December 30, 2023

Hi,
what's the use case? You want to join 3 static similar tables in a large vertical one? Just copy-paste.
Or if you want to maintain dynamic solution, perform multi-source syncing to another base. You can adjust field mapping and the source will be additional column.
You may also find this link useful

C
Forum|alt.badge.img+2
  • charleskot
  • Author
  • New Participant
  • 1 reply
  • January 4, 2024

Hi,
what's the use case? You want to join 3 static similar tables in a large vertical one? Just copy-paste.
Or if you want to maintain dynamic solution, perform multi-source syncing to another base. You can adjust field mapping and the source will be additional column.
You may also find this link useful


Thanks for responding Alexey.

I read the article but I don't think it would work for me.

I am using Airtable and Softr. Softr works on airtable as a database.

In the software I build an app that allows clients of a digital marketing agency to see the results of their marketing campaigns.

I have 2 tables in airtable, one that is updated every day with results from new Google contacts, one that is updated with meta results.

In softr, I wanted to make a summary table, where clients can see and filter the results of all their campaigns.

To do this, I need a table in airtable that joins these tables.

This summary table would be in each row, user_id, year, month, day, Google result and Facebook result.

Automatically, each day a number of records from several clients are created in the meta and google tables, and they should automatically be unified in the summary table by client_id, year, month and day.


Terms & ConditionsAccessibility statement