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

    Google Spreadsheets - new submissions at TOP of spreadsheet; and, Tabs

    Asked by rockviewlodge on September 25, 2012 at 01:38 PM

    LOVE The Google integration. At the risk of sounding ungrateful - which I'm totally not - I have some questions/feature requests

    - It would be a LOT more sensible for our usage if new submissions were found at the TOP of the spreadsheet rather than having to scroll all the way to the bottom each time.

    - It would also be very cool if JotForm offered an option to drop in a hyperlink into one column that pointed back to that submission's entry on my Jotform account.

    - I have three different contact forms on my website. Would be GREAT if they could all dump onto the same spreadsheet, or at least different tabs on the same spreadsheet. 

    - Since one of my forms is in a sidebar that appears throughout my site, it would be great to have the referrming page's URL so I knew where the client was when they filled out the form.


    Thanks!

    MMC in Oakland

    Page URL:
    rockviewlodge.com

    Submissions My Forms contact forms JotForm
  • Profile Image

    Answered by jeanettebmz on September 25, 2012 at 02:27 PM

    Please find my answers below:

    - It would be a LOT more sensible for our usage if new submissions were found at the TOP of the spreadsheet rather than having to scroll all the way to the bottom each time.

    Google spreadsheet is like Excel. you can sort it descendet or ascendent to have new submissions to the TOP

     

    - It would also be very cool if JotForm offered an option to drop in a hyperlink into one column that pointed back to that submission's entry on my Jotform account.

    You can open your google spreadshee into another tab so you have both.

     

    - I have three different contact forms on my website. Would be GREAT if they could all dump onto the same spreadsheet, or at least different tabs on the same spreadsheet. 

    I don't know if this is something the developer team will find it feasible.

    A workaround would be  to use the =importrange function into another sheet within the same document.


    - Since one of my forms is in a sidebar that appears throughout my site, it would be great to have the referrming page's URL so I knew where the client was when they filled out the form.

    Please check this guide in order to know which URL a submision came from

     

    Cheers!

     

  • Profile Image

    Answered by stevenyilin on October 07, 2012 at 02:21 PM

    dear jeanette

     

    Google spreadsheet is like Excel. you can sort it descendet or ascendent to have new submissions to the TOP

    in regards to your first answer - i have the same problem.

    it my seem obvious; but  your simple solution doesnt work, because for some reason the submission date is passed onto google in the format:

    month-day-year. hence the entries are listed by month with total disregard of the year. hence, the data on google spreadsheet is a total  mubojumbo.

    whereas the  same data stored and viewed on the jotform website under "myforms" is in the format year-month-day.

    i ve also tried the menupoint: format->number->date format variations.... doesnt seem to work however!

    cheers,

     

    steve

  • Profile Image
    JotForm Support

    Answered by idarktech on October 07, 2012 at 04:06 PM

    Hello Steve,

    How about creating another column and then use datevalue formula to convert dates stored as text to dates. Example:

    =DATEVALUE(A2)

    A2 is where the first date cell starts, then drag it to mimic the style to all other date cells. After that, use this column to sort your form submissions.

    Hope this works for you. Thanks!

  • Profile Image

    Answered by stevenyilin on October 23, 2012 at 09:39 AM

    hi idark,

    thanks... worked for a2 ;)

    how do i apply this formula to hundreds of entries?

  • Profile Image
    JotForm Support

    Answered by idarktech on October 23, 2012 at 10:48 AM

    Hello Steve,

    Glad your back :)

    To apply it to all your entries below, just simply hold the placeholder of the first cell containing that formula and drag it below. Check this screenshot:

    Thanks!

  • Profile Image

    Answered by NETFIRM  on July 14, 2015 at 12:33 AM

    Solutions = Run a Script from the time of submission to display newest submissions on top!

    1. Open the Script Editor for your Google Sheet from the Main Menu > Tools > Script Editor

    2. On the left, click on Jotform.gs and paste the below script on a new line after </script>

    3. Change "Submissions" to the actual name of your sheet. SAVE!

    4. Script Editor Menu > Resources > Current project's triggers

    5. Add a new trigger > Run onFormSubmit - Events From spreadsheet - On form submit. SAVE!

    Note: If not already actioned, provide JotForm with Authorisation to your Google Sheets account to allow Integration.

    6. Script Editor Menu > Run > onFormSubmit. SAVE!

    7. Debug to check for Errors (if any)

    8. Refresh your Google Sheet, and you should see that your Data should be now sorted to display Newest Submissions at the Top.

     

    function onFormSubmit() 

    {

      var sheet = SpreadsheetApp.getActiveSpreadsheet();

      var target = sheet.getSheetByName("Submissions");

      

      target.sort(1, false);

     

      var wrap = target.getDataRange();

      wrap.setWrap(true)

     

    }

  • Profile Image
    JotForm Support

    Answered by BJoanna on July 14, 2015 at 03:25 AM

    Thanks for sharing to us the solution/workaround you have created. We will take your experience to try to help other users with the same problem. 

    Feel free to contact us if you have any other questions.