Airtable periodic reporting

[JonahM]

Hi all - any suggestions out there for best way to do periodic (e.g. monthly or quarterly reporting) for an investment portfolio where things like cost, value would change from period to period, as would additions/deletions to the company records?
I am referring to the data (not the visualization/reporting) of the data. Would I need to duplicate the base and simply have a series of bases, each for a different period?

thanks!!

[TheTimeSavingCo]

Hi Jonah, I think if I were you I’d have a table in the same base for each period, and then have an automation grab everything I need and add it as a record into said table

So for monthly, I’d have an automation that ran once a month that would summarize all the data I needed, and put it into a single record in the Monthly table, and the record’s primary field would be the month-year

[Kamille_Parks]

Adam_TheTimeSavingCo:

I’d have a table in the same base for each period

I generally advise against this approach.

I would recommend looking at this approach before creating one table per month. It involves formulas and automations. Linked in that thread is a base from the Universe you can look at for an example. If this doesn’t work for you, then consider the separate tables approach.

Creating a “Monthly Billing” table Formulas

I covered how to do time-based reporting on last season’s Built On Air: [[S09-E11] Full Podcast for 11-23-2021] The base being demo’d is this one: Since you appear to only need monthly reporting, you may not need the full solution described in the video but the general process is the same: Use a DATETIME_FORMAT() formula to convert your dates into the name of the month (and presumably the year) to get 12/9/2021 to look like “December 2021”, or whatever your prefered format is Us…

[TheTimeSavingCo]

Ah, apologies for the confusion, I didn’t mean to imply creating one table per month

I would create one table per period, that is to say, for the monthly period we would have a table called “Monthly” and for the quarterly period we would have a table called “Quarterly”, does that make sense?

[JonahM]

@Kamille_Parks and @Adam_TheTimeSavingCo , thanks so much for your assistance here. I will try these and see how we go!!

much appreciated :slightly_smiling_face: