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.
will return 4.=ARRAYUNIQUE(3,2,1,2,3,4,2)
will return C.=ARRAYUNIQUE("A","A","B","B","C","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.
Send Comment: