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.
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...Asked by sriram280789 on December 03, 2016 at 10:59 AM
I have a different 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?
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 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?
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?
Unfortunately, it's not possible. A workaround would be to utilize the Edit Submission Feature.
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.