EasyCatalog Custom Fields

EasyCatalog Custom Fields comprise powerful functionality to allow you to organise, manipulate and extend your data.

Barcodes

CODE128 - Converts string to CODE128 barcode glyphs

 1164 views June 1, 2018 admin 0

EAN13 - Converts string to EAN13 barcode glyphs

 2348 views June 1, 2018 admin 5

EAN8 - Converts string to EAN8 barcode glyphs

 213 views June 1, 2018 admin 0

GETBARCODEGLYPHS - Return glyphs from barcode font

 171 views June 1, 2018 admin 1

UPC - Converts string to UPC barcode glyphs

 185 views June 1, 2018 admin 0

Grouping data

GROUPCROSSTABLEHEAD - Get cross table column heading

 154 views June 1, 2018 admin 0

GROUPCROSSTABLEVALUE - Get cross table cell content

 97 views June 1, 2018 admin 0

GROUPINDEX - Create index based on field names

 200 views June 1, 2018 admin 0

GROUPISFIRST - Identify first n records

 164 views June 1, 2018 admin 0

GROUPISLAST - Identify last n records

 68 views June 1, 2018 admin 0

GROUPLAST - Identify last record in group

 88 views June 1, 2018 admin 0

GROUPLIST - Convert field values into list

 658 views June 1, 2018 admin 2

GROUPMAX - Identify maximum value in a group

 99 views June 1, 2018 admin 0

GROUPMIN - Identify minimum value in a group

 128 views June 1, 2018 admin 0

GROUPONCHANGE - Identify field changes

 110 views June 1, 2018 admin 0

GROUPRTOTAL - Calculate running total

 152 views June 1, 2018 admin 0

GROUPSCRIPT - Call LUA-based script

 200 views June 1, 2018 admin 0

GROUPSNIPPETDEPTH - Return depth of snippet

 55 views June 1, 2018 admin 0

Logic /Conditions

AND - Test if all arguments are true

 194 views June 1, 2018 admin 0

COMPARESTR - Compare field contents with value

 110 views June 1, 2018 admin 0

GROUPISFIRST - Identify first n records

 164 views June 1, 2018 admin 0

GROUPONCHANGE - Identify field changes

 110 views June 1, 2018 admin 0

NOT - Return logical opposite of parameter

 69 views June 1, 2018 admin 0

OR - Test if any arguments are true

 169 views June 1, 2018 admin 0

Maths functions

AVG - Find average of values

 143 views June 1, 2018 admin 0

DECTOFRAC - Convert decimal to fraction

 91 views June 1, 2018 admin 1

DIV - Divide one number by another

 121 views June 1, 2018 admin 0

FRACTODEC - Convert fraction to decimal

 66 views June 1, 2018 admin 1

GROUPCOUNT - Count groups or records in a group

 422 views June 1, 2018 admin 0

GROUPFIRST - Identify first record in group

 228 views June 1, 2018 admin 0

GROUPMAX - Identify maximum value in a group

 99 views June 1, 2018 admin 0

GROUPRTOTAL - Calculate running total

 152 views June 1, 2018 admin 0

GROUPSUM - Calculate total of given field in group

 213 views June 1, 2018 admin 0

IF - Test if any arguments are true

 630 views June 1, 2018 admin 2

MAX - Select maximum value

 85 views June 1, 2018 admin 0

MIN - Select miniumum value

 50 views June 1, 2018 admin 0

MOD - Display remainder after division

 76 views June 1, 2018 admin 0

MUL - Multiply two values

 102 views June 1, 2018 admin 0

RANDOM - Create random number integer

 111 views June 1, 2018 admin 1

ROUNDVAL - Round a given value

 185 views June 1, 2018 admin 0

SUB - Subtract one value from another

 91 views June 1, 2018 admin 0

SUM - Add a series of values

 80 views June 1, 2018 admin 0

Miscellaneous utilities

CALLSCRIPT - Call and retrieve a script

 192 views June 1, 2018 admin 0

CASE - Find given key in list

 90 views June 1, 2018 admin 0

DEPENDSON - Create dependency on field

 92 views June 1, 2018 admin 0

DOCUMENTIMPORTPAGE - Set document page to import

 87 views June 1, 2018 admin 0

DOESIMAGEEXIST - Test for existence of image

 130 views June 1, 2018 admin 0

DSSTATUS - Check data source status

 66 views June 1, 2018 admin 0

ENV - Display environment information

 44 views June 1, 2018 admin 0

FIELDNAME - Display a field name

 111 views June 1, 2018 admin 0

FILLDOWNSTR - Fill down empty values

 84 views June 1, 2018 admin 0

FOLDERSEARCH - Search path for file

 174 views June 1, 2018 admin 1

GETNTHPOPULATEDPARAM - Get nth non-empty parameter

 59 views June 1, 2018 admin 0

HTMLCOLUMNCOUNT - Calculate columns in HTML table

 36 views June 1, 2018 admin 0

HTMLENTITYDECODE - Decode strings containing HTML

 59 views June 1, 2018 admin 0

HTMLROWCOUNT - Calculate rows in HTML table

 55 views June 1, 2018 admin 0

LOADFILE - Load a Unicode encoded file

 51 views June 1, 2018 admin 0

LOOKUP - Select matching value from another field

 150 views June 1, 2018 admin 0

PDFCROPTO - Set PDF crop option

 141 views June 1, 2018 admin 0

PDFIMPORTPAGE - Set page of PDF to import

 219 views June 1, 2018 admin 0

RECORDTIMESTAMP - Display record timestamp

 39 views June 1, 2018 admin 0

SQL - Execute an SQL statement

 117 views June 1, 2018 admin 1

PDF

PDFCROPTO - Set PDF crop option

 141 views June 1, 2018 admin 0

PDFIMPORTPAGE - Set page of PDF to import

 219 views June 1, 2018 admin 0

String manipulation

BASE64DECODE - Decode text from Base 64

 72 views June 1, 2018 admin 0

BASE64ENCODE - Encode text as Base 64

 78 views June 1, 2018 admin 0

CHAR - Convert number to character

 48 views June 1, 2018 admin 0

CONCAT - Concatenate (join) separate strings

 346 views June 1, 2018 admin 0

CONTAINSANY - Test if any strings are contained

 179 views June 1, 2018 admin 0

COUNTOF - Count string instances

 104 views June 1, 2018 admin 0

DISTINCTLIST - Create unique list of values

 284 views June 1, 2018 admin 1

FIELDSTR - Display contents of field

 323 views June 1, 2018 admin 0

FIELDVAL - Display value of field

 165 views June 1, 2018 admin 0

FORMATASTABLE - Format list as table

 86 views June 1, 2018 admin 0

FORMATSTRBOOST - Format string using Boost

 79 views June 1, 2018 admin 0

HTMLCLEAN - Clean raw HTML using HTML5 parsing

 108 views June 1, 2018 admin 0

LEFTSTR - Select characters from left side of field

 115 views June 1, 2018 admin 0

LOOKUP - Select matching value from another field

 150 views June 1, 2018 admin 0

LOWER - Converts field contents to lower case

 93 views June 1, 2018 admin 0

PARTSTR - Extract part of delimited list

 307 views June 1, 2018 admin 1

REMOVEBLANKLINES - Remove blank lines from string

 93 views June 1, 2018 admin 0

REPLACE - Search for and replace text

 85 views June 1, 2018 admin 0

STRIPWHITESPACE - Remove white space from string

 148 views June 1, 2018 admin 0

SUBSTR - Select string of characters in a field

 132 views June 1, 2018 admin 0

TITLECASE - Convert field contents to title case

 138 views June 1, 2018 admin 0

TRUNCATESTR - Remove last N characters from string

 69 views June 1, 2018 admin 0

UNIQUESTR - Return unique entries in a given string

 53 views June 1, 2018 admin 0

UPPER - Convert field contents to upper case

 129 views June 1, 2018 admin 0

URLDECODE - URL-decode a given string

 46 views June 1, 2018 admin 0

URLENCODE - URL encode a given string

 61 views June 1, 2018 admin 0

URLSTR - Retrieve a string from a URL

 258 views June 1, 2018 admin 1

WORDWRAP - Word wrap a string to specified length

 59 views June 1, 2018 admin 0

XML

APPLYXSLT - Apply XSLT transformation

 185 views June 1, 2018 admin 0

EVALUATEXPATH - Evaluate an XPath expression

 175 views June 1, 2018 admin 0

SQL - Execute an SQL statement

 117 views June 1, 2018 admin 1