Question on integrating with google docs

  • DTelegram
    Asked on August 24, 2017 at 4:31 PM

    We're integrating two of our forms with google sheets and things are working nicely thus far.  Our forms are actually insertion orders submitted by our sales force.  Each order has a start date for the ad they're ordering.  Is it at all possible to have the info from the form flow in to the google sheet in order by that start date?  Or someone I can set that up to happen?   

     

    Please advise and thanks for all the wonderful things you provide through JotForm!

  • David JotForm Support Manager
    Replied on August 24, 2017 at 5:37 PM

    No, they will be listed in the order that they are submitted. Please avoid applying any changes on the integrated spreadsheet, because it may stop working.

    You could try pulling the information to another spreadsheet by using the Import Rangehttps://support.google.com/docs/answer/3093340?hl=en 

    Then, you can apply filters to this new spreadsheet to sort your data based on the date column: https://support.google.com/docs/answer/3540681?co=GENIE.Platform%3DDesktop&hl=en 

    Open a new thread if you need anything else, we will be glad to assist you.