Automating Workflows – The shortage of scalable tools
by Jonathan Sapir, on
For decades, many IT organizations have been dealing with developers outside of the IT department as if they were insurgents – their weapons were Excel and Access.
–Mike Rollings (Gartner), Citizen Development: Reinventing the Shadows of IT
Knowledge workers need to use multiple systems to get their work done, often with a combination of enterprise process applications, other data sources, and end-user computing tools such as spreadsheets. They frequently have to work around the predefined process in some way, especially for collaboration and customer communication. The systems may be augmented or integrated in an ad hoc, unsupported manner in an attempt to improve the functionality and information context, which is why automating workflows is so important.
Few organizations, until now, have actively supported the efforts of their knowledge workers to solve problems themselves.
But this doesn’t mean that knowledge workers have simply accepted this. They have gone off and found whatever tools they could to help them get their jobs done.
The tools knowledge workers use today to help them achieve their objectives are like the land of mutant toys.
Without automating workflows, they do just a fraction of the job needed, they can’t work together, and they create a slew of problems, including:
Duplication of data
Lack of security
Lack of scalability
Lack of oversight
Need for hardware and software
Inability to be included in workflows
Inability to leverage new technology
Indiscriminate use and abuse of spreadsheets is typically rampant, resulting in:
spreadsheets being emailed around the organization for data collection and synthesis;
spreadsheets being used as part of a core process without anyone really knowing how they work;
spreadsheets so massive that a human can’t possibly comprehend them;
employees spending an inordinate amount of time cutting and pasting, updating, consolidating and re-entering data onto spreadsheets;
frequent instances of out-of-date information in spreadsheets;
multiple versions of the same spreadsheet circulating around the company; and
spreadsheets being used to produce recurring, error-prone reports.
Stop spreadsheet abuse!
This is where Xpeditor on Salesforce App Cloud comes in.