Yeah, i think a pipeline could do this with more efficiency as well. For grins, is there a way to have a connected table, and have a schduled "snapshot" of each field for the 1st of the month? but then I don't know how to schedule a "snapshot".
Qrew LegendWell, nothing wrong with thinking outside the box, but a Connected Table can only be a mirror of another table, so it will not continue to add records. But also, you cannot set a Connected Table to refresh only monthly, I'm pretty sure the minimum is daily.
I'm still working on this...
Perhaps is it possible for a pipeline that uses a prebuilt report (template I guess), and on the first of every month, the pipeline saves that report in a specific table. How hard is that to make?
not hard at all if you have access to pipelines
