Can I embed an HTML report from jotform and pull the data from one spec

  • Profile Image
    AZDBAdesze
    Asked on October 21, 2018 at 12:29 PM

    Can I embed an HTML report from jotform and pull the data from one specific column into a dropbox field that is on my new form which the user is able to choose from that particulater list?



    This is a re-post of a comment on Prepopulating Fields to Your Jotform via URL Parameters

  • Profile Image
    AshtonP
    Answered on October 21, 2018 at 01:37 PM

    I am not sure I understood your question. Could you please provide us more details on your requirements? We would be glad to assist you further. 

  • Profile Image
    AZDBAdesze
    Answered on October 22, 2018 at 02:05 AM

    Ok, I have a form that requires a user to provide information and that information I create an HTML report. From the HTML report, I would like to use one of the columns information in another form as a dropdown box so that a user can choose from that list of information. Is that possible? And can you show me how? 

  • Profile Image
    AshtonP
    Answered on October 22, 2018 at 08:12 AM

    It is now possible to populate values from the HTML report into a form. It is, however, possible to populate field values from a spreadsheet to the form. It requires the Spreadsheet to Form widget

    Useful articleHow-to-Use-the-Spreadsheet-to-Form-Widget 

    This mechanism requires a call to a Database. That is not possible to accomplish with Jotform. My recommendation would be to download the full source code of the form and apply some PHP/MySQL programming to meet this requirement. 

    Useful articles -

    http://www.jotform.com/help/237-PHP-Forms-Explained 

    http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

  • Profile Image
    AZDBAdesze
    Answered on October 26, 2018 at 12:31 AM

    Ok you gave me a spreadsheet to form widget and I need a way to get data from a HTML Table Listing Report to a form

    Is that possible?


  • Profile Image
    ashwin_d
    Answered on October 26, 2018 at 04:06 AM

    Unfortunately no, it is not possible to populate form fields with the value from HTML Table listing report. 

    Please take a look at our "Spreadsheet to Form" widget and see if that fits into your requirement.