We’re kicking off May with two new features in Azuqua!

First up is the addition of built-in Notifications. Now you can get daily emails summarizing your FLO successes and failures. This will give you a good view of how your processes are running and alert you to any issues.

Also releasing is our new Tables functionality. Create your own spreadsheets for data management inside Azuqua instead of being forced to use a third party program to simply store data in between steps. Use tables to easily speed up your workflow execution and eliminate unnecessary application touchpoints.

Notifications and Tables are both featured in this post, so keep reading to find out more about both of them.


Notifications

In Azuqua, we already had FLO history for you to check on your FLO executions and see how successes and failures were going. This gave you an in-depth look at where data may not be carrying over or where certain cards were failing so that you could troubleshoot effectively.

flo_history_screenshot

Well, now you can turn on email notifications for your FLOs. This setting, once turned on, will send out daily summaries of your FLO executions and failures. Notifications are great for knowing when FLOs are failing and when it is necessary to go check the FLO history for troubleshooting.

To add FLOs to the email notification, you click the envelope icon that appears when you hover over a FLO in Azuqua. You can choose exactly what time of day you want the email to be sent

notificationbuttondailyreport

Click images to enlarge

The email will consist of a list of all the FLOs you have selected along with the last time they were modified and how many successes and failures they had in the last 24 hours. This gives you a good overview of any points in your workflows that may be causing issues. The FLO names in these emails are all links to the specific FLO so you can navigate right to the issue.


Tables

Repeatedly, Azuqua developers and customers alike are forced to use a spreadsheet host like Google Sheets simply to store data during the processing of FLOs. So instead of a FLO that just connects two important applications, you end up with a data maintaining middleman that slows down the FLO and adds unnecessary connections.

With Azuqua’s new feature Tables, that problem has been solved. Now, create your own spreadsheets inside Azuqua and cut out the tedious middleman applications.

basictable


When do I use Tables?

  1. Cleanse data in between the starting and ending applications. Make sure that all the data is uniform and use Azuqua Tables to store it for usage.
  2. Manipulate data as it moves from one place to the other. Add new information based on the ending application’s data requirement.
  3. Use Tables as your FLOs run to track the number of times you’re completing different steps in your workflows. Great and easy to set up for reporting or troubleshooting.

That all sounds great, but I want a more concrete example.

Well we’ve got just the thing for you. Basically, Tables enables users to create anything that requires persistent data storage all inside Azuqua.

Data Cleansing and Manipulation Featuring Lookup Tables

Maybe you need to cleanse some data. You have your list of raw leads, but maybe you want to make sure you scan through the list and blacklist emails from your own company and emails from people who are already customers of yours. Well, putting the data into Tables gives you a sort of staging area in which to create a new list of cleansed data that can then be sent along to the next application.

datacleansing

Continuing with the same example, what if you want to manipulate the data to make it more uniform? Well, you could create lookup tables in Azuqua in order to convert data into the format that you’re looking for. Convert things like addresses into uniform information based on a wide variety of different ways that users will input info.

lookuptable

Databases in Azuqua

Don’t let the intuitive interface of tables fool you, though. Tables unlocks potential for database-backed apps to be created within Azuqua. Using tables, you can easily define, update, and interact with the data flowing through your application.

Tables allows you to create database-backed applications inside Azuqua. You can store data as specific types, define table schemas by creating columns, easily query and filter data, and more. Tables supports most of the expected database transaction methods and also has a number of other helpful features that allow you to get a database up and going in no time.

Tables supports on-the-fly changes to columns and addition of other columns, allowing you to quickly and easily make changes, with no downtime. Tables is built on scalable, flexible, responsive technology, to ensure that no data is lost and transactions are incredibly fast.


Please reach out to us at connect@azuqua.com or contact any Azuqua representative to try out these features if you don’t already have access or if you want an in-depth walk through.

Make sure to keep checking back for continued Azuqua updates on our blog!