Add-ons

Extracts process data as single-line TSV string. Items are specified in CSV format such as “0,2,3”. Tab code and line feed code are automatically deleted. Discussion type, Table type, Guide-Panel type cannot be extracted (Warning Log).

Generates a random number. When a token reaches this automated step, a numerical value within the specified range is generated each time. The decimal part is rounded down toward 0 according to the workflow data definition.

Concatenates all string type data. Searches and joins string data and title strings stored as workflow data of Questetra BPM Suite. A line break is added between each data. It is used for checking the existence of keywords.

Lists the download URLs for the files stored as workflow data of Questetra BPM Suite. If two files are attached, output two lines of text. This is useful for browser extensions and email text attachment.

Sums the numeric values in the specified range. Values that cannot be recognized as numeric values are regarded as zero. Two ranges of simultaneous calculations are also supported. e.g. The budgeting progress in the general ledger is summarized.

Aggregates data of Step Count and Distance (meters) in Google Fit. Multiple data sets from multiple sources (including manual input) can be aggregated. Note that the results of simultaneous measurement with multiple devices are all added up.

Replaces all instances of text matching the specified string with replace text. The search is case sensitive. The number of replacements is output as a log. In many cases, the automated step “Google Drive: File; Copy” is placed upstream.

Exports the specified file in the Drive to the Workflow Data Item in Microsoft format: docx, xlsx, or pptx. If a file other than a Google file (Docs / Sheets / Slides etc.) is specified, an error will occur. File ID can…

Exports the specified file in the Drive to the Workflow Data Item in PDF format. If a file other than a Google file (Docs / Sheets / Slides etc.) is specified, an error will occur (Please use File Download). File ID can…

Downloads the specified file in the Drive to the Workflow Data Item. If a Google File (Docs / Sheets / Slides, etc.) is specified, an error will occur (Please use File Export). The File ID can be obtained from the sharing settings…

Replaces all instances of text matching the specified string with replace text. The search is case sensitive.

Refreshes all embedded charts in the specified slide by replacing them with the latest version from Google Sheets.

Duplicates the specified slide and inserts it on the next page. If no slide is specified, the last slide is duplicated.

Generates an image of the specified page in the presentation with generating a URL to the image which has a lifetime of 30 minutes. Note that if the presentation sharing settings are changed, access to the images may be lost.

Generates a new TSV with concatenating the suffix Str to all cells in the column. The concatenated strings are added at the end of the line. Available for name honorifics or currency units etc. Removes whitespace from both ends of a string.

Generates a new TSV with concatenating the prefix Str to all cells in the column. The concatenated strings are added at the end of the line. Available at categorization etc. Removes whitespace from both ends of a string.

Generates a new TSV with adding N to each number in the number column. Calculation results are added at the end of the line. Available at discounted price table etc. Removes whitespace from both ends of a string.

Generates a new TSV with multiplying N by each number in the number column. Calculation results are rounded off and added at the end of the line. Available for tax calculation etc. Removes whitespace from both ends of a string.

Deletes the Footer lines of a multiline string, like legacy Banking Formats or legacy EDI Data. Note that blank characters at the end or beginning of string data are deleted in advance. If singleline text, an empty string will be returned.

Deletes the header lines of a multiline string, like CSV text or TSV text. Note that blank characters at the end or beginning of string data are deleted in advance. If singleline text, an empty string will be returned.