I have created a user contact form through JOT and integrated it to a google spreadsheet. Now I want a reverse of this process such that...

  • Profile Image
    sriram280789
    Asked on December 03, 2016 at 10:59 AM

    I have a different contact form at the receiving end where it has to display the data stored from the data capturing spreadsheet as an html table (keeping the database only for storage purpose). Is this possible?

  • Profile Image
    liyam
    Answered on December 03, 2016 at 11:23 AM

    Hello,

    Unfortunately, this cannot be done unless you use the Import Excel/CSV app. So if what you have in mind is using a Google Spreadsheet for input and to which shall reflect to the submissions page or report of your form, this is not possible.

    However, if I'm misunderstanding your concern, please let us know.

    Thanks.

  • Profile Image
    sriram280789
    Answered on December 04, 2016 at 10:09 AM

    Thanks for the reply. Yes you got me right. My requirement is, form 1 used for entry submissions, this goes to a spreadsheet which acts as the database. For the end user, it is a HTML table which shows the same data from the database. The table would contain a check box for each entry and two action buttons say for example, one for accept and the other for reject. When an entry is checked and accepted, this action will have to get captured in the database as "Accepted" as the status (in an additional column not connected with form 1). Similaly the reject action will add status as "Rejected". The default value of the status column shall be blank.

    Secondly, the entries which are accepted or rejected will be removed from the table and only the entries with action pending will be displayed. However, they will stay back in the database with their updated status either as accepted or rejected.

    For the reverse sync part, I have tried to publish the Google spreadsheet as a we page and it worked. But I am not able to make any actions to it which connects back to the spreadsheet. In the import excel option you have mentioned, can I give the URL of my database (not necessarily a Google spreadsheet) instead of uploading a file itself?

     

     

  • Profile Image
    sriram280789
    Answered on December 04, 2016 at 10:13 AM

    Not sure if I can ask this way, if what I require is out of bounds for a JOT user, can you advise the way this can be accomplished?

  • Profile Image
    Welvin
    Answered on December 04, 2016 at 12:03 PM

    Unfortunately, it's not possible. A workaround would be to utilize the Edit Submission Feature. 

    https://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date

    Add the Edit URL in your HTML table. Example: https://www.jotform.com/grid/63384952071055.

    Unfortunately, with this method, you cannot remove the submissions on the table based on the approval. Your identifier would be the Approval section in the table. You can sort them - assuming that you are using the Grid Listing Report or HTML Table Listing.

    All the submissions will be added back the integrated spreadsheet. You don't need to push them manually, the form will do it automatically.

     

    As for the import process, you need to upload the CSV or XLS file. That's the only way you can make the import app to work.