Group Location
Explore Plans
Mobile menu Close menu
JotformJotform

History of submissions

This query returns a list of new form submissions.

About this query

Triggers, queries, and actions are the building blocks of Applets. Triggers tell an Applet to start, queries ask a question, and actions are its end result.

Developer info

Description
API endpoint slug
jotform.history_of_submissions
Runtime method
performQuery("jotform.history_of_submissions")

Query fields

Form ID Dropdown list

Label
Form
Helper text
Slug
form_id
Required
true
Can have default value
false

Question filter Text input > Other

Label
Question Filter
Helper text
Slug
question_filter
Required
true
Can have default value
true

Ingredients

Ip

Slug
ip
Filter code
Jotform.historyOfSubmissions.IP
Type
String
Example
192.168.0.100

Form title

Slug
form_title
Filter code
Jotform.historyOfSubmissions.FormTitle
Type
String
Example
My Contact Form

Submission date time

Slug
submission_date_time
Filter code
Jotform.historyOfSubmissions.SubmissionDateTime
Type
Date with time (ISO8601)
Example
2020-07-08T04:17:06.000+05:00

Total submissions

Slug
total_submissions
Filter code
Jotform.historyOfSubmissions.TotalSubmissions
Type
String
Example
8

Form ID

Slug
form_id
Filter code
Jotform.historyOfSubmissions.FormID
Type
String
Example
1234567890

Submission ID

Slug
submission_id
Filter code
Jotform.historyOfSubmissions.SubmissionID
Type
String
Example
850507727987654321

Rich text data

Slug
rich_text_data
Filter code
Jotform.historyOfSubmissions.RichTextData
Type
String
Example
<table><tr><td>E-mail</td>johndoe@mail.com<td></td></tr></table>

Spreadsheet data

Slug
spreadsheet_data
Filter code
Jotform.historyOfSubmissions.SpreadsheetData
Type
String
Example
[]

Filtered rich text data

Slug
filtered_rich_text_data
Filter code
Jotform.historyOfSubmissions.FilteredRichTextData
Type
String
Example
<table><tr><td>E-mail</td>johndoe@mail.com<td></td></tr></table>

Filtered spreadsheet data

Slug
filtered_spreadsheet_data
Filter code
Jotform.historyOfSubmissions.FilteredSpreadsheetData
Type
String
Example
[]

File URL

Slug
file_url
Filter code
Jotform.historyOfSubmissions.FileUrl
Type
String
Example
http://www.jotform.com/uploads/user/1234567890/9876543210/images.zip