Converter: TSV-String to Table

Converter: TSV-String to Table

Converts a TSV String to Table-type data. The string values of all cells in the TSV string are copied over to Table-type data B. If there is an inconsistency in the Table column design, an error may occur.

MoneyForward Journal, Create

MoneyForward Journal, Create

Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only batch sales invoices but also invoices that are prorated for each month.

Two Tsv Strings, Compare Numeric Cells

Two Tsv Strings, Compare Numeric Cells

Compares numeric column strings in TSV-A and TSV-B, and lists the amount of change from A to B. If there is no string that matches the key column of A, it will not be listed. If there are multiple matches, they will be compared to the numbers in the key rows above them.

String, Get Number of Characters

String, Get Number of Characters

Gets the number of characters in the text. Consecutive blanks (including tabs and double-byte spaces) are counted as one character. The number of characters that do not count linefeed codes and blanks can also be obtained.

Two Tsv Strings, Extract Cell-Matched Lines

Two Tsv Strings, Extract Cell-Matched Lines

Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that have a matching cell in A. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.

Two Tsv Strings, Extract Cell-Mismatched Lines

Two Tsv Strings, Extract Cell-Mismatched Lines

Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that do not have a cell match for A. If A and B match exactly, an empty string is returned. If they are completely different, all lines in B are returned.

Master Table, Backup

Master Table, Backup

Backs up the master information shared in the Workflow Platform by saving as it an Options-XML file. If the specified master name does not exist, an error will occur. To save as a different name, specify the backup file name.

Master Table, Create by TSV String

Master Table, Create by TSV String

[su_box title="Master Table, Create by TSV String" style="soft" box_color="#ff99ff" title_color="#000000" radius="0"] Creates a new master file (OptionsXML) by referring to the TSV String. The specified column data are set as Master IDs, and the other data is set as Master Labels. By placing a [Service Task (Choices Update)] in the downstream process, the update task can be automated.[/su_box]

Online Estimate Storage Flow

Stores quotation PDF automatically to share. A quotation PDF is automatically generated after the submittee, details and total amount are entered at the Task of “Drafting Quotation”. After the quotation is submitted, the quotation which succeeded in the contract is automatically uploaded to the Dropbox folder.

Two Datetimes, Calculate Duration

Two Datetimes, Calculate Duration

Calculates the duration between datetime A and B to output as numerical value (days), numerical value (hours), numerical value (minutes), or string value (h:mm). If B is the past time, a minus sign will be added. Date type also available

TSV String, Create Cross Tab for Numerical Sum

TSV String, Create Cross Tab for Numerical Sum

Creates a crosstab table (or pivot table) for the numeric fields of TSV data. For example, the “Amount” in the order history (TSV) is aggregated on the two axes of “Person Responsible” and “Product”. The fields for X-axis and Y-axis aggregation are specified by the TSV field ID.