- marcellobrazilAsked on October 19, 2017 at 02:24 PM
I created 3 kind of users. I wanna check what date/time they send the form. Maybe I will need a field for each one but I dont know where I can get this info
THANKS FOR YOUR HELP
- JotForm SupportJohn_BensonAnswered on October 19, 2017 at 04:04 PM
Can you please provide more details of what you're trying to achieve?
To my understanding, you have 3 kinds of users.
Are they going to edit one submission?
You can enable the Send on Edit of the notification email. You can track the time and date whenever you receive the notification email of the edited submission.
You can also add a hidden Date/Time field on your form and set it to "Current Date/Time". See image below:
- marcellobrazilAnswered on October 19, 2017 at 04:10 PM
I did everthing you said. But this didnt solve 100%
I need this
Fornecedor envia form Compras recebe e envia form no dia 10/10/17 as 14h “Data/Hora compras” salva o tempo copiando do campo padrão Mkt recebe e envia form no dia 10/10/17 as 16h “Data/Hora mkt” salva o tempo copiando o campo padrão, o qual atualiza automaticamente para 10/10/17 as 12h Celula recebe e envia form no dia 11/10/17 as 9h “Data/Hora mkt” salva o tempo copiando o campo padrão, o qual atualiza automaticamente para 11/10/17 as 9h
- JotForm SupportBDAVIDAnswered on October 19, 2017 at 07:17 PM
Basically, you want to keep the original submission date?
What you can do is to pass the date field value to another date field, which should have a NONE default date, through conditions: https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-a-Condition
First you would need to add the Get Form Page URL widget:
Then, create a condition like this:
Let us know if you have more questions, we will be glad to assist you.
- marcellobrazilAnswered on October 20, 2017 at 07:54 AM
"Basically, you want to keep the original submission date?"
I wanna to keep the date/time when Fornecedor submit the form.
Also, I wanna to keep the date/time when Compras submit the form.
Also, the same thing for Marketing and Celula.
- JotForm SupportJohn_BensonAnswered on October 20, 2017 at 11:18 AM
Unfortunately, this is not possible on the Edit Submission feature. Once you edited the form data, the Submission will be updated as well. It means that when you update the Name and the Date/Time then the previous submission data will be replaced with a new one.
You're correct, you will need a separate field for each user to track it properly.
Related guide: A-General-Approach-on-Building-an-Approval-Process-Workflow
I hope this information helps.
- marcellobrazilAnswered on October 20, 2017 at 11:37 AM
I really need to record the date/time. Are you sure it is impossible to do that?
When I download the answers in the Excel it has this information. Maybe a field that record each part of the form it is the answer.
Or something if the calculate condition. Can I stop the calculation? For example I copy the field Date today and tomorrow its stops to copying.
- JotForm SupportBDAVIDAnswered on October 20, 2017 at 12:30 PM
What you are trying to accomplish is complex, the only option would be adding a Date field for each department, and having the user to manually input the date and time when submitting the form.
- marcellobrazilAnswered on October 20, 2017 at 12:43 PM
This need to be automatically. I need a field that record the date/time when you send the form, is it complex? I have no ideia, sorry if I were rude with "is it complex?"
- JotForm SupportBDAVIDAnswered on October 20, 2017 at 01:05 PM
We really want to help you, however, our date time submission feature updates each time the form gets re-submitted through the edit link. And we do not have a specific feature that automatically records the "date and time" each time a submission gets re-submitted.
- marcellobrazilAnswered on October 20, 2017 at 01:21 PM
is it hard to create date/time for Edit Link Submission? Or to have a condition to active a field?
- JotForm SupportJohn_BensonAnswered on October 20, 2017 at 01:57 PM
Let me try to create a workaround for this issue. I will contact you again on this thread once I am done with the demo form.
- marcellobrazilAnswered on October 20, 2017 at 02:02 PM
NICE! THANKS FOR YOUR HELP!! I will be waiting
- JotForm SupportJohn_BensonAnswered on October 21, 2017 at 05:22 PM
Sorry for the delay.
Here's the demo form (Workaround): https://form.jotform.com/72924640728967
To test the demo form, please clone it by following this guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
In the demo form, I added the Configurable List widget to record the edit logs. Here's a screen animation sample:
Here's the final submission looks like:
To view your submission page, please follow this guide: https://www.jotform.com/help/269-How-to-View-Form-Submissions
Let us know if you have any questions or need further assistance. Thank you.
- marcellobrazilAnswered on October 23, 2017 at 08:32 AM
But for that the user needs to fill the field, I need it to be automatically
- JotForm SupportKevin_GAnswered on October 23, 2017 at 11:39 AM
Unfortunately, it's not possible to automatically fill the Configurable List widget (used on my colleague's example).
Also, please note that the data is saved when the submit button is changed, so far there is not way to have a date picker or another field to automatically change its value (which would help yo know the last edit date).
Currently, you will need to use the workaround provided by my colleague and ask your users to fill the last edit logs, JotForm does not save the submissions edit logs either.
- marcellobrazilAnswered on October 23, 2017 at 11:59 AM
Can you talk with the developers if it is hard to create this field? I think for some people it is important to record the date and time when the form was submit (even in Edit Link)
- JotForm SupportKevin_GAnswered on October 23, 2017 at 01:20 PM
I will forward this to our second level as feature request, although we cannot provide an ETA, we will let you know as soon as we receive any updates about it.
- marcellobrazilAnswered on October 24, 2017 at 09:20 AM
- marcellobrazilAnswered on October 30, 2017 at 09:48 AM
- JotForm SupportJohn_BensonAnswered on October 30, 2017 at 10:54 AM
We still do not have an update to our developers regarding on this issue. We will contact you again on this thread once we have any updates.