Add SQL Records, Advanced Calculations, and (Even More) Easy References to Your SharePoint Workflows with Workflow Conductor 1.5

Since the release of Workflow Conductor 1.5 last month, I’ve been writing about all the exciting new features in this version. In case you missed the previous posts: so far, we’ve covered:

I’ll be wrapping up this month-long series about Workflow Conductor 1.5 with a few of the updates to existing Workflow Conductor widgets and features. Without further ado…

New Date, String, and Mathematical Calculations

In Workflow Conductor 1.5, we’ve greatly expanded the functionality of the Calculate Widget to support 20 Microsoft Excel-style date, string, and mathematical functions. Functions can be combined and nested any way you want, to enhance your workflow logic. The new Calculate formula builder supports lookups, too, so your formula can adapt to current conditions.

Support for SQL Records and SQL Insert/Update/Delete Statements

Workflow Conductor has always had the ability to retrieve a single value from an external database using the Query Database Widget. With Workflow Conductor 1.5, you can now retrieve an entire record, and use that record to create new items in SharePoint lists. Also new in this release is support for insert, update, and delete statements, making it even easier to keep your SharePoint and external data in sync. As before, the Query Database Widget supports SQL Server, Oracle, OLEDB, and ODBC connections.

Even More Easy References!

We love making things easy, and Easy References are one of our favorite ways to easily customize workflows with values that are updated every time the workflow runs. Insert Easy References in task descriptions, task e-mails, and Widget properties – anywhere you see the lookup icon or Add Lookup button. For more on Easy References (and other types of lookups), take a look at this previous Conductor blog post or the Workflow Conductor online documentation. We have Easy Reference lookups for everything from the current time to the current item URL, with a dozen more added just for this release. For a complete list of Easy References, click here.

Now that you’ve read about all the new features, head on over to the Workflow Conductor product page to download a free 30-day trial so you can check them out for yourself.

Look for an announcement soon about Workflow Conductor 1.5 for SharePoint 2010 – coming later this month! I’m excited, are you??

 


SharePoint

Applications

SharePoint apps are stand-alone applications that perform specific tasks on a SharePoint site. Apps can perform functions such as managing a discussion board or knowledge base, performing project management or time tracking tasks, or doing other workflow operations.

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


SharePoint

Web Parts

Extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of Web Parts. Web Parts are the building blocks of pages on a SharePoint site that can be used to customize the user interface and content of a site page. 

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


Office 365

Cloud Parts

Cloud Parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft Office 365. More than mere ports of existing software to the cloud, our Cloud Parts have been built from the ground up to take advantage of the best that the cloud has to offer.

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Cloud Parts Suite for O365/SP Onl.


Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!