Advanced Formula: Array and Record Functions

July 30, 2022

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

Here’s the combined list of array and record functions you can use in Jotform Tables:

Function Description
ARRAYCOMPACT Combines array items, excluding empty strings and null values.
ARRAYJOIN Join the array of items into a string with a separator.
ARRAYUNIQUE Returns only unique items in the array.
CREATED_TIME Returns the creation time of the current record.
RECORD_ID Returns the ID of the current record.

See also:

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.

Was this guide helpful?
Contact Support:

Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comment:

Podo CommentBe the first to comment.