Is there any way to create a new form using form submission data?

  • jon709
    Asked on May 26, 2022 at 9:54 AM
    Is there a way to insert a button in the table that would copy certain fields to a new form. The use case is if a physician is reviewing a note on a patient from yesterday, can they populate a new form with that patient's basic info?
  • Ravi JotForm Support
    Replied on May 26, 2022 at 11:43 AM

    Hello Jonathan, 

    Thanks for reaching out to Jotform Support. Yes, it is possible to prepopulate the fields of a new form with another form table. Let me show you how to do that:

    • Create 2 forms, Open the second form. 
    • Click on the Publish on the Orange navigation bar at the top of the page.
    • In the menu that opens on the left side of the page, click on Prefills.
    • Select the Tables Prefill option
    • Select the table from which table you want to fill out the current form.
    • Once the table is selected, it will give options to map the fields in both the forms. Note that the same fields will get matched automatically.
    • Once mapping is complete, click on the Save settings button.
    • Click on Add New prefill button to create a new prefill for your form. It will load the table and select the fields from which you want to create a prefill of your second form.
    • After selecting the field, click on the create prefill button on the top right corner of the screen.

    nnA9emjAZztDGATtVbbpMvvMxLqqmX74qFno3Yeo Screenshot 10

    We also have a guide about How to Prepopulate Form Fields With Data From Other Tables with Table Prefill? that you can check out.

    Let us know if there’s anything else we can help you with.



  • jon709
    Replied on May 26, 2022 at 4:24 PM

    Ravi,

    Thanks for this response. The trick is I need this action to be user-initiated based on a field from a table. I read through this guide: https://www.jotform.com/answers/3488742-generate-prefill-urls-in-tables-instead-of-going-to-publish-tab-in-builder.

    This functionality is really close to what I need with a couple of exceptions:

    1. This function provides a SEND button at the end of every row. Instead of having it in the table, I need that functionality at the end of the row in a report (Where users can't manipulate the data).
    2. Instead of sending an e-mail, I need it to open a new form that is pre-populated with the data from the row on the table/report.


  • Sheena JotForm Support
    Replied on May 26, 2022 at 6:54 PM

    Hi jon709,

    Thanks for reaching out to Jotform Support. I checked your requirements and I can see that this can be achievable with our Table's Prefill. Please note that when using the Jotform's Table Prefill, you do have the option to set the permission to Read-Only.

    1653604886 629002169e136  Screenshot 10

    Instead of sending an email, you can also copy the URL instead and then paste it on a different tab in order to see the prepopulated form. Here's how:

    1653605552 629004b0a4df7  Screenshot 21

    If you think this would not work for you, we can open a feature-request for this instead.

    We look forward to your response.

  • jon709
    Replied on June 2, 2022 at 1:06 PM

    Hi Sheena. Sorry for the long delay on response. This probably won't be an effective solution. What I almost need is the ability to insert a button into a report that allows me to create a new entry using any row on the report. So for example, if I wanted to create a new pre-filled form using row 2 of a report, I click the button and it repopulates a new form using the fields I select. Does that make sense?

  • Afzal JotForm Support
    Replied on June 2, 2022 at 3:35 PM

    Hi Jonathan,

    Thanks for getting back to us. As you have mentioned earlier and I can also see that the solution provided by my colleague on this link perfectly fulfills your requirements if you are looking to share a single row in Jotform tables however it seems you are looking to share a single slide of the Jotform report which is currently not possible but you can share the report using the Publish button:

    1654197998 62990eee9eaf9  Screenshot 10

    Please provide us with more information, we are happy to help you.

    We look forward to assisting you further.