crankbit - profile

crankbit · May 04, 2023

Hey everyone,I am fairly new to Airtable so I hope it's not too nooby of a question.I am intending to create a fact table with invoices. Now I would simply like to aggregate the value for each client. The only way I found is the "group" feature, how...

crankbit · May 05, 2023

What I tried now is to create the key not by formula but by automation. This I can then also create in the table to do the aggregation and then include the rollup. I think that should be it 

crankbit · May 05, 2023

Thanks for that insight  I am looking for an automated update indeed!

crankbit · May 05, 2023

Hey Adam, again thanks for your time.That is basically what I tried so far. Question being, when I setup the Lookup Field "Client Email by Step", it is empty at first. So how can I automatically assign a value to it? Did you do this with an automatio...

crankbit · May 04, 2023

Hey Adam, thanks for your response!So this is my fact invoice table setup. As you can see here, I want to group by invoice by customer mail and by step (several invoices lead to the total spent per Step) Here in the second tab, I tried to recreate th...

User Statistics

User Activity

Create Table that is an aggregation of another table (similar to group by)

Re: Create Table that is an aggregation of another table (similar to group by)

Re: Create Table that is an aggregation of another table (similar to group by)

Re: Create Table that is an aggregation of another table (similar to group by)

Re: Create Table that is an aggregation of another table (similar to group by)