Include edit_link in data passed to api

  • RightOfConquest
    Asked on February 25, 2016 at 7: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.

  • beril JotForm UI Developer
    Replied on February 26, 2016 at 2: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.

  • Boris
    Replied 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:

    Include edit link in data passed to api Image 1 Screenshot 20

    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.

  • Kevin Support Team Lead
    Replied on February 26, 2016 at 4:38 PM

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

     

  • RightOfConquest
    Replied on February 29, 2016 at 1: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?

  • Kevin Support Team Lead
    Replied on February 29, 2016 at 3: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.