Advanced Formula: Array and Record Functions

This guide covers the Advanced Formula syntax and usage of array and record functions for handing items in an array and retrieving record information in Jotform Tables.

The following is a list of array and record functions available in Jotform Tables:

See also:

• Operators
• Text Functions
• Logical Functions
• Numeric Functions
• Date Functions

ARRAYCOMPACT

Combines arguments, excluding empty strings and null or zero values, into a single string. The ARRAYCOMPACT function will include arguments containing one or more white spaces.

Syntax:

ARRAYCOMPACT(value1[,value2,...])

Examples:

• =ARRAYCOMPACT(0,1,2,3,"0") will return 1230.
• =ARRAYCOMPACT("A",0,"B",FALSE(),"C",BLANK(),"D",,"E","","F") will return ABCDEF.
• =ARRAYCOMPACT("A","0","B",TRUE(),"C"," ","D",ERROR()) will return A0B1C D#ERROR!.

ARRAYJOIN

Joins arguments with a delimiter. Unlike TEXTJOIN, ARRAYJOIN always includes arguments with empty values.

Syntax:

ARRAYJOIN(value1[,value2,...],delimeter)

Examples:

• =ARRAYJOIN("merry","go","round","_") will return merry_go_round.
• =ARRAYJOIN("hello","world",BLANK(),"+") will return hello+world+.
• =ARRAYJOIN("",0,FALSE(),,"-") will return -0-0-.

ARRAYUNIQUE

Returns the right-most unique item from the list of arguments.

Syntax:

ARRAYUNIQUE(value1[,value2,...])

Examples:

• =ARRAYUNIQUE(3,2,1,2,3) will return 1.
• =ARRAYUNIQUE(3,2,1,2,3,4,2) will return 4.
• =ARRAYUNIQUE("A","A","B","B","C","C") will return C.

CREATED_TIME

Returns the entry’s creation date and time. The CREATED_TIME function has no arguments.

Syntax:

CREATED_TIME()

Examples:

• =CREATED_TIME() will return the entry’s creation date and time, like 2022-07-28 04:15:05.
• =TEXT(CREATED_TIME(),"MM/DD/YYYY") will return the entry’s creation date in MM/DD/YYYY format, like 07/28/2022.

RECORD_ID

Returns the entry’s submission ID. The RECORD_ID function has no arguments.

Syntax:

RECORD_ID()

For example, =RECORD_ID() will return the entry’s submission ID, like 5348053057414712879.