ConnectIT 365
Functions
Functions
In this topic all available functions are explained. With a function it is possible to add extra data in the export or import. It is also possible to format or change the date with a function.
For export functions, in some cases it can be usefull to provide an output format. For more information on formatting, please check the Microsoft Documentation.
Int he list below all the available functions are described:
- Frequently used
- Function ABS
- Function ADD
- Function ADDLINK
- Function ADDNOTE
- Function ADDSPACEBEFOREUPPER
- Function AZUREFUNCTION
- Function CALCDATE
- Function CLRTEMPVAL
- Function COMPANYNAME
- Function CONCAT
- Function CONTAINS
- Function CONVERTSTR
- Function CONVINTOEXT (export only)
- Function CONVEXTTOINT (import only)
- Function COPYSTR
- Function CREATEGUID
- Function DATE2DMY
- Function DATE2DWY
- Function DATETIME
- Function DECRYPTTEXT
- Function DELCHR
- Function DELSTR
- Function DELTEMPVAL
- Function DIVIDE
- Function DMY2DATE
- Function DT2DATE
- Function DWY2DATE
- Function DT2TIME
- Function ENCRYPTTEXT
- Function ERRORIF
- Function ERRORIFNOT
- Function EXECUTE TASK (import only)
- Function FORMAT
- Function FORMATDECIMAL (import only)
- Function FORMATDTZ
- Function FROMBASE64
- Function GENERATEHASH
- Function GENERATEHASHBASE64
- Function GETAUTHTOKEN
- Function GETCOUNTRYNAME (export only)
- Function GETCURRENTVALUE (import only)
- Function GETEXPORTSSTEMIDS
- Function GETFIELDVALUE
- Function GETFIELDVALUE2
- Function GETIMPORTENTRYBODY
- Function GETIMPORTFILENAME
- Function GETNEXTLINENO
- Function GETTEMPVAL
- Function GLOBALLANGUAGE
- Function INCSTR
- Function INSSTR
- Function LINENO
- Function LOWERCASE
- Function MULTIPLY
- Function NOSERIES
- Function PADSTR
- Function PARSEDATETIME
- Function POWER
- Function RANDOM
- Function RANDOMIZE
- Function REGEX
- Function REST / AZUREFUNCTION
- Function ROUND
- Function ROUNDDATETIME
- Function SERIALNUMBER
- Function SETTEMPVAL
- Function SLEEP
- Function SPLITDESC
- Function STRLEN
- Function STRPOS
- Function SUBSTRACT
- Function TASK (import only)
- Function TIME
- Function TODAY
- Function TRIGGERIMP
- Function UPPERCASE
- Function URLVALUE
- Function USERID
- Function USECURRENT
- Function USEFORMER
- Function USEDEFAULT
- Function WORKDATE
- Function GETURLPARAMETER
Back to: ConnectIT 365 manual home
, multiple selections available,
IDYN 2024