Qdabra InfoPath Accelerator (qRules)

Add missing features to your InfoPath forms. qRules quickly injects into your form's template.

What's new?

Free upgrades for 1 year after purchase – more information is available here.

New for qRules 4.1 (released March 14, 2012):

New feature:

  • Now supports Office 365 browser forms

New commands:

  • ListDirectory - takes a path to a directory, and returns results to a field in a repeating node
  • ValidateUsers - accepts a username, a domain and a password, and will verify that the credentials are correct
  • GetTermPath - queries SharePoint’s TaxonomyClientService to obtain the path for a given term
  • GetTermSetIds - queries SharePoint to obtain a list of available TermSetsIds
  • GetUserProfileByName - retrieves the user information from SharePoint’s GetUserProfileByName web service

New for qRules 4.0 (released Jan 29, 2012):

New features:

  • Use managed metadata in your InfoPath forms using qRules
  • Now you can add keywords and terms to your InfoPath forms
  • Keywords lead to better search results on SharePoint

Read more on handling managed metadata in InfoPath...


New commands:

  • GetTermSets – Retrieve the set of terms from the taxonomy web service
  • GetTermSetsByLabel – Retrieve a set of terms based on a label or search string

New for qRules 3.4 (released Dec 20, 2011):

New commands:
  • SaveToPath - Saves the main or a secondary data source's XML to a local file
  • CreateDirectory - Creates a local directory
  • DeleteFile - Deletes a local file
  • ChangeConnectionUrl - Changes the URL for a data connection (webservice, XML file, etc.)
Also includes updates to popular commands:
  • Insert command is now iterative.
  • Improved exception messages returned by SaveToSharePoint.
  • and more...

New for qRules 3.3 (released Aug 3, 2011):

New commands:
  • GetFileName - gets the file name for your form
  • ModifySqlQuery - parameterize your SQL queries
  • OpenUrlInBrowser - open a link on a button click
  • Transform - transform a secondary data source XML into your main data source; XSLT-driven and powerful
  • ExecuteSqlQuery - call a SQL stored procedures
Also includes updates to two popular commands:
  • SubmitToSharePoint now allows a user to add an xpath filter to the repeating group they are submitting.
  • SaveToSharePoint now has the ability to specify filename.

New for qRules 3.2 (released May 31, 2011):

  • GetDayOfYear - returns an integer value indicating the day number in the year for a date value
  • GetValue - takes the innerXml or outerXml for a given xpath and stores as a string value in the QdabraRule Result field
  • Encode - use to encode or decode a string for url and uri
  • Office 365 enabled: Microsoft Office 365, with InfoPath, lets you quickly create online forms for your customers, employees, vendors, and partners. Collect information and store it in Team Site to provide immediate access, just-in-time reporting, and business process automation.

New for qRules 3.1 (released March 25, 2011):

  • Relink - switch the form template, or the version of the template of current document
  • SetFocus - set the focus to the specified xpath
  • DeleteFromSharePoint - allow users to delete a document in SharePoint
  • Context node is added to the QdabraRules (Secondary data connection) to identify which node currently has focus

New for qRules 2.4 (released December 21, 2010):

  • GetXML - support the extraction of any node’s InnerXml or OuterXml as a string
  • QueryData - call a Web Service and specify a timeout and capture web service error messages
  • Replace supports changing namespaces - swap out an XML with one from another namespace
  • Add Days - date calculation support for forms
  • Improved functionality - more descriptive error messages

New for qRules 2.3 (released September 24, 2010):

  • SetCaption - sets the window caption. Great for DBXL customers who want to have the “Title” of their document show up in the Title Bar instead of the DocID, or for anyone who doesn’t like the default InfoPath Captions (client only)
  • AttachToSharePointList - saves attachments to list items so you can replace with a link and a filename attribute instead, includes logic to create a unique filename for attachment in list, or provide your own name. Also works for repeating attachments.
  • Generate Random Number - useful for forms that need to generate a random number. Allows setting of upper or upper and lower bounds for the random number.
  • Get Environment - returns Mobile, Browser, or Client. Use with SetDefaultView to choose which view a form opens with depending on the environment.
  • Refresh SharePoint List items - used in tandem with SubmitToSharePointList to update list items with most recent edits to the list. Supports changes, including deletes. Can be used in either report or update mode.
  • Get Full Date Time - returns milliseconds for people who want to use date time as a unique ID. Supports optional format.
  • Set Default View - switch view on open using Get Input Parameters or GetEnvironment to choose a different view to set as default
  • SetSave - gives the form designer access to a variety of previously code-only save options, such as dynamically allowing save, or setting the save location (client only)
  • SubmitToSharePointList - new parameters added to include attachments (single and repeating). Includes all the options available for AttachToSharePointList. Now supports submission of rich text to SharePoint List rich text columns (mapping must be created with updated IPToShP List tool)
  • SaveToSharePoint - new option to provide data source to SharePoint’s Copy Web Service to allow saving images or files to a different server than where the form resides (no cross domain issues)
  • Copy Table - fix to prevent the view from being left in a non-updatable state.
  • IPToShP List tool - adds ability to mark a field as rich text for use in submit to SharePoint list OR when using the tool as stand alone
  • Injector - new ability to choose if you want browser or client compat; if you choose client, you can also use SetSave & SetCaption. Supports re-injecting and updating from client to browser.

New for qRules 2.2 (released June 22nd 2010):

qRules 2.2 simplifies your solution by allowing you to use simple rules to access powerful form functionality.

  • Insert and Remove Processing Instruction - No code needed to change where your form resides. Eases migration.
  • Clear Errors - Publish XML forms with errors. Great for testing!
  • Get Attachment Attribute - Extract the details, including file name, extension, and size
  • Delimited List - Concatenate a repeating field into a single delimited value.

Added in qRules 2.1 (released March 15, 2010):

  • Password Protect - hide sensitive data using client-side encryption.
  • Format Date - format your dates from SharePoint or SQL and show just the year, month, or day.
  • Get Week Day - get the date value for a day of the week and improve your forms’ usefulness. Use Get Week Day in an open rule to quickly calculate the date for a weekday and populate your form based on it.

Previous features:

  • Submit To SharePoint List - now browser compatible. Submit your XML form to a SharePoint list.
  • Filter SharePoint data - dynamically filter SharePoint data (uses owssrv queries).
  • Change Submit URL - dynamically switch form library for SharePoint submit.
  • Copy Rich Text - copy a rich text field.
  • Set Value - use a filter to specify the target field in a repeating list.
  • Save To SharePoint - save a file, a set of files, an image or a set of images to SharePoint.
  • Generate GUID - need a unique identifier (UID) for your form? Use this command to generate a globally unique identifier.
  • Copy Table - copy data from one table to another.
  • Replace - replace data from one group to another; able to handle a more complex node structure.
  • Move Table - move data from one table to another.
  • Sort Table - sort the table.
  • Insert - insert a row into a repeating table.
  • Delete - delete nodes from a table.
  • Execute Action - execute a view action. For example, insert an optional section.
  • Get Error Count - get the number of errors in the current XML.
  • Is Dirty - check the dirty flag in the form to see if the form has changed.
  • Set Dirty - set the dirty flag.
  • Get Input Parameter - return the value of input parameters.
  • Date Diff - calculate the difference between two dates.
  • Is New - check whether the form is newly created and has not yet been saved nor submitted.
  • Is Read Only - check whether a form is in a read-only state (i.e. users cannot save the form).

For our DBXL Web Service customers, we also include some common commands that you can use with DBXL (for a free trial of DBXL, click here):

  • Save To DBXL - save a file, a set of files, an image, or a set of images to DBXL.
  • Submit To DBXL - submit a form to DBXL Web Service, which then maps to SQL and SharePoint.
  • Remove DBXL Processing Instruction - when you want to copy an existing form, use this to remove the document ID of your currently open form so it can be saved as a new form.