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...
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
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...
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...
