Hello Airtable community. I am trying to automatically create a revenue forecast in airtable but have gotten a little stuck. The use case is as follows… I create a single record for a project containing overall project value, start date, and end date. I then use a formula field to calculate the number of working days between the start and end dates. All good so far.
Now, I want to automatically calculate what the average revenue(value) for that project will be during its lifetime. e.g. if the project is 12 months in duration, with a value of $120,000, I would like to be able to report $10,000 of revenue for each of those specific months.
Using a relational database and some code, I would quite easily do this by creating 12 records (one for each month) with a unique key of date and project, with a value field of $10,000.
My question is, is it possible to programatically do this with Airtable or, ideally, is there a slicker Airtable way of doing this?