I want to create a table from the submissions to put in a website

  • WheelsofJustice
    Asked on May 1, 2016 at 6:42 PM

    it is a weebly website, I currently gather the submissions from Weebly via jotforms, I have the info going to google forms, but would like to gather just three fields and put them on a website, hopefully being able to sort them

     

    any suggestions?

     

    thx

  • Kevin Support Team Lead
    Replied on May 1, 2016 at 10:15 PM

    Yes this is possible to do with JotForm, you may even select which fields should be displayed in the report and then embed it in your website. 

    Here are some links that will help you to get the result of submissions as tables: 

    How-to-create-an-HTML-Table-Listing-Report

    How-to-create-a-Grid-Listing-report

    There you will find the steps to get the link or embed code as well, you should be able to add this code to your website and it will be embedded as you need. 

  • WheelsofJustice
    Replied on May 2, 2016 at 9:37 AM

    can you sort them?

     

    thanks

  • victor
    Replied on May 2, 2016 at 11:20 AM

    Depending on the report you are using, you should be able to order them as you like. If you are using the HTML report, you will notice small icons next to each field. This will enable you to sort it ascending or descending order by that particular item.

    I want to create a table from the submissions to put in a website Image 1 Screenshot 20 

    Please let us know what type of report you are creating so we may better assist.

  • WheelsofJustice
    Replied on May 2, 2016 at 5:45 PM
    this might work, but here is what I need
    I need to create supplement this form "Musicians" and add two fields, Venue and time, this info will be added later by us after we figure out where bands will be playing and assigned a time
    I think I can add these fields to Musicians and "hide them" from public view but they will be in the report and then we can edit each entry and add this info to them and then create an HTML file that is sortable by time and venue
    Is there anyway to limit the with of the field in the html report and to left justify the entries?
    Would that work, or is there a better way
    thank you for a great product
    Scott
    ...
  • Kevin Support Team Lead
    Replied on May 2, 2016 at 7:29 PM

    Regarding to hide the fields that you want and update them on a later date when you already have figured out where the band will be playing, I think that this may work, for example you may set the fields as hidden to the submitter when he/she is filling the form, but then you may edit this fields by editing the submission

    When creating the report you will get a window where you will be asked to un-check the fields that you want to show in the report, there you will be able to either show or not those fields. 

    I want to create a table from the submissions to put in a website Image 1 Screenshot 20

    Regarding to customize the layout of the report, this is not currently possible, you only are able to generate the report and embed it anywhere you want, if you would like to have this feature, I would suggest you to open a new thread and request it, we will be glad to escalate it to our second level as  a  feature request. 

     

  • WheelsofJustice
    Replied on May 2, 2016 at 7:45 PM
    when I go to edit and add info into the field, how do I "save it" the new data disappears when i click to another record
    also, is there a way to limit the width of the fields in the html
    thx
    ...
  • victor
    Replied on May 2, 2016 at 8:53 PM

    You are not allow to edit any information in the report, as this will break the link between the report and the form. A possible work around would be to integrate your form to google spreadsheet. Even though you are not allow to edit the data, you can copy all the information to another spreadsheet where you can freely edit the data as you like. If you would like a sample or require formulas to copy the information into another spreadsheet, please let us know. We will be glad to help.