Is it possible to pull submissions data and put in a dropdown list?

  • mjayme
    Asked on September 4, 2019 at 1:27 AM

    Hi,

    I would like to create a form uploader and have a couple questions around this.

    1) Is it possible to upload someone's file and create a drop down list of names of who has actually submitted their form?

    2) if yes, does it refresh the drop down data and show which employees have submitted forms? 

    So for example. Chloe is the manager using the form as a checklist and to upload camp registration forms. Morty hands in the form and she selects her name and uploads the file. Then Heyhey hands in a form too. 
    Will chloe be able to select Heyhey's name and also see that Morty has already submitted the form?

     

    Thank you :) 

  • Jed_C
    Replied on September 4, 2019 at 1:39 AM

    Is it possible to upload someone's file and create a drop down list of names of who has actually submitted their form? — You mean to say to pull the name field of your submissions and list those in a dropdown, correct?

    You'll be needing some database here. What you need is extract the form's source code https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form and create a MySQL database https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    Let us know if you have any questions or if you need further assistance.