Title: Date Submitted Field Last modified: June 22, 2020 --- # Date Submitted Field * Resolved [elieelia9](https://wordpress.org/support/users/elieelia9/) * (@elieelia9) * [6 years, 1 month ago](https://wordpress.org/support/topic/date-submitted-field/) * Hello, * I have integrated google sheets with my forminator forms, however the date submitted field is not appearing as a field in google sheets. I’ve had to manually add datepickers with the default date to all my fields, but I can’t seem to add a timestamp field to provide the default time as well? * In addition, I was trying to enable caching of very long forms which save the users data and allow them to come back to the form at a later time. I came across the following post in the support forums which suggested using the following code snippet: [https://gist.github.com/wpmudev-sls/9917696b87543e3edb92e84f41933be0](https://gist.github.com/wpmudev-sls/9917696b87543e3edb92e84f41933be0) * Am I correct to add this in mu-plugins folder and this should enable caching of selected answers in forms? It is not currently doing so Viewing 4 replies - 1 through 4 (of 4 total) * Plugin Support [Imran – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support9/) * (@wpmudev-support9) * [6 years, 1 month ago](https://wordpress.org/support/topic/date-submitted-field/#post-13023960) * Hello [@elieelia9](https://wordpress.org/support/users/elieelia9/) * I trust you’re doing well! * I’ve tested the Forminator form on my end and the date field along with Time Picker was exported to Google Drive Sheets from my end. * Would you please export your form, from Forminatir > Forms > click on settings icon > Export and share it with us so we could investigate it further? * Please see this screenshot: [https://monosnap.com/file/jD52mrLUZbvf5NulIjYjM9SsitzQh7](https://monosnap.com/file/jD52mrLUZbvf5NulIjYjM9SsitzQh7) * Upload the export file to Google Drive or to a DropBox, or you can use a Pastebin. com and share a download link with us * As for the custom snippet, I could replicate the same issue and have asked our developers to have a closer look. We will follow back once there will be an update. * Kind regards, Nastia * Thread Starter [elieelia9](https://wordpress.org/support/users/elieelia9/) * (@elieelia9) * [6 years ago](https://wordpress.org/support/topic/date-submitted-field/#post-13025512) * Hi [@wpmudev-support9](https://wordpress.org/support/users/wpmudev-support9/), thank you for your reply. * I am not currently using a timepicker field as it has no option to grab the time of form submission automatically and requires the user to input that info. I rather want the information of date and time of when the form was submitted to appear in a column in my google sheets integration. * My current form submissions have a ‘Date Submitted’ field by default from forminator for every submission, but this field is not appearing in my google sheets integration and only appears in the submissions dashboard or csv export. * I have worked around this issue by adding a datepicker field that by default is today’s current date, but there is no option to add the timepicker field that by default is today’s current time. * Plugin Support [Imran – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support9/) * (@wpmudev-support9) * [6 years ago](https://wordpress.org/support/topic/date-submitted-field/#post-13031792) * Hello [@elieelia9](https://wordpress.org/support/users/elieelia9/) * I trust you’re doing well! * In the following custom snippet, please locate on a line 26 the following: * `$allowed_form_ids = array( 6, 12, 345, 6434 );` * Replace this line with this code: `$allowed_form_ids = array();` * This will save user’s data in a browser and the user can come back after some time again and continue from where the form was left. * > My current form submissions have a ‘Date Submitted’ field by default from forminator > for every submission, but this field is not appearing in my google sheets integration > and only appears in the submissions dashboard or csv export. * Please elaborate, what files you have added to the Google Sheet? Have you applied a certain formula? * Please feel free to try out the following solution: [https://yagisanatode.com/2018/02/21/add-the-current-date-to-a-sheet-when-data-is-added-so-that-the-date-does-not-changestatic-google-sheets/](https://yagisanatode.com/2018/02/21/add-the-current-date-to-a-sheet-when-data-is-added-so-that-the-date-does-not-changestatic-google-sheets/) * I hope this helps! * Kind regards, Nastia * Plugin Support [Imran – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support9/) * (@wpmudev-support9) * [6 years ago](https://wordpress.org/support/topic/date-submitted-field/#post-13058828) * Hello [@elieelia9](https://wordpress.org/support/users/elieelia9/) * I hope you are doing well! * We haven’t heard back from you for a while now so we’ve marked this ticket as resolved. If you do have any followup questions or require further assistance feel free to reopen it and let us know here. * Kind regards, Nastia Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Date Submitted Field’ is closed to new replies. * ![](https://ps.w.org/forminator/assets/icon-256x256.gif?rev=3443182) * [Forminator Forms – Contact Form, Payment Form & Custom Form Builder](https://wordpress.org/plugins/forminator/) * [Frequently Asked Questions](https://wordpress.org/plugins/forminator/#faq) * [Support Threads](https://wordpress.org/support/plugin/forminator/) * [Active Topics](https://wordpress.org/support/plugin/forminator/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/forminator/unresolved/) * [Reviews](https://wordpress.org/support/plugin/forminator/reviews/) * 4 replies * 2 participants * Last reply from: [Imran – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support9/) * Last activity: [6 years ago](https://wordpress.org/support/topic/date-submitted-field/#post-13058828) * Status: resolved