Jotform Data

Description

Adds interfaces and custom functions that output a 2D array of data from JotForm. Return user, form, submission, report & folder data. This add-on has no affiliation with JotForm Inc.​​

Set Up

  1. Navigate to jotform.com/myaccount/api.
  2. Press “Create a new key” or use an existing one.
  3. Copy the key into the set up dialog. For full instructions, see Jotform’s website.

Import Sidebar

The sidebar can be used to import data from Jotform manually, which is useful if you only need to update it periodically. Go to Jotform Data > Import to open the sidebar, from here you can select the data you want to import. Details of each parameter are listed under ‘Custom Functions’ below. IMAGE

Scheduling

Available through the import sidebar, scheduling allows you to import data from Jotform on a regular, recurring basis. Settings are taken from the import sidebar and run at the specified frequency. You can manually prompt a check of all schedules, as well as forcing them all to import regardless of when they were last run. IMAGE

Custom Functions

Basic

Enter ‘=JOTFORM()’ in any cell. The parameters for this function are listed below:

Advanced

Enter ‘=JOTFORM_ADV()’ in any cell. The parameters for this function are listed below:

Output

Both functions output a 2D array of information from JotForm with headers on row one. This can take up a lot of columns, so consider transposing the output. Results are stored in the document to improve performance and minimise the amount of requests made to JotForm, however this is not always possible with large responses.

Permissions

Here’s what Jotform Data does with each of the permissions it requires:

Uh-oh, Something Broke!

Contact me, giving as much detail as you can.

Changelog​