I’m wondering if the following idea could be created in Airtable.
Suppose I have a business that sells online adverts. When a client buys an advert, we’ll put it online and the advert will be shown on specific newspaper websites.
When the client agrees with the offer, we provide the client with 2 things:
Now, what do I want to create in Airtable:
I have a sales team that can spent a budget 500.000 clicks a year.
So, I’d like to create a table in Airtable, where my sales team can add new clients and each client is then granted an amount (1.000, 2.000, 5.000, …) of clicks, a start and an end date.
I would then be great that Airtable calculates the average amount of clicks between the start and end date and also subtracts the amount of clicks of the yearly budget.
Can this be done in Airtable?
Any help is much appreciated. Thanks very much
The yearly budget of clicks is a fixed amount.
All the other data i’d like to enter by a form;
All the data above is for one specific advert. If the customer wants to extend is end date, then an new input (order) is created.
I hope this is the information you wanted.
Big thanks for helping me out!
So this is how I would do it:
In order to calculate an average over many projects, you need a single record that all projects are linked to. So…
Table 1: Sales team (here you literally only have one record called “Sales Team”. You could have multiple teams of course.
Table 2: Projects (this is where the form enters your data) and every project / record is linked to the sales team.
In table 1, you can now create a Rollup field and calculate the average of all values. In another Rollup field, you build the sum of all clicks. In a formula field, you subtract that sum from your 500.000 total clicks.
Does that make sense?