Always make sure to test all your projects after upgrading to the latest version of Foxtrot RPA! To ensure proper operation, all Foxtrot servers and workstations are required to run the same version. Upgrade the Foxtrot server first, followed by all Foxtrot workstations. Uninstalling will never delete Foxtrot scripts or databases.

Version 13.0.3 - Download

Smarter Table Handling

Web tables appear to be a single table to a user. It is not until you use a Move Highlight or Search Action do you realize that each row on the screen is actually it own individual table. This is apparent when the table highlight gets stuck and cannot be moved off the first row (since it is technically already in the "last row"). Foxtrot now detects these scenarios and is equipped to handle things automatically for you. When detected, the new Bridge rule is set to Yes automatically. This gives the highlight permission to jump to the next neighboring table (below or above it) as long as that table appears to be related. Set the Bridge rule to No if you do not want this behavior.

The following Actions benefit from this new feature:

Action Name		Description
	Clear Highlight	Clears the highlight in a browser table.
	Get Info	Retrieves information about the target.
	If	Provides logic in a script.
	Move Highlight	Moves the highlighted cell in a browser table.
	Search	Searches for and selects an item from a target, such as a list box.

New SQL Actions

The following Actions have been added allowing interaction with a SQL server:

Action Name		Description
	Execute SQL	Execute an SQL statement to return records from an SQL server.
	Stored Procedure	Run a Stored Procedure on an SQL server.

New PDF Actions

The following Actions have been added allowing greater control over PDF documents:

Action Name		Description
	Extract PDF Pages	Extracts pages from a PDF document.
	Merge PDF	Merges PDF documents into a single document.
	Split PDF	Splits a PDF document into two or more parts.

Improved Data Import

Data import time has been reduced by up to 40% with the new optimized data import wizard.

Improved Select Item Action

The Select Item Action has been improved allowing the user to choose how the item will be selected with the mouse. Available options are Click and Double Click.

Destination Nested Tokens

Nested tokens can now be used when specifying a destination for certain Actions, such as the Get Value. This is an advanced feature allowing users to specify an indirect reference to a variable.

Practical Example

My project contains three variables: Value1, Value2, and Index.

I am creating a Get Value Action. Instead of specifying Value1 or Value2 as the Save to destination, I want the destination to be dynamic. I want to control the number using the Index variable. I can do this by nesting the Index variable like so: [%Value[%Index]]

Now when I run the Get Value Action when:

· the Index variable is set to 1, the result will be stored in the Value1 variable.

· the Index variable is set to 2, the result will be stored in the Value2 variable.

The following Actions now support destination nested tokens:

Action Name		Description
	Calculate	Performs mathematical calculations.
	Decrease Field	Decreases a field value by a specified amount.
	Decrease Variable	Decreases a variable value by a specified amount.
	Drive Exists	Determines if a mapped drive exists on the computer.
	File Exists	Determines if a specific file exists on a local or remote drive.
	File Prompt	Prompts the user to select a file path.
	Folder Exists	Determines if a specific folder exists on a local or remote drive.
	Folder Prompt	Prompts the user to select a folder path.
	Formula	Manipulates text, numbers and dates by offering over 65 robust functions.
	Get Info	Retrieves information about the target.
	Get Value	Retrieves the value from a target, such as the text in a textbox.
	Increase Field	Increases a field value by a specified amount.
	Increase Variable	Increases a variable value by a specified amount.
	OCR	Takes a picture of a target, then extracts the text from the image using OCR technology.
	Pixel Exists	Determines if a target pixel is found on the screen.
	PowerShell	Executes a PowerShell script.
	Process Exists	Determines if a specific process is running.
	Prompt	Prompts the user to enter a text or number value.
	Question	Displays a question to the user and waits for an answer to be selected manually.
	Search	Searches for and selects an item from a target, such as a list box.
	Search Cells	In Excel, searches cells for a specific value.
	Search Screen	Searches the emulator screen for a specific value.
	Service Exists	Determines if a specific Windows service exists.
	Set Field	Places a value in a specific database field.
	Set Variable	Places a value in a specific variable.
	Target Exists	Determines if a specific target exists.

Improved Close Actions

In previous versions, in certain scenarios, the following Actions would display a message box indicating the project was complete. This message box would prevent the Action from completing and would cause the application to stay open until the message was dismissed manually. This behavior was especially problematic if the application was started by batch file as it would not allow the process to complete. This has been fixed.

Action Name		Description
	Close Me	Closes Foxtrot.
	Log Off	Logs off the workstation.
	Reboot	Reboots the workstation.
	Shut Down	Shuts down the workstation.

Improved Window Actions

In previous versions, the following Actions may not be available for certain secondary windows in the target application. This has been fixed and these Actions are now available when targeting any window title bar.

Action Name		Description
	Close Window	Closes the target window.
	Maximize Window	Maximizes the target window.
	Minimize Window	Minimizes the target window.
	Move Window	Moves the target window to the desired location on the screen.
	Resize Window	Resizes the target window to the desired dimensions.
	Restore Window	Restores the target window.
	Show Window	Shows a window by bringing it in front of other applications.

Improved Search Cells Action

The Search Cells Action how properly locates large numbers and Scientific Notation values.

In previous versions, the Search Cells Action would jump to the wrong cell if the target range contained only one cell. This has been fixed.

New Note Shortcut

A shortcut (Ctrl+T) has been added allowing a user to quickly add a note to an Action.

Fixed: Formula Preview

In previous versions, the Formula Action would fail to display a preview value once an invalid Field or Variable token was detected in a parameter field. This has been fixed.

Fixed: Prompt Action

In previous versions, the Prompt Action would fail to properly save the Min value for Number input. This has been fixed.

Fixed: Create Variable Action

In previous versions, the Create Variable Action would fail to set the value of the created variable when Type was set to something other than Text and the value contained a token. This has been fixed.

Fixed: Project Report

In previous versions, the Project Report would display Action notes incorrectly in certain scenarios. This has been fixed.

Fixed: Action Count

In previous versions, the Run Task Action did not display the correct number of Actions in each Task. This has been fixed.

Fixed: Disabled Else Action

In previous versions, if the Run Arrow entered a disabled If statement and reach the disabled Else Action, the Arrow would jump down to the End If step. This has been fixed. The Run Arrow now properly ignores and continues past disabled Else Actions.

Renamed Action

The following Actions have been renamed to improve consistency and/or clarity:

Old Name	New Name
Join Images	Merge Images

Fixed: Missing Action Icons

In previous versions, Search and Send Value Actions that utilized Application Intelligence would not show an Action icon. This has been fixed.

Miscellaneous Fixes

This release also includes other minor bug fixes and usability improvements.

Articles in this section

Foxtrot Suite v13.0