we partly have a subscription model in our company and our deals are closed for a certain period of time.
For example a deal is closed for 3 months and a new invoice is issued every month.
How can this be easily displayed with airtable in terms of forecasting on monthly revenue bases?(Especially the automatic transfer to the next month)
Not only transfer to the next month, but embracing all earlier data/forecasts to derive a newly updated forecast based on the most recent information, right? This is the machine learning component of the forecasting methodology and you can see how I did that in the example.