- ThomasMcCannAsked on January 15, 2011 at 10:13 PM
The report facillity for publishing the submissions using Excel on my website (using a link to Jotform) is great and as I would only like genuine submitters to have access ie they have given genuine Email addresses, the password part could be extremely useful (ie I canEmail them the password). I will reconfigure the data received from the submissions (in Excel) on my P.C. and I wonder if there is any way I can get this new Excel file on the internet through Jotform, possibly linking it with the original submissions file or any other way.
- JotForm FounderaytekinAnswered on January 16, 2011 at 12:03 AM
When you edit a report, the link you have already shared will keep working. It will always have the updated version.
So, you should get the URL for report once and bookmark it and use it to get the latest version.
If you change the password, the users who has that URL will be asked the new password. If you change the fields, they will be see the report with new fields.
- ThomasMcCannAnswered on January 16, 2011 at 07:05 PM
I'm sorry I don't think I explained myself very well. If I have a simple survey with one question and 2 answers: yes or no and got 100 submissions, I would like to copy the report to an Excel file on my P.C., get Excel to count and get percentages for yes and no and publish the result on the internet so people could see the results of the survey. Is there a way I can publish this Excel File through Jotform so that it is linked to the original report?
- JotForm FounderaytekinAnswered on January 17, 2011 at 07:33 AM
You can do that with visual report builder. Select your form on My Forms page, click on reports, then "Add New Report". Then select "Visual Report Builder". It will create a report that can show the counts and a chart. You can also include this report in your page.
This report will also update itself in real time. When a new submission comes, the report will be updated.
But to answer your question regarding excel. No, you cannot load a changed excel file back to JotForm.
- ThomasMcCannAnswered on January 18, 2011 at 07:39 PM
I am very interestd in the 'Visual Report Builder' but when I have tried, there seems to be a lot of flashing of the submissions and a loading icon. When I press'Edit Report', I get a menu for Headings, Charts etc but cannot seem to ge any sort of control or get anything useful.
Is there any sort of tutorial or example to use?.
- JotForm FounderaytekinAnswered on January 19, 2011 at 07:29 AM
It could be a browser problem. Can you try a different browser such as Firefox or Google Chrome and see if you can use it then?
Unfortunately, there is no tutorial on visual report builder. It is mostly drag and drop.
I looked at your forms and none of them has any chartable fields. You must have fields such radio buttons, checkboxes, dropdown etc. so that it can create charts from them. I don't think visual report builder is any useful for any of your forms at this time.
For example, this was created with Visual Report Builder:
But both of those questions were "radio button" questions.
- ThomasMcCannAnswered on January 21, 2011 at 06:20 PM
taking your advice I have managed a simple report by using check boxes. Could you please explain what the 'Entry Limit' means. i.e. does this mean there is an absolute maximum number of submissions that can be used for the graph? Or does it mean something completely different?
- JotForm FounderaytekinAnswered on January 24, 2011 at 05:49 AM
Let's say you have a "State" dropdown. Trying to show 50 entries on the same graph would be not be very useful. If you set "Entry Limit" to 10, you would only see the top 10 states by count.
- ThomasMcCannAnswered on January 25, 2011 at 06:21 PM
that makes total sense now.