SFDC Connector - Snapshot Then Track
I know... the title sounds weird. I'll try to explain. I have a Workflow set up with the SFDC Connector. It's currently tracking all opportunities entered by the sales reps within a specified period of time that are staged as [OPEN]. My challenge is that I'm developing a project management process that relies on seeing the stages of those opps progress. The only way I've been able to make it work is to edit the workflow to show ALL stages of opportunities entered within the time frame. When I do that, I get 4,007 line items (which is seriously cutting it close to the limit in my opinion).
Conceptually speaking, what WOULD work is if I could somehow tell the connector to look at everything that's [OPEN] "right now", and then let me see the stages of progression of those opportunities (and new ones that will be created ongoing). Practically speaking, I'm not sure I can get that to work. As soon as I tell the connector to filter out non-open stages, it'll continue to run that logic, and the line items (as they progress) will filter out of sync.
Has anyone had this kind of challenge before? Any ideas? Please and thanks in advance!