Easy-Config Addon

Converter: Email-String to Quser

Converter: Email-String to Quser

Converts an Email string to USER data. If the address is not registered as a user address, an error will occur (USER not updated). If multiple addresses are enumerated in multiline or comma-delimited string, determined sequentially from the top.

OpenAI: Chat, Start

OpenAI: Chat, Start

Starts a conversation with the OpenAI API (ChatGPT). The MODEL used is “gpt-4” by default (configurable). A response (COMPLETION) to an instruction question (PROMPT) is automatically obtained.

OpenAI: Chat, Start

OpenAI: Chat, Start

Starts a conversation with the OpenAI API (ChatGPT). The model ID used is “gpt-3.5-turbo”. A response (COMPLETION) to an instruction question (PROMPT) is automatically obtained.

Files, Duplicate

Files, Duplicate

Duplicates File-type data. All files stored in Data Item A1 (Original Files) will be copied over to Data Item B1 (Clone Files). Also possible to change the file name or Content-Type. If the same Data Item is specified as A1 and B1, overwritten.

Two Datetimes, Calculate Duration

Two Datetimes, Calculate Duration

Calculates the duration between Datetime-A and Datetime-B; like elapsed days (e.g. “1.38 d”), hours (e.g. “33.33 h”), minutes (e.g. “2000.00 min”) and/or time (e.g. “33:20”). A minus sign is given if Datetime-B is earlier than Datetime-A.

String, Batch Replace to LowerCase

Replaces uppercase letters in the text with corresponding lowercase letters. An input of “ABC”, “Abc”, “abc” will all be output as “abc”. It is used to store case-insensitive data such as Internet domain or search words.

String, Batch Replace to UpperCase

Replaces lowercase letters in the text with corresponding uppercase letters. An input of “ABC”, “Abc”, “abc” will all be output as “ABC”. It is used to store case-insensitive data such as MS-DOS file names or BASIC codes.

Singleline String, Set Nth Line of Multiline

Singleline String, Set Nth Line of Multiline

Extracts one line of a multi-line string and sets that line in single-line String-type Data Item. The Line ID mut be an integer starting with zero. If the Line ID is not specified, or if a number outside the range is specified, the last line will be extracted.

TSV String, Sum Numeric Column

TSV String, Sum Numeric Column

Sums the values in the numeric column in the TSV. If the numeric field contains commas, they will be removed and then parsed. If you need to add up for each key, use “Summary tabulation” or “Cross tabulation”.

Date, Get Weekend Sunday

Date, Get Weekend Sunday

Gets weekend Sundays of any date. If Sunday is specified, that day itself will be returned. If you want to get “Monday of the next week” or “Tuesday of the current week”, you need to convert like #q_date.addDays(1) or #q_date.addDays(-5).