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.
How can I display and format selected form data on a Website?Asked by donbrown on November 01, 2015 at 11:33 PM
I am trying to take a set of selected Jotform data fields and display this data on a webpage in a desired format.
I have tried Jotform Submission Views http://apps.jotform.com/app/submission_view and found it to not work as expected.
Then I tried the Google Spreadsheet Integration http://apps.jotform.com/app/google_spreadsheets_integration This worked, except the spreadsheet view offers very limited page layout options - only a spreadsheet style view.
Then, I tried Google Drive Integration http://apps.jotform.com/app/google_drive_integration but don't understand how to get the data into a Google Document. Is there a user guide?
What I am trying to do is to present my Jotform data on a Webpage (or a link which can be called from a Webpage), formatted as desired - to have format control of each of the selected text fields (font selection, font size, font weight, text color, as close as WYSIWYG as possible for layout of data on page). Also, if possible, display the photograph (not just the link) captured in the form.
How can I do this? What are my options?
I know one option is to export the data into an SQL database, but exporting, displaying and formatting these SQL data fields is beyond my skill level.
Thanks for your help.
Unfortunately we do not have such feature where you can directly embed the submission data of your form in your webpage but with a little workaround, it is possible to achieve your requirement.
You can generate report for your form's submission data and embed it in your webpage. Though you will not be able to format the look and feel but it is possible to choose which fields you want to display (while creating report). Please take a look at the following thread where I have explained step by step on how to achieve this: http://www.jotform.com/answers/293307
Hope this helps.
Do get back to us if you have any questions.
Thanks for your reply, but as you say, this HTML Table Listing process does not allow any text layout or text formatting.
Is there a "user guide" for Jotform Submission Views? In theory, this app looks like it can do what I want, but the short video is so cryptic, that it is difficult to follow.
What about the Google Drive Integration? How can I output a report to a Google Doc - which can be formatted and then the Google Doc link could be added to a Webpage?
One other option is to create a CSV Table output, and do a "merge" into a Word document, then copy that Word document to a Google Doc on a Google Drive, then link that Google Doc to a Webpage. This is rather convoluted and every time the data changes, you need to go thru this process.
Are there any other options?
I think the submission Views app would do the majority of what you would like to do. But since this app gives you the options to change the formats, you will have to do the styles manually. Unfortunately, we do not have a text guide. But thanks for bringing this up. I will try to create this for everyone.
Now, I would like to know how you would like to display the submissions? Perhaps, you can send us a draft design so we can make a test then give it to you?
Unfortunately, I'm not sure how to manipulate the data inside Google Spreadsheet or Drive to create a web format or display.