Formstack

Formstack is a workplace productivity platform providing no-coding online forms, documents, and signatures. This connector works with the Forms features of Formstack. Use the Formstack Documents connector for working with the Forms feature.

Data integration: Skyvia supports importing data to and from Formstack, exporting Formstack data to CSV files, replicating Formstack data to relational databases, and synchronizing Formstack data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support Formstack.

Query: Skyvia Query supports Formstack.

Establishing Connection

Creating Connection

To connect to Formstack, perform the following steps:

  1. In the connection editor, click Sign In with Formstack.

    Connection Editor

  2. Enter your Formstack credentials.

    Formstack login

  3. Click Authorise to approve access request.

    Granting access to Formstack

Additional Connection Parameters

Suppress Extended Requests

For the Forms and PartialSubmissions objects Formstack API returns only a part of the fields when querying multiple records. In order to query values of additional fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such object. However, this can decrease performance and significantly increase the number of API calls used.

The list of additional fields is the following:

Object Field
Forms DB, Deleted, Folder, Language, Viewkey, SubmissionsToday, Encrypted, ThumbnailUrl, SubmitButtonTitle, Inactive, NumColumns, ProgressMeter, ShouldDisplayOneQuestionAtATime, CanAccess1qFeature, IsWorkflowForm, IsWorkflowPublished, Javascript, Html, Fields, HasApprovers, EditUrl, Permissions, CanEdit
PartialSubmissions Data

To reduce the number of API calls, you can select the Suppress Extended Requests checkbox.

Connector Specifics

Object Peculiarities

Fields

To successfully import data to the Fields object, you must map the required FormId and Type fields and additional fields. Additional fields needed for mapping are determined by the Type value. You can refer to Formstack documentation to find out the list of fields needed for mapping for each field type.

SCIM API

Skyvia does not support Formstack SCIM API objects.

Incremental Replication and Synchronization

Skyvia supports Replication with Incremental Updates for the following objects: Forms, Portals, Smartlists, and SmartlistOptions.

Skyvia supports Synchronization for Forms, Smartlists, and SmartlistOptions objects.

DML Operations Support

Operation Object
INSERT, UPDATE, DELETE ConfirmationEmails, Fields, Folders, Forms, NotificationEmails, SmartlistOptions, Smartlists, Subfolders, Submissions, Webhooks
UPDATE, DELETE Portals
DELETE PartialSubmissions

Stored Procedures

Part of the Formstack functionality is implemented in Skyvia as stored procedures:

  • call CopyPortal(:portal_id) — copies the existing form portal.

  • call InviteUserForPortal(:portal_id, :emails) — invites users to a form portal.

  • call ModifyPortalParticipantName(:portal_id, :name) — modifies name of the portal participant.

  • call AddFormToSpecifiedPortal(:portal_id, :name, :formId, :deadline, :description, :notifyUsers) — adds the existing form to a portal.
    Required parameters are :portal_id, :name, :formId.

  • call ModifySpecifiedPortalForm(:portal_id, :portalFormId, :name, :formId, :deadline, :description, :notifyUsers)— modifies the form in the portal. Required parameters are :portal_id, :portalFormId, :name, :formId.

  • call DeletePortalFromForm(:portal_id, :portalFormId) — removes form from a portal.

Supported Actions

Skyvia supports all the common actions for Formstack.