Hello @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
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
Hi @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.
Hello @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/
I hope this helps!
Kind regards,
Nastia
Hello @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
