UPDATE: A new version has been released.

Iā€™m proud to announce Release 2.1 of my open source project Mass Action Scheduler! Declaratively schedule Process Builder, Flows, Quick Actions, Email Alerts, Workflow Rules, and Apex to process records from Reports, List Views, SOQL queries, and now, Apex iterables.

This release delivers community-requested enhancements, better report field mapping support, and a new Apex source type. This release truly is a great combination of the power of clicks and code. If you already have the app installed in your org, check out Upgrading to Release 2.1.

In this blog post, I’ll cover the most exciting new features of this release.

Query Data The Way You Want With New Apex Source Type

The Apex Source Type supports classes that implement Iterable<Map<String, Object>> and is an advanced technique that gives you full control over the source data to process.

For example, your Apex class can make multiple SOQL queries, apply complex data filtering, or retrieve data from an external web service with http callouts. Check out the test project that provides read-to-deploy Apex iterable and Flow for the Sync External Data with Apex and Flow example.

Learn more about custom iterators in the Apex Developer Guide.

Use More Powerful Filters In Your SOQL Queries

Craft more powerful queries now that the SOQL Source Type supports equality operators like <, <=, >, >=, and literal and relative date filters.

For example,

SELECT Id FROM Account WHERE CreatedDate >= 2019-02-01T15:30:00Z 

SELECT Id FROM Task WHERE ActivityDate = LAST_N_DAYS:30 

SELECT Id FROM Opportunity WHERE CloseDate < YESTERDAY

True is True and False is False when Mapping Fields From Reports

Previously, some people would receive an error if their configuration used a Report Source Type and mapped checkbox, date, or currency fields. For example, an error log would include value not of required type: false when mapping a checkbox field from a Report to a Flow input variable of type Boolean.

In this release, the correct underlying source values and data types of report columns map to their target fields as expected.

Assign Field Mappings Quicker With Sorted Options

Find and assign field mappings quicker and easier now that the source and target options are sorted alphabetically.

Next Steps

  • Install the Mass Action Scheduler app in your org (always test in a sandbox first).
  • Join the Mass Action Scheduler group on the Trailblazer Community.
  • Let me know in the comments, community group, or on Twitter (@DouglasCAyers) what you like (or don’t) about the app and how you’re using Mass Action Scheduler to automate business processes at your company.

Thank you all for your feedback and enthusiasm for this project, it means a lot to me!