Mar 31, 2022 12:45 AM
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
Mar 31, 2022 03:42 AM
Hi Paul, this is very much possible. Are you entering the amount of clicks manually? In what interval? Best, Rupert
Mar 31, 2022 04:05 AM
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!
Mar 31, 2022 06:31 AM
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?
Mar 31, 2022 06:34 AM
Thanks for your input.
I’m going to try to make your idea to work.
I’ll keep you posted !
Thank you very much.
Apr 04, 2022 03:10 AM
Your solution works perfect!
I’ve also created a function that i can see how many clicks there were requested in each month.
And the main goal, to get the amount of remaining clicks has been reached!
Thank you Rupert.