What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Include edit_link in data passed to api

    Asked by roiafblackgoat on February 25, 2016 at 07:49 PM

    I'm passing my jotform data to a SQL database and its working very well - except for one small thing. I'd like to save the edit_link that is sent with the submission email in the database so I can use it as a token to allow editing of the form on our website (the form is in an IFrame).  

    For instance, the edit_link I just received on a fake entry is: https://www.jotform.com/edit/332255897514606491 . Does the number correspond to anything else on the form I can use to figure it out in my database code? I'd hoped that I could pass edit_link itself as a hidden field, but I don't see a way to add it.

    I'd create it myself, but the number doesn't seem to correspond to the form ID.  Is there a way to figure out the ID so I can create the link programatically on my site?

    Jotform is /so/ close to perfect for our uses.  The interface is wonderful and the multi lists are the best thing ever. If we can jump this one hurdle it will be amazing.

    Page URL:
    https://form.jotform.com/52590595608162

    JotForm hidden jump sql
  • Profile Image
    JotForm Support

    Answered by beril on February 26, 2016 at 02:56 AM

    We really appreciate it and we're very excited to hear how beneficial it has been to you! As far as I understand from your thread edit link function doesn't work.

    As far as I know it is possible to update submission even if you use your own database.

    First of all, you can fetch the submission data and prepopulate the HTML form.

    Please, check the guide below for more information:

    http://api.jotform.com/docs/#submission-id

    After that, you can update the submission. You can check how to update the submission at the following link:

    http://api.jotform.com/docs/#post-submission-id

    I hope it helps.

    If you need any question or issues, please do not hesitate contacting us. We will be glad to assist you.

  • Profile Image
    JotForm Support

    Answered by Boris on February 26, 2016 at 12:34 PM

    From what I understood on your above post, you are not actually using our API, but rather forwarding submission data in a manner similar to what is described in How to send Submissions to Your MySQL Database Using PHP. Is this correct?

    In order to generate your Edit Link, all you need is the submission ID.

    We support both sending your submitted data in a POST, as well as regular webhooks.

    Whichever of the above methods you are using, submission ID is passed directly with the rest of your submitted data. As you can see in the guides linked above, submission ID is passed in a variable named submission_id:

    So if you are sending data to your site through POST method or webhooks, you should be able to see submission ID within the data that is sent.

    If I have misunderstood your question, please describe it in a little more detail if possible, and we will be happy to help.

  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 26, 2016 at 04:38 PM

    Sure, let us know how it goes, we will be glad to further assist you.

     

  • Profile Image

    Answered by roiafblackgoat on February 29, 2016 at 01:55 PM

    The corrected spelling and capitalization fixed all my woes.  Thank you very much for your help!

     

    As a suggestion, would you guys consider an "outputs" help file that just gives the very basic info of each output?  I know it sounds self explanatory, but for idiots like me (and there's more of us than you'd expect), it would be very helpful to have accessible from the form design page.

     

    Also, I now have a working model for using Jotform with Dotnetnuke.  It uses a third party API, but it works.  Would it help if I wrote a guide?

  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 29, 2016 at 03:05 PM

    On behalf of my colleagues, you're welcome.

    I think that this is the guide to get the submitted data: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    However, thank you for your suggestion, perhaps there are some things that need to be explained better.

    Also, I now have a working model for using Jotform with Dotnetnuke.  It uses a third party API, but it works.  Would it help if I wrote a guide?

    Are you referring to create a guide about how to use JotForm with DotNetDuke? 

    If so, it could be helpful for other users that are using that software, we could include it in our user guide.