Concepts Primer – Using Javascript in Workflow Forms

The first exposure I had to implementing javascript actions in Workflow processes was when claus66 posted a solution in this post on Symantec Connect.  The question that was posed was, how is the “Enter” keystroke captured and used to automatically click a specific button?  The answer in that post:

if (event.keyCode == 13){
event.cancel = true;;

At the time, I had no idea how it worked, just that it did.  Afterwards, I looked for opportunities to test other ways I could use javascript to enhance the user experience for my forms.

Continue reading

Concepts Primer – Integrating SQL Data with Symantec Workflow

SQL integration of some sort has been involved in almost every project I’ve done.  Saving and fetching data is just part of it; the SQL engine can be used to quickly do calculations and filtering for your data with the right scripting.  If I’m able to fetch and filter the appropriate data from SQL to begin with, I don’t have to then run through a Configurable Collection Filter to get the results I want.

Continue reading

Basics – Variable Efficiency: Declaration and Source

Buried in this process are way too many static values (not to mention that this screenshot will be a great illustration for my “Making Modular Workflows” article I’m working on).

Sprawling Workflow Canvas
Don’t judge my sprawling process. I was still finding my sea legs.

When I first started developing Workflows, especially processes that integrated with other systems (SQL in particular), I would occasionally run into this:

“Hi Andrew, we need to move the SQL server you’ve integrated with.  Here’s the new connection info.  Hope it’s not a big deal.  You declared your connection string variable up front, right?”

Oops.  Well, dozens of components buried in layers of embedded models later, I had updated all the SQL components.  Except this time, I used a project property.  The next time the SQL connection string needed to change, I updated a single value, published, and enjoyed the success.

Continue reading