Batch Wizard

Go to:

Tools, Batch Wizard…

The Batch Wizard allows you to specify certain changes that will be applied globally across your entire application, rather than having to make those changes in many different places in your application.

The changes you can make are:

Initialization Formulas

You can make global changes based on a field name. For example you can apply the same formula for a field everywhere the field is used. It does not depend on any particular table. For example, this formula is applicable to any table which contains the column CreatedOn:

Initiate when Inserting CreatedOn = Today()

And the following formula applys to any table which contains the column UpdatedBy:

Initiate when Updating UpdatedBy = UserID()

…where UserID() is the built-in function returning logged-in user’s name.

You might not want to show these fields on the pages and use it as audit trails.  To do this, go to Tools à Application Wizard à Options and specify the fields you would like to exclude separated by comma.  After that, these fields will not be shown on the new pages that you create in the future.

Validation Formulas

Validation formulas are used for performing a validation on a column before the data is being saved in the database.

Validate when Inserting If(BirthDate > Today() , "Birthdate cannot be in the future" , "")

…where BirthDate is the name of a column the database.

The Batch Wizard allows you to apply this formula everywhere in the application based on the column name, instead of having to apply it to each page individually.


WHERE Clauses

WHERE Clauses specified in Batch Wizard can define multi-tenant applications. As an example, if a particular data needs to be shown depending upon the signed in user’s company, then it can easily be achieved using the following WHERE clause in the Batch Wizard.

AccountCompanyId = GETCOLUMNVALUE("AccountUser",UserId(), "AccountCompanyId")

…where AccountCompanyId is a Column present in the database.  The GetColumnValue formula fetches a value of AccoutCompanyId for the currently logged in user.

In some special cases, you might want to not to use Global WHERE Clause on your code customization.  To do this, set IgnoreGlobalWhereClause to True in the WhereClause object.  Here is an example:


Dim wc As WhereClause = New WhereClause("AccountCompanyID='" & gSettingsRec.BuckarooAccountID.ToString() & "' and EmailAddress='" & merchantEmailRec.EmailAddress & "'")

wc.IgnoreGlobalWhereClause = True

Dim contacts() As ContactsRecord = ContactsTable.GetRecords(wc, Nothing, 0, 2)


WhereClause wc = new WhereClause("AccountCompanyID='" + gSettingsRec.BuckarooAccountID.ToString() + "' and EmailAddress='" + merchantEmailRec.EmailAddress + "'");

wc.IgnoreGlobalWhereClause = true;

ContactsRecord[] contacts = ContactsTable.GetRecords(wc, null, 0, 2);

Button Actions

Batch Wizard allows you to quickly search through your entire application and globally change button behavior for new pages.  Once you choose an action in the Select step and proceed to the Configure step, you will see a list of controls that satisfy the search criteria. You can filter buttons by Folder name, Page name, Control name, redirect URL or button type.

Note that only those controls which are eligible for the change are shown in the list.  For example, if you select the “Open page in pop-up” action, only those buttons which presently configured to redirect or open page in new window will appear. Buttons that already have an action configured to “open page in modal pop-up” will not appear in the list. Also no buttons without a redirect URL property will be shown because they are not eligible for this action (for example, export buttons will not show up).

Select the controls you wish to re-configure and click Finish to complete the operation.


Folder name

Specify a folder name to be searched.  For example, to select buttons in the Categories folder, specify folder name as “Categories” and select “Whole word”

Page name

Specify a page name to be searched.  For example, to find buttons only on add record pages, type in  “Add” and select “Starts with” option.

Control name

Specify a control name to be searched.  For example, to find buttons which redirect to edit record pages, put “Edit” and select “Contains”. 

Control Type

Select button type.

Redirect URL

Filter by a redirect URL.  For example, another way to get a list of edit buttons is to search for “/Edit” and select “Contains”.


Selector Control Types

You can change a control type globally using Batch Wizard. Iron Speed Designer allows you to choose between dropdown lists or list boxes and Quick Selector controls. To change Quick Selector controls to a dropdown list or list box, select the “Dropdown List/ List Box” option and proceed to the “Configure” step.

Similar to the New Pages Button Action (see above), you may filter controls by Folder name, Page name or Control name.