-
marcellobrazilAsked on October 19, 2017 at 2: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 -
John_BensonReplied on October 19, 2017 at 4:04 PM
Can you please provide more details of what you're trying to achieve?
To my understanding, you have 3 kinds of users.
User 1:
User 2:
User 3:
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:
-
marcellobrazilReplied on October 19, 2017 at 4:10 PM
https://form.jotformz.com/71225598854669
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 -
David JotForm Support ManagerReplied on October 19, 2017 at 7: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.
-
marcellobrazilReplied on October 20, 2017 at 7: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.
https://form.jotformz.com/71225598854669 -
marcellobrazilReplied on October 20, 2017 at 7:56 AM
For example:
Fornecedor will submit at 8h30 in 10/20
Compras will receive and submit at 9h30 at 10/20
Marketing will receive and submit at 8h at 10/21
Celula will receive and submit at 14h at 10/21
I wanna record the time and date for each user -
John_BensonReplied 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.
-
marcellobrazilReplied 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. -
David JotForm Support ManagerReplied 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.
-
marcellobrazilReplied 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?"
-
David JotForm Support ManagerReplied on October 20, 2017 at 1: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.
-
marcellobrazilReplied on October 20, 2017 at 1:21 PM
is it hard to create date/time for Edit Link Submission? Or to have a condition to active a field?
-
John_BensonReplied on October 20, 2017 at 1: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.
Thank you.
-
marcellobrazilReplied on October 20, 2017 at 2:02 PM
NICE! THANKS FOR YOUR HELP!! I will be waiting
-
John_BensonReplied on October 21, 2017 at 5: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.
-
marcellobrazilReplied on October 23, 2017 at 8:32 AM
But for that the user needs to fill the field, I need it to be automatically
-
Kevin Support Team LeadReplied 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.
-
marcellobrazilReplied 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)
-
Kevin Support Team LeadReplied on October 23, 2017 at 1: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.
-
marcellobrazilReplied on October 24, 2017 at 9:20 AM
nice, thanks!
-
marcellobrazilReplied on October 30, 2017 at 9:48 AM
any news?
-
John_BensonReplied 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.
Thank you.