Embiro BI

Documentation › Connecting data

Jotform

Chart Jotform form submissions live in Embiro BI with your Jotform API key, one dataset per form.

The Jotform connection reads your forms' submissions directly from Jotform. Each form becomes a table, and each question becomes a column named after the question's label. A new submission shows up in charts at the next refresh.

Who can do this: Super Admin, Admin and Analysts.

1. Get a Jotform API key

  1. Sign in to Jotform and open My Account → API.
  2. Click Create New Key.
  3. Set its permission to Read Access. Embiro BI never needs to change your forms.
  4. Copy the key.

2. Create the connection

  1. Click + (top right) → Data → Connect database.
  2. Click Connect this database with a SQLAlchemy URI string instead.
  3. Enter the address below, with your key after the colon:

    text jotform://:YOUR_API_KEY@/

    Is your Jotform account an EU account (your forms open on eu.jotform.com)? Then add the EU API host:

    text jotform://:YOUR_API_KEY@eu-api.jotform.com/

  4. Give it a Display name, such as Jotform, and click Connect, then Finish.

The key is stored encrypted, like a database password.

3. Create a dataset for a form

  1. Open Datasets → + Dataset and choose the Jotform connection.
  2. Every form in the account is listed by its title.
  3. Pick a form and click Create dataset and create chart.

What the columns look like

Column Contents
submission_id Jotform's ID of the submission
created_at When it was submitted (2026-03-14 09:21:05)
status ACTIVE, or DELETED for deleted submissions
ip The submitter's IP address
one column per question The answer. The question "Amount Requested (UGX)" becomes amount_requested_ugx

Answers arrive as text. To add up or average a number question, cast it in the metric or a calculated column:

SUM(CAST(amount_requested_ugx AS REAL))

Mark created_at as Is temporal in the dataset's columns so time charts and time filters can use it. See Metrics and calculated columns.

Tips

  • Filter out deleted submissions with status = 'ACTIVE', in the chart's filters or as a dataset filter.
  • Renaming a question in Jotform renames its column. Charts using the old name then need updating.
  • Questions with several answers (checkboxes, multi-select) arrive as one text value with the choices separated.
  • One connection covers every form in the account and counts as one data connection.

Something unclear or missing? Tell us and we'll improve this page.