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:
<div class="wp-block-table is-style-stripes">
<table>
<thead>
<tr>
<th class="has-text-align-left" data-align="left" style="min-width: 160px;">Function</th>
<th class="has-text-align-left" data-align="left">Description</th>
</tr>
</thead>
<tbody>
<tr>
<td class="has-text-align-left" data-align="left"><a href="#arraycompact">ARRAYCOMPACT</a></td>
<td class="has-text-align-left" data-align="left">Combines array items, excluding empty strings and null values.</td>
</tr>
<tr>
<td class="has-text-align-left" data-align="left"><a href="#arrayjoin">ARRAYJOIN</a></td>
<td class="has-text-align-left" data-align="left">Join the array of items into a string with a separator.</td>
</tr>
<tr>
<td class="has-text-align-left" data-align="left"><a href="#arrayunique">ARRAYUNIQUE</a></td>
<td class="has-text-align-left" data-align="left">Returns only unique items in the array.</td>
</tr>
<tr>
<td class="has-text-align-left" data-align="left"><a href="#created_time">CREATED_TIME</a></td>
<td class="has-text-align-left" data-align="left">Returns the creation time of the current record.</td>
</tr>
<tr>
<td class="has-text-align-left" data-align="left"><a href="#record_id">RECORD_ID</a></td>
<td class="has-text-align-left" data-align="left">Returns the ID of the current record.</td>
</tr>
</tbody>
</table>
</div>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.
Send Comment: