I need to create "something" (report, table, any available ideas?) that will capture the data from 6 fields on the 1st of the month, every month. It needs to stay in QB as something that can be referenced anytime. How can I do that?
I don't have access to create pipelines.
I'm not trying to be sarcastic, but I think that you should ask for either permission to create a Pipelines or access to a person in your organization you can work with who has access to Pipelines.
this does not sound difficult to do with a Pipeline as they can be scheduled to run on a specific day of the month.
The alternative would be to have a Subscription Report, which would go to yourself, and maybe some other users as back up and when you receive the subscription report on the first of the month, you would push a button, and the button would create the permanent record of the value of these fields on the first of the month. Of course, that relies on either yourself or your back up being available to push the button.
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".
Well, 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.
