Skip to main content

Formstack

Ajaykumar Guttlapalli
  • Updated

Overview

Formstack is a cloud-based solution that helps to automate processes of creating digital forms and collecting data for surveys, leads and registrations. This integration uses the Formstack API to copy data about your forms and submissions into DWA for reporting and analysis. The data in the schema is updated incrementally every day.

Setup

  • TEAM: Notify Two Circles of your intention to enable this integration

  • Success: Send TEAM user guide and instructions on how to set up the data access for Two Circles
    Client ID
    Client secret

    Redirect URL

    Access token

  • Success: Save credentials in Two Circles Secret, create and prioritize a work item in the DWA backlog
  • DWA Developer: Setup integration and confirm data is loaded correctly
  • Two Circles: Notify the TEAM the integration has been configured, provide the user guide and a walk-through of the integration

ERD and data dictionary

(This information is provided on a best-effort basis without guarantees. For clarity, most column names are omitted from this ERD.)

 
 

Table Descriptions

Note: Each table is updated incrementally every day except where otherwise specified.

fields

This table provides information on all the 'fields' (specific input element) that collect data for your forms. Every data a full data load is done on the forms table. Key fields includes id, Form_id, description, name, type, required, uniq, readonly, minlength, maxlength etc.,

folders

This table provides information on all your specified folders. Key fields includes id, name, parent and permissions.

forms

This table provides information on all the forms that exist in your folders. Key fields included are id, created, deleted, folder, name, submissions, submissions_unread, updated, views, submissions_today, last_submission_id, last_submission_time, permissions, can_edit etc.,

submissions

This table provides information on all the submissions via a form. Key fields includes id, timestamp, user_agent, remote_addr, paymment_status, form, latitude, longitude and read.

submission_details

This table provides details of each submission for a form. Key fields includes id, timestamp, user_agent, remote_addr, paymment_status, form, latitude, longitude, field and value.

 

Example queries

The below query will give total number of submissions for a given form.

select f.name as form_name,
count(f.id) as total_submissions
from formstack.forms f
left join formstack.submissions s
on f.id = s.form_id
group by f.name;

 

The below query will show the submitted values for each field with in a form.

select f.name as form_name,
       fi.name as field_name,
       sd.value
       from formstack.fields fi
       join formstack.submission_details sd
       on fi.form_id = sd.form
       join formstack.forms f
       on sd.form = f.id;