-
breadformAsked 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_TReplied 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.