- DTelegramAsked on August 24, 2017 at 04: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!
- JotForm SupportBDAVIDAnswered on August 24, 2017 at 05: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 Range: https://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.