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.


  • Profile Image

    Is there any way to sort attached files by the answer gathered in the form ?

    Asked by AndrewSauvageau on February 10, 2014 at 01:22 PM

    For exemple, if i build an application form for my company. i ask many questions like "Where do u want to postulate", there is 2 choices, Montreal or Trois-Rivières. Another question is "What is your title", 2 choices, technician or engineer. After all the form filled, they must attach a CV. I wanna know if there is any way to access the data base to only get the CVs from peopl who postulated Engineer and Montréal. 

  • Profile Image
    JotForm Support

    Answered by BDAVID on February 10, 2014 at 02:40 PM

    Hi, as far as I know there is not a feature to find some data based on a choice. I was trying to find a widget that would allow to accomplish that, but I can see there is not such a widget yet. What I would recommed you, is to integrate your form with Google Spreadsheet, there you could search the data by typing  technician or engineer.

    Hope this helps you, if you have another question, please open a new thread, we will be glad to assist you.

  • Profile Image

    Answered by AndrewSauvageau on February 10, 2014 at 03:13 PM

    Thank you very much for offering this possibilty, but, i tried it and it doesnt seem to be working, when i try to acces my spreadsheet i get this error

    Désolé.

    L'URL de la feuille de calcul n'est pas valide. 

    Pour en savoir plus, consultez le Centre d'aide Google Documents.

  • Profile Image

    Answered by Cesar on February 10, 2014 at 03:42 PM

    You can also create a Grid Report and filter your submissions there. To do so highlight the form you are working with and click on the Reports | Add New Report option

    https://shots.jotform.com/cesar/screens/grid.jpg

     

    Do let us know if you need further assistance. Thank you.

  • Profile Image

    Answered by AndrewSauvageau on February 10, 2014 at 03:55 PM

    I like that way Cesar, this way, i can import the result into access and make a prog that will do specific search, but i have to make a new Report every time i get new submissions ?

  • Profile Image
    JotForm Support

    Answered by EltonCris on February 10, 2014 at 04:34 PM

    @AndrewSauvageau

    Grid listing actually comes with a search function. It's found under the bottom left part of the grid report page.

    Example: http://www.jotform.com/grid/40406486416050

    You can also integrate your form to your Dropbox or Box account so the files uploaded to your form will go straight to these file upload services. This way, you only have to checked your Dropbox or Box account if there are new files uploaded to your form.

    Let us know should you have further questions. Regards!

  • Profile Image

    Answered by AndrewSauvageau on February 11, 2014 at 08:59 AM

    I appreciate that u take time for answering.
    The grid list is a good looking page but the searh function is only for one word, my wish is to find by  a more specific result with multiple search that are contained in one row. i was able to import the data in excel then import from excel to Access but when i get a new submission, it doesnt update, i gotta import again, im wiling to upgrade to at least prenium but i gotta make sure i can get what i really want. 

  • Profile Image

    Answered by EliezerN on February 11, 2014 at 10:36 AM

    Hi,

    Did you already try our Excel2Drobox app? It allows you to export/store your Excel reports to your Dropbox account and you'll be able to automatically update new Excel report data in your Dropbox folder!

    I you have not tried it yet, please give it a try, that might be what you are looking for. You can find our app here: http://apps.jotform.com/app/excel2dropbox

    Please inform us if you need further assistance with this inquiry.

    Thanks

  • Profile Image

    Answered by AndrewSauvageau on February 11, 2014 at 11:31 AM

    I tried it but unfortunately, it doesnt update. Even if it would update, i gotta download my excel file each time i want to see the result.

  • Profile Image
    JotForm Support

    Answered by jonathan on February 11, 2014 at 12:09 PM

    Hi,

    Even if it would update, i gotta download my excel file each time i want to see the result.

    If you have MS Excel application on your computer, you will not have to download the Excel file evey time to view the report. You can open the Excel file directly on the Dropbox path by setting its web URL path to the Excel application when opening the file.

     

    Hope this help. Inform us if you need further assistance.

    Thanks.

  • Profile Image
    JotForm Support

    Answered by jonathan on February 11, 2014 at 12:12 PM

    Correction:

    Hi,

    In the screenshot I provided, I meant copy the URL path first and Paste it to that box and click Open.

    Thanks.

  • Profile Image

    Answered by AndrewSauvageau on February 11, 2014 at 02:44 PM

    i'm sorry but i dont get the picture.
    What do i copy and where do i copy it.
    Thx for answering !! 

  • Profile Image

    Answered by AndrewSauvageau on February 11, 2014 at 03:21 PM

    Finally, it updated, i really like that, it just take like 20 to 30 min to update but it works, ill keep u informed if i have further question. Thank you very much, very good services so far !!!