Skip to main content

My business charges a monthly subscription fee throughout the life an an agreement. For example, someone signs an agreement to participate from 06/01/2020 to 12/31/2021 and they pay $500 per month.


I am new to AirTable. I have the monthly amount they are paying associated with the client and I have the start date of the agreement and the end date of the agreement. I need to be able to create a table or a view that shows me the total revenue for all clients for a given time period (i.e. revenue every month into the future).


Is this possible?


Darby

Hello and welcome @Darby_Vannier!


I set up an example table based off your description:


It sounds like creating a filtering view will give you the flexibility you are looking for to create custom views for particular time ranges.


Here is an example of a filter I created to only show Clients who would have active contracts in the month of January (the start date was before January, and the end date was after January):


The summary bar will then show you an automatic sum for currency amount on that view


Hope that helps! Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution ✅ .

Reply


Terms & Conditions