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
