data in form field

  • Profile Image
    dave 
    Asked on June 17, 2020 at 08:42 PM




    So if we can’t us the MySQL database to populate a form, can we use an excel sheet to populate and then retrieve the data and place it into the form?   My goal is to populate a form, save the data, and then go back and get the data once stored, and repopulate the form.  If we cant use the Excel sheet  to do both operations (Populate/SAVE.. and then….. Retrieve/Repopulate) ?




    What are other solutions are possible to do this?




    From: Jotform <noreply@jotform.com>
    Sent: Wednesday, June 17, 2020 5:17 PM
    To: Tampa Bay Bobcat <sales@tampabaybobcat.com>
    Subject: Re: Populate form with data.




    A new response has been received:



    Answered by Jimmy_D


    Hi there!


    Thanks for contacting us.


    1.  If I create a form and then populate the PDF as well as store it into a MySQL database, can the User come back and view the database, select a record in the database, and then have your application populate the form with the selected record data?


    You can send submitted to your database using PHP, unfortunately, not the other way around. 


    Guide.- How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP


    We do have a Spreadsheet to form widget that allows you to populate a form with fields with data from an excel document by entering a Unique Code. 


     


    Guide.- How-to-Use-the-Spreadsheet-to-Form-Widget


    You may use custom script to pass the data pulled from the database to the form using URL parameters.  


     


    Guide.- Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters


    2.  Can I integrate login credentials to access the data?


     


    This is possible using custom code but not as a built-in feature. You may need to hire a Developer to implement the feature. 


    3.  Can I charge $$ to the User as a subscription service?


    Yes, using one of our Payment Gateway applications. 


    Here is a guide.- Mastering-Payment-Form-Integrations-with-JotForm


    I hope this was helpful. Let us know should you have more questions. 


  • Profile Image
    gerardw
    Answered on June 17, 2020 at 10:56 PM

    Hi,

    can we use an excel sheet to populate and then retrieve the data and place it into the form?

    Yes, as already mentioned by my colleague Jimmy above, you can use a Spreadsheet to form widget on the form to prepopulate data in the form fields from an excel sheet.

    Here is a related guide which explains how you can setup the widget on the form: How-to-Use-the-Spreadsheet-to-Form-Widget 

    Do test this and let us know if it helps.