Text Field Cleanup

Text Field Cleanup scheduler job purpose is to modify text fields in the context records, that are retrieved from a defined SOQL Query.

Step 1: Register Scheduler Job

To create Scheduler Job go to Breezz Setup → Scheduler Jobs → click New or simply schedule a job from a Dashboard by clicking Schedule Job tile.

Text Field Cleanup Scheduler Job Text Field Cleanup Scheduler Job

Set fields as follows:

  • Input Name for Scheduler Job and a comprehensive Description.
  • For Job Type select Text Field Cleanup.
  • Execution Interval indicates the time when scheduler must be executed, in this example let it be 03:00 am on a daily basis.
  • In SOQL Query use a SELECT statement to return records on which you want to work.
  • In Record Configuration section configure record fields you want to clean. Available cleaning features:
    • Truncate,
    • Trim,
    • Uppercase,
    • Lowercase,
    • Capitalize,
    • Uncapitalize,
    • Delete Whitespaces

Click save.

Step 2: Check Scheduler Job

To check if a scheduler was created go to App Launcher → Breezz → Breezz Scheduler Jobs → All Custom Jobs.

Here you can see your Scheduler:

Scheduler Record Scheduler Record

Text Field Cleanup is designed to work with fewer records and to work more frequently. To work with more records, e.g. 10,000. We should use Text Field Cleanup - Batch which is described on the next page.