JotForm API: Ability to update form options and query submissions on the background.

  • breadform
    Asked on May 3, 2018 at 5:33 PM

    Hello!

    We have enjoyed using JotForm for a few years now and are wondering if we can add advanced capabilities to our forms.  For instance, 

    Could we push a file via sFTP to automatically update the background data presented on the forms? This data would be used to build nested dropdowns for cafe, list of users in that cafe, and then keep the associated user’s User ID in the background reporting and associated with the entered form data Could the form then send us a nightly feed via sFTP of all of the submissions that day with the userID, form name or ID, data of completion, and all of the other data collected on the form?

    There's more we want to do but having answers to these questions would be a good place to start.



  • Vanessa_T
    Replied on May 3, 2018 at 6:39 PM

    Hello,

    You may want to check out JotForm API for these advanced features. Since it is based on REST, you could implement it in any of your chosen programming language. You can also find great use case samples in there.


    Could we push a file via sFTP to automatically update the background data presented on the forms? This data would be used to build nested dropdowns for cafe, list of users in that cafe, and then keep the associated user’s User ID in the background reporting and associated with the entered form data

    Instead of SFTP though, to update your question options, you will have to create a script of your chosen language to loop thru all your data and call https://api.jotform.com/form/{formID}/question/{questionID}?apiKey={apiKey}

    Add or edit a single question properties: https://api.jotform.com/docs/#post-form-id-question-id


    Could the form then send us a nightly feed via sFTP of all of the submissions that day with the userID, form name or ID, data of completion, and all of the other data collected on the form?

    Same as above, create a script but this time call https://api.jotform.com/form/{formID}/submissions?apiKey={apiKey}

    Get Form Submissions: https://api.jotform.com/docs/#form-id-submissions


    Let us know if you need assistance on starting your first JotForm API calls and we'll be glad to help.